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