garutilorenzo/mysql-innodb-cluster

MySQL InnoDB Cluster

镜像概述和主要用途

用于测试目的的MySQL InnoDB Cluster Docker化环境。

• https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html - MySQL InnoDB Cluster提供了完整的MySQL高可用性解决方案
• https://dev.mysql.com/doc/mysql-router/8.0/en/ - MySQL Router是InnoDB Cluster的一部分，是轻量级中间件，提供应用程序和后端MySQL服务器之间的透明路由

环境说明

• master分支基于MySQL 8.0，5.7分支基于MySQL 5.7
• MySQL InnoDB集群在现有组复制上创建（详见mysql/docker-entrypoint.sh）
• 与官方MySQL Docker镜像不同，用户和数据库仅在第一个节点创建，然后传播到其他节点。用户和数据库在组复制设置后创建
• MySQL Router在所有节点启动后创建集群（详见mysqlrouter/docker-entrypoint.sh）。仅当集群不存在时才会创建集群

环境变量

MySQL服务器（mysql-innodb-cluster镜像）

• MYSQL_ROOT_PASSWORD: MySQL root密码
• GROUP_NAME: 组复制的UUID
• BOOTSTRAP: 如果设置此值，将引导MySQL InnoDB集群
• MYSQL_USER: MySQL用户（可选）
• MYSQL_PASSWORD: MySQL用户密码（可选）
• MYSQL_DATABASE: MySQL数据库（可选）

MySQL Router（mysql-innodb-cluster-router镜像）

• MYSQL_ROOT_PASSWORD: root用户的密码
• MYSQL_HOST: MySQL主节点
• CLUSTERMEMBERS: 集群中预期的成员数量

启动集群

启动集群：

console
docker-compose up -d

检查是否一切正常：

console
docker-compose ps
docker-compose logs -f

构建自己的镜像或从头构建（可选）：

console
docker-compose build

使用集群

查看当前集群状态：

console
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"
}

高级用法请参见https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-innodb-cluster.html

销毁集群

console
docker-compose down -v