/mysql-cluster

Scalable MySQL Cluster with ProxySQL Load Balancer and Orchestrator

Primary LanguageShellApache License 2.0Apache-2.0

MySQL Cluster

MySQL Cluster

The JPS package deploys scalable MySQL Cluster that consists of one master database and the required number of slave db containers with asynchronous replication.

Highlights

The current implementation of MySQL Cluster is built using the devbeta/mysql57:5.7.14-latest Docker image.

By default, you get two MySQL 5.7 database containers - the master and the slave. The number of databases can be increased and all the newly added nodes will be automatically configured as slaves to the initial master MySQL.

Within the package, each database container receives the default vertical scaling limit up to 8 dynamic cloudlets (or 1 GiB of RAM and 3.2 GHz of CPU) that are provided based on the load.

Mysql cluster topology

Specifics

Layer Docker image Number of CTs
by default
Cloudlets per CT
(reserved/dynamic)
Options
DB devbeta/mariadb:10-latest 2 1 / 8 -
  • DB - Database
  • CT - Container

You can adjust the exact number of slaves within the Containers field during the package installation stage. Here, one container is the master and the rest of containers are the slaves.

Mysql cluster containers

Moreover, you can also scale containers after installation in the topology wizard with the corresponding master-slave data replication automatically enabled.

Deployment

In order to get this solution instantly deployed, click the Deploy to Jelastic button, specify your email address within the widget, choose one of the Jelastic Public Cloud providers and press Install.

Deploy

To deploy this package to Jelastic Private Cloud, import this JPS manifest within your dashboard (detailed instruction).

More information about Jelastic JPS package and about installation widget for your website can be found in the Jelastic JPS Application Package reference.