MySQL InnoDB Cluster

MySQL InnoDB Cluster dockerized environment for testing purposes

• MySQL InnoDB Cluster - MySQL InnoDB Cluster provides a complete high availability solution for MySQL
• MySQL Router - MySQL Router is part of InnoDB Cluster, and is lightweight middleware that provides transparent routing between your application and back-end MySQL Servers

Notes about environment

• The master branch is based on MySQL 8.0, the 5.7 branch is based on MySQL 5.7
• MySQL InnoDB cluster is created on an existing group replication (see mysql/docker-entrypoint.sh for datails)
• Unlike official MySQL docker image, user an database are created only on the first node and then propagated to other nodes. User an database are created after group repliation setup.
• MySQL router creates the cluster after all nodes are up (see mysqlrouter/docker-entrypoint.sh). The cluster is created only if cluster doesen't exist.

Environment variables

• MySQL Server (mysql-innodb-cluster image)
  • MYSQL_ROOT_PASSWORD: MySQL root password
  • GROUP_NAME: uuid of the grpup replication
  • BOOTSTRAP: if value is set, MySQL InnoDB Cluster is bootstrapped
  • MYSQL_USER: mysql user (optional)
  • MYSQL_PASSWORD: mysql user password (optional)
  • MYSQL_DATABASE: mysql database (optional)
• MySQL Router (mysql-innodb-cluster-router image)
  • MYSQL_ROOT_PASSWORD: mysql for the root user
  • MYSQL_HOST: mysql primary node
  • CLUSTERMEMBERS: number of members expected in cluster

Spin up the cluster

Start the cluster:

docker-compose up -d

See if everything works correctrly:

docker-compose ps
docker-compose logs -f

Build your own image, or build from scratch (Optional):

docker-compose build

Play with the cluster

Show current cluster statu:

docker-compose exec mysql_node01 bash
root@mysql_node01:/#  mysqlsh --js root@mysql_node01
Logger: Tried to log to an uninitialized logger.
Please provide the password for 'root@mysql_node01': ****
Save password for 'root@mysql_node01'? [Y]es/[N]o/Ne[v]er (default No): 
MySQL Shell 8.0.20

Copyright (c) 2016, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.
Creating a session to 'root@mysql_node01'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 22
Server version: 5.7.32-log MySQL Community Server (GPL)
No default schema selected; type \use <schema> to set one.
MySQL  mysql_node01:3306 ssl  JS > <Cluster:testcluster>
MySQL  mysql_node01:3306 ssl  JS > clu.status()
{
    "clusterName": "testcluster", 
    "defaultReplicaSet": {
        "name": "default", 
        "primary": "mysql_node01:3306", 
        "ssl": "DISABLED", 
        "status": "OK", 
        "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.", 
        "topology": {
            "mysql_node01:3306": {
                "address": "mysql_node01:3306", 
                "mode": "R/W", 
                "readReplicas": {}, 
                "role": "HA", 
                "status": "ONLINE"
            }, 
            "mysql_node02:3306": {
                "address": "mysql_node02:3306", 
                "mode": "R/O", 
                "readReplicas": {}, 
                "role": "HA", 
                "status": "ONLINE"
            }, 
            "mysql_node03:3306": {
                "address": "mysql_node03:3306", 
                "mode": "R/O", 
                "readReplicas": {}, 
                "role": "HA", 
                "status": "ONLINE"
            }
        }, 
        "topologyMode": "Single-Primary"
    }, 
    "groupInformationSourceMember": "mysql_node01:3306"
}

For advanced usage see the docs

Tear down

docker-compose down -v