Product: MySQL/MariaDB
Audience: DBA, High Availability
Interactivity and exercises are an integral part of the day, providing an optimal environment for gaining new skills and reinforcing best practises. The classroom provides a safe environment to experiment and break things on purpose – you don’t know how good a backup is until you have tried to restore it!
This course day is useful for DBAs who have a decent familiarity with MySQL, but the day also has high value for DBAs and system administators who already have experience with other databases, as many aspects of this topic are MySQL/MariaDB specific.
Topics covered include:
- General concepts
- GTID replication
- Multi-source and multi-threaded slave replication
- Tools to initialise a new server
- Maatkit/Percona Toolkit for table synchronisation and other tasks
Note: this module is also suitable for clients using stock (Oracle) MySQL or Percona Server.