google-templatesmariadb

Understand the default MariaDB cluster configuration

The Bitnami Multi-Tier Solution for MariaDB uses multiple VMs, consisting of 1 master and 1 or more slaves, to provide a horizontally scalable and fault-tolerant deployment. Data automatically replicates from the master node to all slave nodes. Binary logging is enabled and the MariaDB server is configured to listen for connections from any IP address (0.0.0.0).

To understand how it works, consider the example below of a two-node cluster (one master and one slave):

  • On the master node, create a new table and populate it with some data:

    MariaDB [(none)]> USE bitnami;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Database changed
    
    MariaDB [bitnami]> CREATE TABLE test (id INT NOT NULL, value VARCHAR(255) NOT NULL);
    Query OK, 0 rows affected (0.37 sec)
    
    MariaDB [bitnami]> INSERT INTO test VALUES (1, 'foo'), (2, 'bar');
    Query OK, 2 rows affected (0.07 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
  • On any of the slave nodes, check if the table exists and list its contents. It should display the same data originally entered on the master node:

    MariaDB [(none)]> USE bitnami;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Database changed
    
    MariaDB [bitnami]> SELECT * FROM test;
    +----+-------+
    | id | value |
    +----+-------+
    |  1 | foo   |
    |  2 | bar   |
    +----+-------+
    2 rows in set (0.00 sec)
    

This shows that records added on the master node are automatically replicated to the slave node(s). For more information, refer to the MariaDB documentation on replication.

Last modification September 5, 2018