Comment out bind-address, so that MariaDB process is reachable from other nodes, by default it wont be in the config, but just to make sure, if it is uncommented, comment the config:
$mysql-uroot-p-e"SHOW STATUS LIKE 'wsrep_cluster_size';"Enterpassword:+--------------------+-------+|Variable_name|Value|+--------------------+-------+|wsrep_cluster_size|1|+--------------------+-------+
Verify that the Node has checked in with the Cluster:
1234567
$mysql-uroot-p-e"SHOW STATUS LIKE 'wsrep_cluster_size';"Enterpassword:+--------------------+-------+|Variable_name|Value|+--------------------+-------+|wsrep_cluster_size|2|+--------------------+-------+
Verify that the Node has checked in with the Cluster:
1234567
$mysql-uroot-p-e"SHOW STATUS LIKE 'wsrep_cluster_size';"Enterpassword:+--------------------+-------+|Variable_name|Value|+--------------------+-------+|wsrep_cluster_size|3|+--------------------+-------+
Create a Database, Table and Record:
Write some data to the table, then reboot the node, in this example on node-1, then logon to node-2 check the number of nodes that’s active in the cluster, which should be 2, then at the same time, look if the data is replicated:
While the one node is rebooting, check how many nodes are checked into our cluster:
1234567
$mysql-uroot-p-e"SHOW STATUS LIKE 'wsrep_cluster_size';"Enterpassword:+--------------------+-------+|Variable_name|Value|+--------------------+-------+|wsrep_cluster_size|2|+--------------------+-------+
Our data is replicated, and after waiting for a couple of seconds, we retry our command to see if the rebooted node checked into the cluster:
1234567
$mysql-uroot-p-e"SHOW STATUS LIKE 'wsrep_cluster_size';"Enterpassword:+--------------------+-------+|Variable_name|Value|+--------------------+-------+|wsrep_cluster_size|3|+--------------------+-------+
We can confirm that the node that was rebooted, has checked in with the cluster again.