Understand the default MySQL cluster configuration

The Bitnami Multi-Tier Solution for MySQL 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.

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:

    mysql [(none)]> USE bitnami;
    Database changed
    mysql [bitnami]> CREATE TABLE test (id INT NOT NULL, value VARCHAR(255) NOT NULL);
    Query OK, 0 rows affected (0.37 sec)
    mysql [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:

    mysql [(none)]> USE bitnami;
    Database changed
    mysql [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 MySQL documentation on replication.

Last modification September 5, 2018