EmergencyEMERGENCY? Get 24/7 Help Now!

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

High availability using MySQL in the cloud

 | June 4, 2015 |  Posted In: High-availability, MySQL, OpenStack

Next Wednesday (June 10) I’ll be co-presenting a webinar on using MySQL in the cloud for High Availability (HA). Joining me will be 451 Research analyst Jason Stamper and together we’ll talk about the realities of HA using MySQL in the cloud and how vendors are responding to changing application requirements with new developments that […]

Read More

MySQL ring replication: Why it is a bad option

 | October 7, 2014 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona MySQL Consulting

I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get write scalability. Alas, this is simply not true. Here is why. High Availability Having several […]

Read More

OpenStack: A MySQL DBA Perspective – Sept. 17 webinar

 | September 11, 2014 |  Posted In: MySQL, OpenStack, Percona XtraDB Cluster, Technical Webinars

I’ll have the pleasure to present, next Wednesday, September 17 at 10 a.m. PDT (1 p.m. EDT) a webinar titled “OpenStack: A MySQL DBA Perspective.” Everyone is invited. The webinar will be divided into two parts. The first part will cover how MySQL can be used by the OpenStack infrastructure including the expected load, high-availability […]

Read More

High Availability with mysqlnd_ms on Percona XtraDB Cluster

 | July 16, 2014 |  Posted In: High-availability, Insight for Developers, MySQL, Percona XtraDB Cluster

This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary cluster where you can write to all nodes. In this post I used […]

Read More

Simple MySQL Master HA with mysqlnd_ms

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

I had the pleasure of presenting to the PHP Users Group Philippines a few days ago about mysqlnd_ms. The mysqlnd plugin, MySQL Master Slave, is a transparent layer on top of mysqlnd extension. This allows you to do read-write splitting and slave reads load balancing without needing to change anything from your application. But do […]

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.