MySQL Auto-Clustering
Auto-Clustering is provided for the 5.7.x and 8.x MySQL versions only.
Automatic clusterization of the databases with pre-configured replication and auto-discovery of the nodes.
Based on the requirements, I can select Scheme of the following types:
-
Master-Master with Extra Slaves
Pre-configured replication with two interconnected master databases. During the horizontal scaling, the cluster is extended with additional slave nodes.
-
Master-Slave with Extra Slaves
Pre-configured replication with one master and one slave database. During the horizontal scaling, the cluster is extended with additional slave nodes.
-
Multi MGR (Multi-Primary Group Replication)
All servers can accept updates even if being issued concurrently.
-
Single MGR (Single Primary Group Replication)
Just one node (primary) can accept updates at a time. An automatic election is called upon its unavailability.