Summary


  • 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 .



MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net