This book covers the following topics.
- What is MySQL Replication Benefits of replication
- How replication process works Replication configurations
- Components of Replication system
- Approach to replication
- Copying master to replica
- MySQL configuration parameters
- Commands useful to establish replication
- Setting up of replication user account
- Establishing various replication configurations
- Skip SQL Errors
- Experimenting with auto increment variables
- Interpreting show slave status output
- Understanding shows processlist
- Including & excluding databases & tables in replication
- Interpreting binary and relay log files using mysqlbinlog
- Troubleshooting and repairing broken replication
- Monitoring MySQL replication
Additional information can be found at http://mysqlreplicationsimplified.com