The Library

Related Documents

Related Articles

Other Resources

Making Back-Ups with Galera Cluster

A primary responsibility of a database administrator, a DBA, is to make back-ups—or to ensure they are made properly and regularly. It is a key part of ensuring high availability of data. While the average DBA may know well how to perform this essential administrative task on stand-alone database servers, most aren’t so sure how best to do so when the database server is part of a Galera Cluster.

This training video explains in detail how to make back-ups of MySQL and MariaDB databases within a Galera Cluster. It presents in stages, different methods for removing or pausing a node to make a proper back-up. Additionally, it presents methods for restoring back-ups—recovering single nodes and an entire cluster.

As part of the training process, in the right margin here, you can find a link to a page containing exercises related to the training video. You should look at it before starting the video so that you can be prepared. There is also a link to a PDF copy of the slide presentation. It has been set so that you make notes on it. In the left margin are links to related documentation, articles, and other materials.

Video Specifications

  • Speaker: Russell J.T. Dyer
  • Date: October 25, 2019
  • Length of Video: 1 hour, 5 minutes

Student Materials

1. Back-Up Basics (time index: 3:30)
Covers the basic concepts, reasons and goals in making back-ups of databases.

2. Using Standard Replication (time index: 16:23)
Presents how to use standard MySQL or MariaDB replication to attach a replica to a Galera node, with it acting as a primary. With this arrangement, it is easy to stop the replica and regularly make back-ups.

3. Using Galera Arbitrator (time index: 27:31)
Galera Arbitrator may be used to desynchronize a node and then initiate a back-up script on that node. When it is finished, it will resynchronize the node.

4. Restoring Nodes (time index: 42:31)
Explains how to recover nodes and a cluster by various methods, including using back-up files to restore the data and start an entire cluster.

5. Back-Up & Restoration Plan (time index: 59:14)
Provides some sound advice on developing a back-up and restoration plan for Galera nodes.

Related Documents

Related Articles

Other Resources