EmergencyEMERGENCY? Get 24/7 Help Now!

super_read_only and GTID replication

 | September 8, 2015 |  Posted In: MySQL, Percona Server

Percona Server 5.6.21+ and MySQL 5.7.8+ offer the super_read_only option that was first implemented in WebscaleSQL. Unlike read_only, this option prevents all users from running writes (even those with the SUPER privilege). Sure enough, this is a great feature, but what’s the relation with GTID? Read on! TL;DR Enabling super_read_only on all slaves when using […]

Read More

The MySQL query cache: Worst enemy or best friend?

 | August 7, 2015 |  Posted In: Benchmarks, MySQL

During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very useful. That was counter-intuitive for me as I’ve always expected the […]

Read More

SELinux and the MySQL init script

 | July 22, 2015 |  Posted In: MySQL, Percona Server

I recently worked with a customer who had a weird issue: when their MySQL server was started (Percona Server 5.5), if they try to run service mysql start a second time, the init script was not able to detect that an instance was already running. As a result, it tried to start a second instance […]

Read More

Percona XtraDB Cluster: Quorum and Availability of the cluster

 | June 12, 2015 |  Posted In: MySQL

Percona XtraDB Cluster (PXC) has become a popular option to provide high availability for MySQL servers. However many people are still having a hard time understanding what will happen to the cluster when one or several nodes leave the cluster (gracefully or ungracefully). This is what we will clarify in this post. Nodes leaving gracefully […]

Read More

Optimizing Percona XtraDB Cluster for write hotspots

 | June 3, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona XtraDB Cluster

Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance degradation. When using Percona XtraDB Cluster (PXC), some users try to solve this specific […]

Read More

Storing time-series data with MongoDB and TokuMX

 | May 26, 2015 |  Posted In: MongoDB

Storing time-series data is a frequent pattern for databases – be it for logs or for any kind of monitoring. Such data has the following properties: records are inserted but also never updated, the insertion rate can be high and records are likely to expire after some time. MongoDB and TokuMX are both good fits […]

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.