使用mysql shell搭建MGR

进击的CJR

于 2024-07-16 17:39:04 发布

阅读量624

点赞数 7

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/DBA_ChenJR/article/details/140472585

版权

mysql 专栏收录该内容

43 篇文章 0 订阅

订阅专栏

准备环境

资源有限只需要准备一台Linux主机
腾讯云主机159.75.158.18

（1）规划部署

主机	端口	配置文件	数据目录
159.75.158.18	3381	/etc/my3381.cnf	/data/3381/data
159.75.158.18	3382	/etc/my3382.cnf	/data/3382/data
159.75.158.18	3383	/etc/my3383.cnf	/data/3383/data

（2）准备实例配置文件
编辑3个配置文件，分别是
my3381.cnf
my3382.cnf
my3383.cnf

配置文件内容以my3383.cnf为例
将其中对应的数字3383 改为对应端口到不同配置文件

[mysqld]
log_timestamps=SYSTEM
user=mysql
basedir=/usr/local/mysql8
datadir=/data/3383/data
log_bin=/data/3383/binlog/mysql-bin
port=3383
server_id=20243383
socket=/tmp/mysql3383.sock
gtid-mode=on
enforce-gtid-consistency=true
log_slave_updates=1
relay_log_info_repository=TABLE
master_info_repository=TABLE
relay_log_recovery=on

（3）创建目录

mkdir -p /data/3381/data
mkdir -p /data/3381/binlog
mkdir -p /data/3382/data
mkdir -p /data/3382/binlog
mkdir -p /data/3383/data
mkdir -p /data/3383/binlog
chown mysql.mysql -R /data

（4）初始化和启动库

/usr/local/mysql8/bin/mysqld --defaults-file=/etc/my3381.cnf --basedir=/usr/local/mysql8 --initialize-insecure --datadir=/data/3381/data --user=mysql &

/usr/local/mysql8/bin/mysqld --defaults-file=/etc/my3382.cnf --basedir=/usr/local/mysql8 --initialize-insecure --datadir=/data/3382/data --user=mysql &

/usr/local/mysql8/bin/mysqld --defaults-file=/etc/my3383.cnf --basedir=/usr/local/mysql8 --initialize-insecure --datadir=/data/3383/data --user=mysql &



/usr/local/mysql8/bin/mysqld_safe --defaults-file=/etc/my3381.cnf --user=mysql &

/usr/local/mysql8/bin/mysqld_safe --defaults-file=/etc/my3382.cnf --user=mysql &

/usr/local/mysql8/bin/mysqld_safe --defaults-file=/etc/my3383.cnf --user=mysql &

（5）创建账号

为了简化步骤，直接执行

三个库都执行

mysql> create user admin@'%' identified by 'admin';
Query OK, 0 rows affected (0.02 sec)

mysql> grant all on *.* to admin@'%' with grant option;
Query OK, 0 rows affected (0.01 sec)

此步骤不规范，正常操作应当是
Create a new admin account for InnoDB cluster with minimal required grants

#在本地通过socket方式登入
$ mysqlsh -S /data/****/mysql.sock root@localhost

执行
dba.configureInstance()

选择
2) Create a new admin account for InnoDB cluster with minimal required grants

数据用户和密码

在使用
mysqlsh --uri 用户@IP:端口进入mysql shell界面

搭建MySQL shell环境

（1）下载：
https://dev.mysql.com/downloads/shell/

下载的shell版本和数据库版本保持一致

（2）解压
tar -zxvf mysql-shell-8.0.25-linux-glibc2.12-x86-64bit.tar.gz -C /opt/idc/mysql-shell8.0.25

（3）配置环境变量
vi /etc/profile
export PATH=/opt/idc/mysql-shell8.0.25/bin:$PATH
source /etc/profile

使用shell搭建MGR

(1)检查是否适配MGR节点
dba.checkInstanceConfiguration(‘admin@159.75.158.18:3381’)

MySQL  JS > dba.checkInstanceConfiguration('admin@159.75.158.18:3381')
Validating MySQL instance at VM-20-8-centos:3381 for use in an InnoDB cluster...

This instance reports its own address as VM-20-8-centos:3381
Clients and other cluster members will communicate with it through this address by default. If this is not correct, the report_host MySQL system variable should be changed.

Checking whether existing tables comply with Group Replication requirements...
No incompatible tables detected

Checking instance configuration...
Instance configuration is compatible with InnoDB cluster

The instance 'VM-20-8-centos:3381' is valid to be used in an InnoDB cluster.

{
    "status": "ok"
}

另外两台节点需要做此操作
dba.checkInstanceConfiguration(‘admin@159.75.158.18:3382’)
dba.checkInstanceConfiguration(‘admin@159.75.158.18:3383’)

如果此步报错说不符合MGR节点要求，执行第二步

（2）
执行 dba.configureInstance() 命令开始检查当前实例是否满足安装MGR集群的条件，如果不满足可以直接配置成为MGR集群的一个节点：

dba.configureInstance(‘admin@159.75.158.18:3381’)

dba.configureInstance('admin@159.75.158.18:3381')
Configuring MySQL instance at VM-20-8-centos:3381 for use in an InnoDB cluster...

This instance reports its own address as VM-20-8-centos:3381
Clients and other cluster members will communicate with it through this address by default. If this is not correct, the report_host MySQL system variable should be changed.

applierWorkerThreads will be set to the default value of 4.

The instance 'VM-20-8-centos:3381' is valid to be used in an InnoDB cluster.
The instance 'VM-20-8-centos:3381' is already ready to be used in an InnoDB cluster.

Successfully enabled parallel appliers.

根据需要选择YES，后再返回执行第一个，看结果是否是OK

另外两个节点同样执行相同步骤
dba.configureInstance(‘admin@159.75.158.18:3382’)
dba.configureInstance(‘admin@159.75.158.18:3383’)

（3）连接主节点
MySQL JS > \connect admin@159.75.158.18:3381

（4）创建集群
dba.createCluster(‘mgrCluster’)
var cluster = dba.getCluster()

（5）添加节点
这里要指定MGR专用账号，我们用的是测试账户不符合规范
cluster.addInstance(‘admin@159.75.158.18:3382’)
cluster.addInstance(‘admin@159.75.158.18:3383’)

（6）查看集群状态

cluster.status()

查看集群状态
  MySQL  159.75.158.18:3381 ssl  JS > cluster.status()
  {
    "clusterName": "mgrCluster", 
    "defaultReplicaSet": {
        "name": "default", 
        "primary": "VM-20-8-centos:3381", 
        "ssl": "REQUIRED", 
        "status": "OK", 
        "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.", 
        "topology": {
            "VM-20-8-centos:3381": {
                "address": "VM-20-8-centos:3381", 
                "memberRole": "PRIMARY", 
                "mode": "R/W", 
                "readReplicas": {}, 
                "replicationLag": null, 
                "role": "HA", 
                "status": "ONLINE", 
                "version": "8.0.25"
            }, 
            "VM-20-8-centos:3382": {
                "address": "VM-20-8-centos:3382", 
                "memberRole": "SECONDARY", 
                "mode": "R/O", 
                "readReplicas": {}, 
                "replicationLag": null, 
                "role": "HA", 
                "status": "ONLINE", 
                "version": "8.0.25"
            }, 
            "VM-20-8-centos:3383": {
                "address": "VM-20-8-centos:3383", 
                "memberRole": "SECONDARY", 
                "mode": "R/O", 
                "readReplicas": {}, 
                "replicationLag": null, 
                "role": "HA", 
                "status": "ONLINE", 
                "version": "8.0.25"
            }
        }, 
        "topologyMode": "Single-Primary"
    }, 
    "groupInformationSourceMember": "VM-20-8-centos:3381"
}

R/O是只读，R/W是读写，PRIMARY是主节点。

补充

切换到多主模式
cluster.switchToMultiPrimaryMode()

切换到单主模式
cluster.switchToSinglePrimaryMode(‘159.75.158.18:3381’)

进击的CJR

关注

7
点赞
踩
4

收藏

觉得还不错? 一键收藏
0
评论
使用mysql shell搭建MGR

资源有限只需要准备一台Linux主机腾讯云主机159.75.158.18（1）规划部署（2）准备实例配置文件编辑3个配置文件，分别是my3381.cnfmy3382.cnfmy3383.cnf配置文件内容以my3383.cnf为例将其中对应的数字3383 改为对应端口到不同配置文件（3）创建目录（4）初始化和启动库（5）创建账号为了简化步骤，直接执行此步骤不规范，正常操作应当是#在本地通过socket方式登入执行选择数据用户和密码在使用。
复制链接

扫一扫