Your audiobook is waiting…

MySQL Replication Simplified

Easy Step-by-Step Examples to Establish, Troubleshoot and Monitor Replication
Narrated by: Jeffrey Whittle
Length: 4 hrs and 31 mins
5 out of 5 stars (1 rating)

$14.95/month after 30 days. Cancel anytime.

OR
In Cart

Publisher's Summary

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

©2014 Sribatsa Das (P)2014 Sribatsa Das

What members say

Average Customer Ratings

Overall

  • 5 out of 5 stars
  • 5 Stars
    1
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Performance

  • 5 out of 5 stars
  • 5 Stars
    1
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Story

  • 5 out of 5 stars
  • 5 Stars
    1
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0