Ronaldbradford - ronaldbradford.com
General Information:
Latest News:
MySQL MHA and Perl pathing 26 Aug 2013 | 09:54 pm
I am certainly not a knowledgeable Perl person, however I recently ran into the error Can’t locate MHA/MasterMonitor.pm on Red Hat 6.x. I have installed MySQL MHA on various systems before without any...
Cloning MySQL 5.6 instances 24 Aug 2013 | 02:59 am
A tip for all those cloud users that like cloning database servers (as reported in my book Effective MySQL – Replication Techniques in Depth). Starting with MySQL 5.6, MySQL instances have a UUID. Cl...
Unnecessary 3am (emergency) call 23 Aug 2013 | 03:00 pm
Help, the database is on fire. Well, it probably is but the solution may also be easy. Here are a few steps for the part-time MySQL DBA/sysadmin/developer. Total time to address this solution was 2 mi...
Identifying empty tables in MySQL 23 Aug 2013 | 02:39 am
The following simple INFORMATION_SCHEMA statement will identify and also verify tables that have no rows. These may be candidate tables to remove from your data model.
A simple FAILED SQL statement breaks MySQL 5.6 replication 8 Aug 2013 | 09:09 am
I setup 6 shiny new MySQL 5.6.13 MySQL servers, ready for testing and production deployment tomorrow. I found that the New Relic MySQL Monitoring was throwing the following error. Simple fix, the us...
DP#8 The disadvantages of row at a time processing 6 Aug 2013 | 06:11 am
It can be hard for software engineers to understand the following principle, however it is very important for improving performance and obtaining immediate scalability options. The principle is “Do Le...
MySQL configuration file created in /usr/my.cnf 3 Aug 2013 | 11:42 pm
As part of uncovering a new security improvement in MySQL 5.6 with the default installation being secured with a unique root MySQL password, the MySQL provided rpm’s installed the MySQL configuration ...
DP#4 The importance of using sql_mode 3 Aug 2013 | 10:43 pm
What if the data you retrieved from the database did not match the data the application claimed to had successfully stored? How comfortable would your organization feel about your skills and the produ...
Unexplained (trivial) MySQL behavior 2 Aug 2013 | 08:09 pm
The -N or –skip-column-names is a convenient option with the mysql client to skip the header line of output. However I found when viewing the output via the terminal, some interesting and unexplained...
Improved Security with MySQL 5.6 1 Aug 2013 | 10:28 pm
Installed on a clean CentOS 6.4 AWS instance. The following output is the sign that security is being considered with new MySQL versions. Woot! However, moving the MySQL configuration to /usr. WTF?
