EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Replication vs DRBD Battles

 | April 28, 2008 |  Posted In: Insight for DBAs

Well these days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high availability practice. I personally think DRBD has its place but there are far more cases when other techniques would work much better for variety of reasons. First let me start with Florian’s comments […]

Read More

MySQL Architecture meeting at Google

 | April 24, 2008 |  Posted In: Events and Announcements

Friday after MySQL Users Conference we had a smaller meeting at Google campus to talk about MySQL architecture mainly focusing on storage engine vendors and other extension areas. It was very interesting to see all these storage engine interface extensions which are planned for MySQL 6.0 and beyond – abilities to intercept query execution or […]

Read More

MySQL extensions for hosting

 | April 24, 2008 |  Posted In: Percona Software

A few weeks ago I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically check what data […]

Read More

Efficient Boolean value storage for Innodb Tables

 | April 23, 2008 |  Posted In: Insight for Developers

Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if you get many columns and many rows you may want to store them as efficient way as possible. For MyISAM tables you could use BIT(1) fields which get combined together for efficient storage:

Read More

Conference for MySQL Users

 | April 23, 2008 |  Posted In: Events and Announcements

If you’re following PlanetMySQL you’ve already seen Baron’s post about MySQL Conference which many of us just have returned from. It was great event as well as 5 conferences I’ve been before that, though however it more and more becomes MySQL marketing channel and business event rather than Users Conference as it originated. This Year […]

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.