89490

Replication Solutions

Replication can be used in many different environments for a rangę of purposes. This section provides

generał notes and advice on using replication for specific solution types.

For information on using replication in a backup environment, including notes on the setup, backup

procedurę, and filesto back up, see Section 16.3.1, “Using Replication for Backups". For advice and tips on using different storage engines on the master and slaves, see Section 16.3.2,

“Using Replication with Different Master and Slave Storage Engines".

Using replication as a scale-out solution requires some changes in the logie and operation of

applications that use the solution. See Section 16.3.3, “Using Replication for Scale-Out”.

For performance or data distribution reasons, you may want to replicate different databases to different

replication slaves. See Section 16.3.4, “Replicating Different Databases to Different Slaves"

As the number of replication slaves inereases, the load on the master can inerease and lead to reduced

performance (because of the need to replicate the binary log to each slave). For tips on improving

your replication performance, including using a single secondary server as an replication master, see

Section 16.3.5, “lmproving Replication Performance".

For guidance on switching masters, or converting slaves into masters as part of an emergency failover

solution, see Section 16.3.6, "Switching Masters During Failover".