Training: MySQL Replication

MySQL Replication is a 2 days training, designed for DBAs who need to setup a HA environment based on MySQL native replication.

This training covers the mechanisms that make replication work. You will learn how to setup a replication chain, how to administrate it, what to monitor and how to fix problems.

Topics

  • Understanding the Binary Log
    • ROW and STATEMENT formats
  • Configuring a master
  • How to start and provision new slaves
  • Master-master setup
  • Parallel replication
  • Replication filters
  • Multimaster replication
  • Delayed replication
  • Slave promotion with GTID
  • Resolving conflicts with pt-table-checksum and pt-table-sync
  • Solving conflicts in a single table
  • Skipping conflicts to be fixed later
  • Monitoring replication: Seconds_behind_master, pt-heartbeat
  • Failover with ProxySQL
  • Replication best practices

Cost and timing

The MySQL Replication training has a cost of 2,200GBP and its duration is 2 days.

Strong discounts can be negotiated if your company has more than four attendees.

If the training is not remote and does not take place in London, Europe, the cost of travel and accommodation will be added to the total.

Requirements

The course is designed for DBAs or DevOps with MySQL working knowledge. A basic SQL knowledge is desirable to better understand some examples.

Attendees are strongly encouraged to bring their laptops with MySQL installed. For exercises and examples, the recommendation is to use mysql or mycli command-line interface. However, any program will work.

If your company is going to host the course, please be sure that a projector and a whiteboard are in the room.

Request a course

To request a course or ask for more information, please contact me:

info@federico-razzoli.com
+44 7739 427279 (London time)
Skype: fede.razzoli
Telegram: federico_razzoli

Or visit the contact page.

Related courses

← Back to Training List