Using MySQL replication gives you an opportunity to scale out read queries. However, MySQL replication is asynchronous; the slave may fall behind.
This Wednesday, January 23 2013, I'll be presenting a free webinar about using MySQL replication on busy PHP web sites. Register here: http://www.percona.com/webinars/readwrite-splitting-mysql-and-php
Applications have variable tolerance
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.