Galera Synchronous Multi-Master Replication for MySQL

8.16667
Average: 8.2 (6 votes)

This is a tutorial about how to install, configure and operate Galera synchronous multi-master cluster for MySQL/InnoDB. Agenda:

  1. Introduction (30-45 min)
    1. Galera architecture overview
    2. Important terms and concepts
  2. LAN cluster setup (30 min)
    1. Node configuration
    2. Joining the cluster, state transfer
    3. Executing SQL load
  3. Migration from stock MySQL replication (30 min)
  4. Node failure and recovery under load (30 min)
    1. Planned restart
    2. Hard crash
    3. Split-brain
  5. WAN replication (30 min)
  6. Troubleshooting
  7. Q&A

Important configuration options and status variables will be covered throughout the tutorial.

Track: 
Replication and High Availability Strategies
Experience level: 
Intermediate

Schedule info

Time slot: 
10 April 13:30 - 16:30
Room: 
Ballroom C

Schedule Info

10 April 13:30 - 16:30 @
Ballroom C

Speakers

Alexey Yurchenko's picture
Solutions Architect, Codership Oy

Alexey Yurchenko is a founder and a self-appointed Solutions Architect at Codership Oy, developers of Galera replication engine.

Slides




Sponsored By