EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Toolkit 2.1.9 is ready

 | February 15, 2013 |  Posted In: Events and Announcements, Percona Software, Percona Toolkit

About a month ago, we held a bug raffle for Percona Toolkit 2.1.9.  The turnout was good and the resulting release is worth upgrading to, especially if you were affected by the backwards-incompatible changes to pt-heartbeat in 2.1.8.  Here are the release notes for Percona Toolkit 2.1.9 which highlight the bugs fixed: Percona Toolkit 2.1.9 has been released. […]

Read More

Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities

 | February 15, 2013 |  Posted In: Events and Announcements, Percona Software

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.2 — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, […]

Read More

Replication checksums in MySQL 5.6

 | February 15, 2013 |  Posted In: MySQL

MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between the master and its replicas is now enforced. As we’ll see, it’s not that […]

Read More

Amazon Web Services and HP Keynotes at Percona Live MySQL Conference and Expo

 | February 14, 2013 |  Posted In: Events and Announcements, MySQL, Percona Live

We are very pleased to announce the addition of HP and Amazon Web Services as keynote speakers for the Percona Live MySQL Conference and Expo which is April 22-25 in Santa Clara, California. Amazon Web Services is sending Simone Brunozzi, Senior Technology Evangelist, who will speak on “Databases in the Cloud: Present and Future.” HP […]

Read More

Announcing Percona XtraDB Cluster 5.5.29-23.7.2

 | February 13, 2013 |  Posted In: MySQL, Percona Software, XtraDB Cluster

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.29-23.7.2 on February 13th, 2013. Binaries are available from downloads area or from our software repositories. Bugs fixed: DML operations on temporary tables would try to append the key for provider library, which could cause a memory leak. Bug fixed for MyISAM temporary tables, […]

Read More

Fast Updates with TokuDB

 | February 12, 2013 |  Posted In: Tokutek, TokuView

With TokuDB v6.6 out now, I’m excited to present one of my favorite enhancements: fast updates with TokuDB. Update intensive applications can have their throughput limited by the random read capacity of the storage system. The cause of the throughput limit is the read-modify-write algorithm that MySQL uses when processing update statements. MySQL reads a […]

Read More

Percona Live MySQL Conference and Expo 2013: The talks I want to see

 | February 12, 2013 |  Posted In: Events and Announcements, MySQL, Percona Live

I’ve been woefully neglectful of my responsibilities to post regularly about Percona Live MySQL Conference and Expo 2013 (PLCME 2013), but here’s some highlights of what I am planning to attend from the schedule.  Read to the very bottom for the chance to win a free full pass to the conference! When picking talks to attend, […]

Read More

Unexpected problem with triggers and mysqldump

 | February 11, 2013 |  Posted In: MySQL

Some time ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump on the master, exporting separately the schema and the data, then edit the CREATE TABLE statements to ensure all tables are created with InnoDB, and reload everything […]

Read More

Adventures in archiving

 | February 11, 2013 |  Posted In: MySQL

One of our Remote DBA service clients recently had an issue with size on disk for a particular table; in short this table was some 25 million rows of application audit data with an on disk size of 345GB recorded solely for the purposes of debugging which may or may not occur. Faced with the task of […]

Read More

How to create/restore a slave using GTID replication in MySQL 5.6

 | February 8, 2013 |  Posted In: MySQL

MySQL 5.6 is GA! Now we have new things to play with and in my personal opinion the most interesting one is the new Global Transaction ID (GTID) support in replication. This post is not an explanation of what is GTID and how it works internally because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html One […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.