EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Toolkit 2.2.3 released; bug fixes include pt-online-schema-change

 | June 28, 2013 |  Posted In: MySQL, Percona Toolkit

Among all of the excellent events going on like YAPC, Velocity, and Percona MySQL University, we recently released Percona Toolkit 2.2.3. It’s a small update that includes the following: pt-online-schema-change did not handle the failure of the DROP TRIGGER statements correctly Created pt-agent pt-query-digest –output json now includes more data The pt-online-schema-change issue had a high importance. […]

Read More

Percona Server 5.6.12-60.4 second Release Candidate now available

 | June 27, 2013 |  Posted In: MySQL, Percona Server for MySQL, Percona Software

Percona is glad to announce the second Release Candidate release of Percona Server 5.6.12-60.4 on June 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on the recently released MySQL 5.6.12, including all the bug fixes in it, Percona Server 5.6.12-60.4 is the second RC release in the Percona Server 5.6 series. […]

Read More

Limited disk space? Compact backups with Percona Xtrabackup 2.1

 | June 26, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona XtraBackup

One very interesting feature, “Compact Backup,” is introduced in Percona XtraBackup 2.1. You can run “compact backups” with the  –compact option, which is very useful for those who have limited disk space to keep the MySQL database backup. Now let’s first understand how it works. When we are using –compact option with Innobackupex, it will omit the […]

Read More

TokuMX is MongoDB on steroids

 | June 25, 2013 |  Posted In: Cloud and NoSQL, MySQL

I am actually quite excited about Tokutek’s release of TokuMX. I think it is going to change the landscape of database systems and it is finally something that made me looking into NoSQL. Why is TokuMX interesting? A few reasons: It comes with transactions, and all that good stuff that transactions provide: a concurrent access […]

Read More

Percona XtraDB Cluster 5.5.31-23.7.5 now available

 | June 25, 2013 |  Posted In: MySQL

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.31-23.7.5 on June 25, 2013. Binaries are available from the downloads area or from our software repositories. New Features: Information about the wsrep sequence number has been added to INFORMATION_SCHEMA.INNODB_TRX table. Percona XtraDB Cluster can now be bootstrapped with the new bootstrap-pxc option in […]

Read More

pt-online-schema-change and binlog_format

 | June 24, 2013 |  Posted In: Insight for DBAs, MySQL

Statement-based or row-based, or mixed?  We’ve all seen this discussed at length so I’m not trying to rehash tired arguments.  At a high level, the difference is simple: Statement based replication (SBR) replicates the SQL statements to the slave to be replayed Row based replication (RBR) replicates the actual rows changed to the slave to […]

Read More