(Fernando Laudares) I reckon there’s little sense in running 2 or more Percona XtraDB Cluster (PXC) nodes in a single physical server other than for educational and testing purposes – but doing so is still useful in those cases. The most popular way of achieving this seems to be with server virtuali

(Rob Gravelle) Not long after writing my Understanding the MySQL Information Schema Database article I realized that the title is just a little misleading. In MySQL, a schema and database are synonymous, so the phrasing of both “Schema” and “Database” is redundant. Lesson learned!

(Abhishek Ranjan) In 5.7.5, as a part of the larger effort to improve error handling, we re-implemented the IGNORE clause (WL#6614). The IGNORE clause is a MySQL extension to the SQL standard. It affects the errors which occur for each row.

(Shivji Jha) At MySQL, replication usability is of utmost importance to us. Replication information has long been part of SHOW commands, SHOW SLAVE STATUS occupying a major chunk of it. The other sources of replication information being:

(Shlomi Noach) MySQL’s UUID() and RAND() functions both provide with (pseudo) indeterministic result. UUID()’s result is moreover bound to the host on which it executes. For this reason, both are unsafe to replicate with STATEMENT binlog format. As an example, consider:

(Ritheesh Vedire) Multi-source replication for MySQL has been released as a part of 5.7.5-labs-preview downloadable from labs.mysql.com. It is one among the several features that are cooking in the replication technologies at MySQL.

(abdel-mawla) We have been asked several times by MySQL users about how to install multiple MySQL instances on a single host.

(Chris Calender) I still get asked about the lost+found directory enough, and so I wanted to provide a current update.

(Morgan Tocker) Labs releases are intended to provide early access to new features. As Gopal notes in his recent blog post About the Data Dictionary Labs Release, there is a notable restriction where upgrading from any previous MySQL database version is not supported.

(Jervin Real) A few months back, Michael wrote about reconnecting orphaned *.ibd files using MySQL 5.6. I will show you the same procedure, this time for partitioned tables. An InnoDB partition is also a self-contained tablespace in itself so you can use the same method described in the previous pos