azure-templatesgrafana

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.

Last modification February 3, 2022