EmergencyEMERGENCY? Get 24/7 Help Now!

Better high availability: MySQL and Percona XtraDB Cluster with good application design

 | December 21, 2015 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona XtraDB Cluster, Replication, XtraDB Cluster

High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of many reads, with usually few writes. There are exceptions of course – MMO games […]

Read More

Playing with Percona XtraDB Cluster in Docker

 | June 30, 2015 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, Quality Assurance, XtraDB Cluster

Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (here). There is also the MySQL Sandbox which can be used for the same […]

Read More

MaxScale: A new tool to solve your MySQL scalability problems

 | June 8, 2015 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, XtraDB Cluster

Ever since MySQL replication has existed, people have dreamed of a good solution to automatically split read from write operations, sending the writes to the MySQL master and load balancing the reads over a set of MySQL slaves. While if at first it seems easy to solve, the reality is far more complex. First, the […]

Read More

Q&A: Percona XtraDB Cluster as a MySQL HA solution for OpenStack

 | November 14, 2014 |  Posted In: MySQL, OpenStack, Percona XtraDB Cluster, Trove, XtraDB Cluster

Thanks to all who attended my Nov. 12 webinar titled, “Percona XtraDB Cluster as a MySQL HA Solution for OpenStack.” I had several questions which I covered at the end and a few that I didn’t. You can view the entire webinar and download the slides here. Q: Is the read,write speed reduced in Galera […]

Read More

Galera data on Percona Cloud Tools (and other MySQL monitoring tools)

 | August 29, 2014 |  Posted In: ClusterControl, MySQL, Percona Cloud Tools, Percona ClusterControl, Percona MySQL Support, Percona XtraDB Cluster, XtraDB Cluster

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and […]

Read More

Semi-Sync replication performance in MySQL 5.7.4 DMR

 | May 27, 2014 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

I was interested to hear about semi-sync replication improvements in MySQL’s 5.7.4 DMR release and decided to check it out.  I previously blogged about poor semi-sync performance and was pretty disappointed from semi-sync’s performance across WAN distances back then, particularly with many client threads. The Test The basic environment of these tests was: AWS EC2 […]

Read More

MySQL High Availability With Percona XtraDB Cluster (Percona MySQL Training)

 | May 21, 2014 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster, Training, XtraDB Cluster

I’ve had the opportunity to train lots of people on Percona XtraDB Cluster (PXC) over the last few years the product has existed.  This has taken the form of phone calls, emails, blog posts, webinars, and consulting engagements. This doesn’t count all the time I’ve spent grilling Codership on how things actually work.  But it […]

Read More

ClusterControl for Percona XtraDB Cluster Improves Management and Monitoring

 | February 4, 2014 |  Posted In: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona XtraDB Cluster, xtrabackup, XtraDB Cluster

ClusterControl for Percona XtraDB Cluster is now available in three different versions thanks to our partnership with Severalnines. ClusterControl will make it simpler to manage and monitor Percona XtraDB Cluster, MySQL Cluster, MySQL Replication, or MySQL Galera. I am very excited about our GA release of Percona XtraDB Cluster 5.6 last week. As Vadim described […]

Read More

The use of Iptables ClusterIP target as a load balancer for PXC, PRM, MHA and NDB

 | January 10, 2014 |  Posted In: High-availability, MySQL, NDB cluster, Percona replication manager, XtraDB Cluster

Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or software solution like haproxy. In both cases, in order to avoid having a single point of failure, […]

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.