How Can We Help?
< All Topics
Print

MySQL Template with Auto-Clustering

MySQL

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 your requirements, you can select Scheme of the following types:

  • Master-Master with Extra SlavesPre-configured replication with two interconnected master databases. During the horizontal scaling, the cluster is extended with additional slave nodes.

    mysql cluster master-master scheme
  • Master-Slave with Extra SlavesPre-configured replication with one master and one slave database. During the horizontal scaling, the cluster is extended with additional slave nodes.

    mysql cluster master-slave scheme
  • Multi MGR (Multi-Primary Group Replication)All servers can accept updates even if being issued concurrently.

    mysql cluster multi mgr scheme
  • Single MGR (Single Primary Group Replication)Just one node (primary) can accept updates at a time. An automatic election is called upon its unavailability.

    mysql cluster single mgr scheme
Table of Contents