Today is Tutorial Day at MySQL Connect 2013 and yesterday was a blur. The Replication Road Map session started my day and it covered the long term development goals for MySQL Replication as well as more information on the Fabric sharding tool. Joro presented an amazing session on new security features along with some great tips for DBAs. Sadly I had to miss the other sessions as there was a meeting of the MySQL Storage Engine Partners (thanks to all the attendees) and the Oracle User Groups.
href="http://www.percona.com/software/percona-xtradb-cluster" target="_blank">Percona XtraDB Cluster (PXC) is different enough from async replication that it can be a bit of a puzzle how to do things the Galera way. This post will attempt to illustrate the basics of setting up 2 node PXC cluster from scratch.
class="alignright size-medium wp-image-17913" alt="InnoDB performance optimization basics" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/09/InnoDB-performance-optimization-basics-300x221.jpg" width="300" height="221" />I recently stumbled upon a post that Peter Zaitsev published back in 2007 titled “
class="alignright wp-image-12668" style="margin-top: 5px; margin-bottom: 5px;" alt="Percona XtraBackup for MySQL" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/Percona_XtraBackup.jpg" width="206" height="78" /> Percona is glad to announce the release of
href="http://www.percona.com/software/percona-xtrabackup">Percona XtraBackup 2.1.5 on September 19th, 2013. Downloads are available from our download site
Later this week I’m traveling to San Francisco to attend
href="http://www.oracle.com/mysqlconnect/index.html">MySQL Connect – which looks like an exciting event to be at. I’m going to deliver two talks at this show, both on Sunday –
href="https://oracleus.activeevents.com/2013/connect/sessionDetail.ww?eventRef=mysqlconnect&SESSION_ID=6029" target="_blank">MySQL Indexing Best Practices for MySQL 5.6 and
MySQL DBA and Developer Certification Exams are now in beta! Besides covering the new material in MySQL 5.6, you now have to pass one exam to earn the certification where previously you needed to pass two exams. Signup at Pearson Vue and reserve your exam. Testing will start in October.