MySQL Replication Simplified: Easy Step-by-Step Examples to Establish, Troubleshoot and Monitor Replication (Unabridged‪)‬

MySQL Replication Simplified explains how the replication process works and what the benefits are. Then, it provides detailed step-by-step east to understand examples with visuals to set up a variety of replication configurations including the process of copying master to replica, making configuration changes and commands to establish replication. This audiobook offers ways to troubleshoot, especially to interpret errors and to repair broken replication. In the end, it provides a mechanism to monitor working replication to alert on the event of replication issues.

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
Skipping SQL Errors
Using SQL_Slave_Skip_Counter
Experimenting with auto increment variables
Interpreting show slave status output
Understanding shows process list
Including & excluding databases & tables in replication
Interpreting binary and relay log files using mysqlbinlog
Troubleshooting and repairing broken replication
Monitoring MySQL replication