Chapter 1. Replication

In this chapter, we will discuss:

• Setting up automatically updated slaves of a server based on a SQL dump

• Setting up automatically updated slaves of a selection of tables based on a SQL dump

• Setting up automatically updated slaves using data file copy

• Sharing read load across multiple machines

• Using replication to provide full-text indexing for InnoDB tables

• Estimating network and slave I/O load

• Limiting network and slave I/O load in heavy write scenarios using the blackhole storage engine

• Setting up slaves via network streaming

• Skipping problematic queries

• Checking if servers are in sync

• Avoiding duplicate server IDs

• Setting up slaves to report custom information about themselves to the master