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.
- Understanding the Binary Log
- 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
- Solving conflicts in a single table
- Skipping conflicts to be fixed later
- Monitoring replication:
- 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.
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:
+44 7739 427279 (London time)
Or visit the contact page.