Feb 01, 2014
  FOSDEM 2014
   Frederic 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

Frederic Descamps

Frédéric is an experienced Open Source consultant with expertise in infrastructure projects as well in development tracks and database administration. Frédéric is a believer of devops culture. He lives in Belgium.