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.