在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:GreatSQL-Docker开源软件地址:https://gitee.com/GreatSQL/GreatSQL-Docker开源软件介绍:GreatSQL-Docker介绍GreatSQL软件相关Docker镜像集。 Dockerfiles可用于自定义和构建docker映像。戳此阅读更多关于Dockerfiles的文档。 如何构建和运行GreatSQL软件,请参阅各个目录。 我们非常欢迎和鼓励社区用户提出改进建议或贡献代码、想法,以及其他任何可以帮助改进项目的做法。 如果您发现任何GreatSQL-Docker项目相关的问题、bug,都可以戳此提交issue,我们将尽快处理。 快速使用
支持哪些tag如何使用GreatSQL镜像例如: $ docker run -d \--name mgr1 --hostname=mgr1 \-e MYSQL_ALLOW_EMPTY_PASSWORD=1 \-e MYSQL_INIT_MGR=1 \greatsql/greatsql --name mgr1,设定容器名称--hostname=mgr1,设定容器主机名MYSQL_ALLOW_EMPTY_PASSWORD=1 设定容器中的MySQL root用户是否采用空密码greatsql/greatsql,指定容器使用的镜像名 连接(容器中的)MySQL运行下面的命令进入容器 $ docker exec -it mgr1 bash 可以使用mysql 或 mysqladmin等客户端工具 [root@mgr1 /]# mysqladmin pingmysqld is alive[root@mgr1 /]# mysqladmin vermysqladmin Ver 8.0.25 for Linux on x86_64 (MySQL Community Server - GPL)Copyright (c) 2018-2021 GreatOpenSource and/or its affiliatesCopyright (c) 2009-2021 Percona LLC and/or its affiliatesCopyright (c) 2000, 2021, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Server version 8.0.25-15Protocol version 10Connection Localhost via UNIX socketUNIX socket /data/GreatSQL/mysql.sockUptime: 2 hours 56 min 47 secThreads: 70 Questions: 68 Slow queries: 0 Opens: 155 Flush tables: 3 Open tables: 72 Queries per second avg: 0.006[root@mgr1 /]# mysqlWelcome to the MySQL monitor. Commands end with ; or \g....[root@GreatSQL][(none)]>select version();+-----------+| version() |+-----------+| 8.0.25-15 |+-----------+1 row in set (0.00 sec) 如何通过 docker-compose 使用GreatSQL镜像下面是一个docker-compose的配置文件参考 version: '2'services: mgr1: image: greatsql/greatsql container_name: mgr1 hostname: mgr1 network_mode: bridge restart: unless-stopped environment: TZ: Asia/Shanghai MYSQL_ALLOW_EMPTY_PASSWORD: 1 MYSQL_INIT_MGR: 1 运行 $ docker-compose -f /data/docker/mysql.yml ps 运行下面的命令进入容器: $ docker exec -it mgr1 bash 如何通过docker-compose构建MGR集群下面是一个docker-compose的配置文件参考 version: '2'services: mgr1: image: greatsql/greatsql container_name: mgr1 hostname: mgr1 network_mode: bridge restart: unless-stopped environment: TZ: Asia/Shanghai MYSQL_ALLOW_EMPTY_PASSWORD: 1 MYSQL_INIT_MGR: 1 MYSQL_MGR_LOCAL: '172.17.0.2:33061' MYSQL_MGR_SEEDS: '172.17.0.2:33061,172.17.0.3:33061' extra_hosts: - "mgr1:172.17.0.2" - "mgr2:172.17.0.3" mgr2: image: greatsql/greatsql container_name: mgr2 hostname: mgr2 network_mode: bridge restart: unless-stopped depends_on: - "mgr1" environment: TZ: Asia/Shanghai MYSQL_ALLOW_EMPTY_PASSWORD: 1 MYSQL_INIT_MGR: 1 MYSQL_MGR_LOCAL: '172.17.0.3:33061' MYSQL_MGR_SEEDS: '172.17.0.2:33061,172.17.0.3:33061' extra_hosts: - "mgr1:172.17.0.2" - "mgr2:172.17.0.3" 启动所有容器: $ docker-compse -f /data/docker/mgr.yml up -d 进入第一个容器,将其设置为MGR的PRIMARY节点 $ docker exec -it mgr1 bash[root@mgr1 /]# mysql...[root@GreatSQL][(none)]> SET GLOBAL group_replication_bootstrap_group=ON;[root@GreatSQL][(none)]> start group_replication;[root@GreatSQL][(none)]> select * from performance_schema.replication_group_members;+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+| group_replication_applier | 202eb70c-e13a-11eb-b390-0242ac110002 | mgr1 | 3306 | ONLINE | PRIMARY | 8.0.25 |+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+1 rows in set (0.00 sec) 进入第二个容器,将其设置为SECONDARY节点 $ docker exec -it mgr2 bash[root@mgr2 /]# mysql...[root@GreatSQL][(none)]> start group_replication;[root@GreatSQL][(none)]>select * from performance_schema.replication_group_members;+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+| group_replication_applier | 202eb70c-e13a-11eb-b390-0242ac110002 | mgr1 | 3306 | ONLINE | PRIMARY | 8.0.25 || group_replication_applier | 20851760-e13a-11eb-91e1-0242ac110003 | mgr2 | 3306 | ONLINE | SECONDARY | 8.0.25 |+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+2 rows in set (0.00 sec) 看起来这就好了。 环境变量/参数介绍
联系我们扫码关注微信公众号 |
请发表评论