Training: Galera Cluster

Galera Cluster is a 2 days training, designed for DBAs who need to setup a HA environment based on Galera technology: a synchronous, multimaster client. After this training, the attendee will be able to use both Percona XtraDB Cluster and MariaDB Cluster, as they both are based on Galera. The training can be focused on one of these flavours, if the company wishes so.

This training covers the necessary topics to setup new clusters and upgrade existing ones, monitor them, run ordinary administration and troubleshoot problems.

Topics

  • Understanding Galera and WSREP
  • Galera limitations and good practices
  • Designing a cluster
  • Starting a new cluster
  • Rolling upgrades
  • Transaction certification
  • Galera Cache, SST, SSI
  • Disaster recovering
  • Performance tuning
  • Avoiding flow control
  • Causal reads
  • Running ALTER TABLE (TOI, RSU)
  • Combining Galera and asynchronous replication

Cost and timing

The Galera Cluster 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