Replication is not suitable for all occasions, but if you have a busy application with a high read-to-write ratio, it can be an excellent scaling tool.
Remember that updates are not applied to slaves in real time. Each copy of a table should move from one consistent state to another, but reads from different servers may give dated results while a slave updates.
The most useful replication- related queries are START SLAVE , LOAD TABLE name FROM MASTER , LOAD DATA FROM MASTER , SHOW MASTER STATUS , SHOW SLAVE STATUS , and SHOW SLAVE HOSTS .