MySQL Master Slave – Replication

If you need to run mysql replication, then we can help configue it for you, its a fantastic way of  allowing you to run reporting against a large dataset, by running all your queries against the slave database, and this will have zero impact on your production database.

This is also an effective way of providing for disaster recovery as you have an effective hot copy in case of  complete hard drive failure on the master.

Some of our clients use this in conjunction with an amazon  or rackspace server to replicate data, to a  slave mysql server, allowing them to run live queries against datasets in excess of 5,000,000 records without locking / causing issues to the production box.

contact us for more information on  mysql master slave replication



Comments are closed.