Posts Tagged with "mysql"

Simple MySQL replication cluster with load balancer on the slaves

Scenario
Background
This post is a follow on from my previous post on how to setup a load balanced high availability Apache cluster and uses the same network setup and heartbeat setup. For the purposes of testing and to save on resource I am using the web servers from the previous guide as the MySQL servers in [...]

Read this article…

Using cron to create website and MySQL backups that rotate nicely over a week

I wrote this for a PHP/MySQL site that needed to have it’s databases backed up hourly and the whole site including uploads backed up daily. They wanted all databases going back 24 hours every hour, and then all content going back 7 days every day.  This creates a directory structure that looks like the following:
In [...]

Read this article…
Call us now
01252 560 260