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.