Tutorial Articles

Below is a list of tutorial articles planned for the next few months. They cover essential topics and are grouped by skill level, as well as an extra set of articles cover some special topics.

Beginner Tutorials

Introduction to Galera Cluster scheduled 12 aug. 2019 Overview of Galera and minimal components. Although conceptual, not practical, it does not delve deep. Installing Galera Cluster scheduled 5 aug. 2019 Shows the basics of how to install the Galera Cluster with three nodes.
Plain Replication vs. Galera Cluster scheduled 19 aug. 2019 Explains standard replication compared to Galera. The Essentials scheduled 19 aug. 2019 Which configuration settings are need and recommended.

Intermediate Tutorials

Back-Ups with Galera not yet scheduled How to remove a node from the cluster to make a proper back-up with GTIDs. Scheming within a Cluster not yet scheduled Article on methods to change a table schema.
Recovering from a Cluster Crash not yet scheduled Explains the steps to restart a cluster, to ensure data isn’t lost or overwritten. Software Upgrades not yet scheduled Planning and conducting upgrades of Galera software on an active cluster.
The Lines of Communications not yet scheduled Understanding the point of each port and how nodes communicate with each other.  

Advanced Tutorials

Multi-Primary Conflicts not yet scheduled Explain how Multi-Primary conflicts can occur and how to resolve them and methods to prevent them. Testing a Schema Change not yet scheduled Explain how to install and use sysbench to test a schema change, to determine how long it will take.
Managing Users not yet scheduled some text Recovering from Split Brain not yet scheduled some text

Special Topics

Load Balancing a Galera Cluster scheduled 15 sept. 2019 How to install and configure a load balancer (for example, MaxScale) to balance traffic among nodes. Monitoring a Cluster published 17 july 2019 Present status variables used to monitor, including wsrep_provider_options and a bash simple script.