During the design period of a new cluster, it is always advised to have at least 3 nodes (this is the case with PXC but it’s also the same with PRM). But why and what are the risks ? The goal of having more than 2 nodes, in fact an odd number is recommended in […]
If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync […]
For those wanting to become more familiar with Percona XtraDB Cluster or if you just one to test its capabilities, I have prepared an easy Vagrant setup ready to deploy. It contains the puppet recipes to install and configure a cluster of 3 nodes and a load balancer (glb) running on the first node. To […]
2012 is near… and so is the next FOSDEM edition ! This year again, MySQL will be represented by its Community. If you want to discuss with friend’s of MySQL it’s the place to be in February ! Like every year, FOSDEM takes place the first week-end of February in Brussels. The MySQL and Friends […]
Last week I helped 2 different customers with infinite replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them.