EmergencyEMERGENCY? Get 24/7 Help Now!

A technical WebScaleSQL review and comparison with Percona Server

 | May 22, 2014 |  Posted In: Insight for Developers, MySQL, Percona Server, Percona Software

The recent WebScaleSQL announcement has made quite a splash in the MySQL community over the last few weeks, and with a good reason. The collaboration between the major MySQL-at-scale users to develop a single code branch that addresses the needs of, well, web scale, is going to benefit the whole community. But I feel that […]

Read More

Managing farms of MySQL servers with MySQL Fabric

and  | April 25, 2014 |  Posted In: High-availability, Insight for DBAs, Insight for Developers, MySQL

While built-in replication has been a major cause for MySQL’s wide adoption, official tools to help DBAs manage replication topologies have typically been missing from the picture. The community has produced many good products to fill in this gap, but recently, Oracle has been filling it too with the addition of MySQL Utilities to the mix. One […]

Read More

Innodb redo log archiving

 | March 28, 2014 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Server, Percona XtraBackup

Percona Server 5.6.11-60.3 introduces a new “log archiving” feature. Percona XtraBackup 2.1.5 supports “apply archived logs.” What does it mean and how it can be used? Percona products propose three kinds of incremental backups. The first is full scan of data files and comparison the data with backup data to find some delta. This approach […]

Read More

Open Source Appreciation Day at the Percona Live MySQL Conference

 | March 13, 2014 |  Posted In: Events and Announcements, High-availability, Insight for DBAs, Insight for Developers, MySQL, OpenStack, Percona Live, Percona Software, Percona XtraDB Cluster

I am very pleased to announce a new event in conjunction with the Percona Live MySQL Conference and Expo this year: Open Source Appreciation Day on Monday, March 31st in the Santa Clara Convention Center! We are pleased to announce two separate groups holding events this year under this new umbrella. We are hosting an […]

Read More

Oracle’s Mats Kindahl to weave MySQL Fabric into Percona Live session

 | March 3, 2014 |  Posted In: High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona Live

MySQL Fabric is an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. Its development has been spearheaded by Mats Kindahl, senior principal software developer in MySQL at Oracle. Mats is leading the MySQL Scaling and High-Availability effort covering the newly released MySQL Fabric and the MySQL Applier for […]

Read More

How to avoid common (but deadly) MySQL development mistakes

 | February 28, 2014 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars

MySQL software developers are under pressure to do more in less time and create applications that adapt to ever-changing requirements. And it’s true that some of a developer’s time is wasted when his or her method of optimizing involves trying every combination of code and index definition. There is a better way. And next Wednesday […]

Read More

WITHer Recursive Queries?

 | February 11, 2014 |  Posted In: Insight for Developers, MySQL, query tuning

Over the past few years, we’ve seen MySQL technology advance in leaps and bounds, especially when it comes to scalability. But by focusing on the internals of the storage engine for so long, MySQL has fallen behind regarding support for advanced SQL features. SQLite, another popular open-source SQL database, just released version 3.8.3, including support […]

Read More

InnoDB file formats: Here is one pitfall to avoid

 | January 14, 2014 |  Posted In: Insight for Developers, MySQL

UPDATED: explaining the role of innodb_strict_mode and correcting introduction of innodb_file_format Compressed tables is an example of an InnoDB feature that became available with the Barracuda file format, introduced in the InnoDB plugin. They can bring significant gains in raw performance and scalability: given the data is stored in a compressed format the amount of […]

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.