Understand the default MySQL cluster configuration

The Bitnami Multi-Tier Solution for MySQL uses multiple VMs, consisting of 1 source and 1 or more replicas, to provide a horizontally scalable and fault-tolerant deployment. Data automatically replicates from the source node to all replicas. Binary logging is enabled.

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

• On the source 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 replica nodes, check if the table exists and list its contents. It should display the same data originally entered on the source:

    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 source are automatically replicated to the replica(s). For more information, refer to the MySQL documentation on replication.