(Jay Janssen) In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it can be handy if you already had backups available to use.

(Rob Gravelle) All programming languages incorporate some sort of error handling mechanism for handling unexpected occurrences and a graceful exit from the application if need be. MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 (as per the SQL 2003 spec) to serve that purpose.

(Rob Gravelle) All programming languages incorporate some sort of error handling mechanism for handling unexpected occurrences and a graceful exit from the application if need be. MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 (as per the SQL 2003 spec) to serve that purpose.

(dba square) Recently we got request from our customer that something is going wrong with their database and they’re are getting strange errors after each insert or update to specific table. The strangeness caused by “Unknown column ‘column-name’ in ‘field list’” message while this column was existi

(dba square) Recently we got request from our customer that something is going wrong with their database and they’re are getting strange errors after each insert or update to specific table. The strangeness caused by “Unknown column ‘column-name’ in ‘field list’” message while this column was existi

(Paul Moen) The Percona version of MySQL has been such a good replacement for the generic MySQL version that many of the features and options that existed in Percona have been merged into the generic MySQL.

(Paul Moen) The Percona version of MySQL has been such a good replacement for the generic MySQL version that many of the features and options that existed in Percona have been merged into the generic MySQL.

(Ike Walker) I’ve written two separate posts about the MySQL 5.6 temporal column format change, but I haven’t yet addressed the problem with the way this upgrade was implemented.

(Ike Walker) I’ve written two separate posts about the MySQL 5.6 temporal column format change, but I haven’t yet addressed the problem with the way this upgrade was implemented.

(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.