Posts tagged: ubuntu

MySQL Load-Balanced Cluster Guide – Part 3

Posted January 28 by Dan Cryer

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 [...]

Read More »

MySQL Load-Balanced Cluster Guide – Part 2

Posted January 28 by Dan Cryer

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 [...]

Read More »

MySQL Load-Balanced Cluster Guide – Part 1

Posted January 27 by Dan Cryer

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 [...]

Read More »