Step 3. Mount the Volume on the Joiner and Configure the Cluster Properties

MySQL and MariaDB

Audience
Public
Source Type
Documentation

Once the volume has been overwritten with a snapshot (and connected to the relevant system) it can be mounted to the MySQL location on the joiner using the mount command for Linux based operating system.


mount /dev/mapper/eui.00668f1ab9b15f4b24a937c400012d1f /var/lib/mysql/ 

In the option file set the Galera Cluster properties (adjusting as required).

Note:

Setting the wsrep_provider_options with a larger gcache.size will affect how the node is provisioned.

If the node is too far out of sync (using an old volume snapshot) then an SST will occur using the wsrep_sst_method set out in the option file.

To ensure that an SST is not performed and instead an IST is performed , ensure that the donor has the gcache.size set to a large enough value that changes are cached and applied to the joiner when it first starts up.

It is not recommended to use old volume snapshots to perform manual physical SSTs.


# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name="galera_cluster"
wsrep_cluster_address=gcomm://10.21.227.40,10.21.227.39
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="10.21.227.40"
wsrep_node_name="DB-02"
wsrep_provider_options="gcache.size=102400M"