Feb 01, 2014
 FOSDEM 2014
  Frédéric Descamps

15 Tips to Boost Your Galera Cluster

15 tips to boost your Galera Cluster.

During this presentation, you will learn to how to implement several things that will improve your day-to-day workload.

The points will cover topics like Point in Time Recovery, WAN replication with group segments, Avoiding SST when adding new Percona XtraDB Cluster node, ... the tips will be briefly explained to the audience and then put in practice.

Tips Covered:

  • Point in Time Recovery
  • Accelerate XtraBAckup SST
  • Move async slave to a new master 5.5
  • Move async slave to a new master 5.6
  • Allow longer downtime for a node
  • Measuring Max Replication Throughput on Percona XtraDB Cluster with wsrep_desync
  • Multicast replication
  • SSL everywhere
  • Decode GRA* files
  • Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
  • Avoiding SST when adding new Percona XtraDB Cluster node
  • Play with quorum and weight
  • WAN replication with group segments
  • Load balancer and TIME_WAIT
  • Load balancer and persistent connections


About the Author

Frédéric Descamps

Frédéric Descamps is MySQL Community Manager for EMEA & APAC. He joined the MySQL Community Team in May 2016. "@lefred" has been an OpenSource and MySQL consultant for more than 15 years. His favorite topics are High Availability and Performance.