Chapter 12: Database Replication

Overview

MySQL has a useful feature called replication, which is where one or more databases from a server (called the master) are automatically mirrored onto one or more other servers (called slaves). Replication is useful as a backup strategy and a performance-tuning technique. This chapter explains how replication works and shows you how to set up and configure it.

Featured in this chapter:

  • Setting up replication

  • Configuring slave and master files

  • Understanding slave and master SQL statements



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

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