Linux MySQL专栏-InnoDB Cluster

mgr基础上执行如下！

mysqlsh安装略过！

1、节点参数及权限配置预检测

所有节点,每个节点参数及权限配置预检测
mysqlsh  -u'rpl_user'  -p'password'   -h 172.20.0.2/3/4
MySQL  172.20.0.2:33060+ ssl  JS > dba.checkInstanceConfiguration('rpl_user@172.20.0.2:3306')
MySQL  172.20.0.2:33060+ ssl  JS > dba.checkInstanceConfiguration('rpl_user@172.20.0.3:3306')
MySQL  172.20.0.2:33060+ ssl  JS > dba.checkInstanceConfiguration('rpl_user@172.20.0.4:3306')

2、创建加入集群

#任一节点（172.20.0.2/3/4），创建集群
MySQL  172.20.0.2:33060+ ssl  JS > var  cluster = dba.createCluster ('Cluster01')
#如果上面执行报错，删除集群如下
dba.dropMetadataSchema();
#再次创建集群
MySQL  172.20.0.2:33060+ ssl  JS > var  cluster = dba.createCluster ('Cluster01')

#将组复制(现有mgr)转换为InnoDB Cluster
MySQL  172.20.0.2:33060+ ssl  JS > var  cluster = dba.createCluster ('Cluster01',{adoptFromGR:true})

#其它节点加入集群
MySQL  172.20.0.2:33060+ ssl  JS > cluster.addInstance ('rpl_user@alma8:3306')

3、查看集群状态

MySQL  172.20.0.2:33060+ ssl  JS > cluster.status()
MySQL  172.20.0.2:33060+ ssl  JS > cluster.describe()
MySQL  172.20.0.2:33060+ ssl  JS > cluster.options()

4、多主/单主切换

#切换到多主模式
MySQL  172.20.0.2:33060+ ssl  JS > cluster.switchToMultiPrimaryMode()
MySQL  172.20.0.2:33060+ ssl  JS > cluster.describe()
#切换到单主模式
MySQL  172.20.0.2:33060+ ssl  JS > cluster.switchToSinglePrimaryMode('centos7-1:3306')
MySQL  172.20.0.2:33060+ ssl  JS > cluster.describe()

mysql-router

1、mysql-router安装略过！

2、为集群配置 MySQL Router 帐户

mysqlsh  -u'rpl_user'  -p'password'   -h 172.20.0.2

MySQL  172.20.0.2:33060+ ssl  SQL > \js
MySQL  172.20.0.2:33060+ ssl  JS > var  cluster = dba.getCluster ('Cluster01')
MySQL  172.20.0.2:33060+ ssl  JS > cluster.setupRouterAccount ('mysqlrouter')

3、为mysqlrouter账户授权()

mysql -uroot -p'Root@123'  -h 172.20.0.2
grant create,insert,select,update,delete,drop on *.* to 'mysqlrouter'@'%';
grant SELECT, EXECUTE ON mysql_innodb_cluster_metadata.*  to 'mysqlrouter'@'%' WITH GRANT OPTION;
FLUSH  PRIVILEGES;
exit;

4、启动

mysqlrouter --bootstrap mysqlrouter@172.20.0.2:3306  --user=root  --force

cat /etc/mysqlrouter/mysqlrouter.conf

5、测试mysql router

#只读端口
mysql  -u'mysqlrouter'  -p'mysqlrouter' -P 6447  -h 192.168.15.7  -e "select @@hostname;"
#读写端口
mysql  -u'mysqlrouter'  -p'mysqlrouter' -P 6446  -h 192.168.15.7  -e "select @@hostname;"