Posts tagged: replication

This article is the last in my MySQL Load-Balanced Cluster Guide series, following on from my earlier post today on setting up MySQL Monitoring on the cluster nodes, this article is a guide to setting up the load balancer with HAProxy, using the monitoring scripts we’ve created to check the node status.
HAProxy is a well [...]

Following on from yesterday’s guide to setting up MySQL master-master replication, the first of today’s guides is how to set up a script to monitor the status of your MySQL cluster nodes, which we’ll use in the next guide to set up our proxy.
On every one of your MySQL cluster nodes, follow the steps below [...]

I’m currently working on setting up a load-balanced many-master MySQL cluster at work, without using MySQL Cluster as it’s incompatible with our needs. Finding good guides on how to do this has proven incredibly difficult, so I thought I would document the process here.
This first post is going to cover setting up the servers themselves [...]

We’re doing some research into how to scale our MySQL database from the current Master and Two Slaves set up, to a scalable cluster, ideally without going down the master to master replication route MySQL offer. In doing so, Wade stumbled across the “Spider” storage engine, but information seems sorely lacking and the home page [...]

In our ongoing, joyous adventures with scaling MySQL, we hit another stumbling block this morning. We arrived to find out that one of our two MySQL slaves had stopped replicating at 6AM on Saturday morning. This meant that our reporting systems were all running on two day old data, even though we’d been diligently collecting [...]