(Dave Stokes) Automation software like Puppet, Chef, and Ansible can quickly load software on virtual servers. But how do you get your MySQL database instances loaded on these new servers? And how do you do it securely? Lets start with a fairly common pairing.
Tag: Open Source
Identifying Temporal Columns in Old Format in MySQL 5.6 and Above
(Ike Walker) I’ve gotten a lot of positive feedback from my post on upgrading temporal columns from MySQL 5.5 to MySQL 5.6 format, both in the blog comments and directly from people who have used my query to identify which columns are candidates to be upgraded to the new format.
Identifying Temporal Columns in Old Format in MySQL 5.6 and Above
(Ike Walker) I’ve gotten a lot of positive feedback from my post on upgrading temporal columns from MySQL 5.5 to MySQL 5.6 format, both in the blog comments and directly from people who have used my query to identify which columns are candidates to be upgraded to the new format.
How to create a rock-solid MySQL database backup & recovery strategy
(Akshay Suryawanshi) Have you ever wondered what could happen if your MySQL database goes down?
How to create a rock-solid MySQL database backup & recovery strategy
(Akshay Suryawanshi) Have you ever wondered what could happen if your MySQL database goes down?
Circular Partitioning scheme for a fully Automated Archival / Purge process with Events
(Praji) The advantage of partitioning is that we can drop / truncate the partitions which is real quick and done in seconds. It does lock the table (metadata lock) during this operation but only for few seconds.
Circular Partitioning scheme for a fully Automated Archival / Purge process with Events
(Praji) The advantage of partitioning is that we can drop / truncate the partitions which is real quick and done in seconds. It does lock the table (metadata lock) during this operation but only for few seconds.
How to obtain the MySQL version from an FRM file
(Fernando Ipar) I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to be rebuilt. The mysql_upgrade program should be run for every upgrade, no matter how big or small the version difference is, but when only the minor version changes, I
How to obtain the MySQL version from an FRM file
(Fernando Ipar) I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to be rebuilt. The mysql_upgrade program should be run for every upgrade, no matter how big or small the version difference is, but when only the minor version changes, I
ORDER BY CASE
(Michael McLaughlin) Sometimes I give parts of a solution to increase the play time to solve a problem. I didn’t anticipate a problem when showing how to perform a sort operation with a CASE statement. It’s a sweet solution when you need to sort something differently than a traditional ascending or