mysql innodb cluster 創(chuàng)建

2024-07-24 12:32:08

字體：大中小

供稿：網(wǎng)友

環(huán)境準(zhǔn)備:
1 下載和安裝需要的軟件(本人的軟件版本--都是mysql Community中的Linux Generic版本)
mysql-server(mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz)
mysql-router(mysql-router-8.0.17-linux-glibc2.12-x86_64.tar.xz)
mysql-shell(mysql-shell-8.0.17-linux-glibc2.12-x86-64bit.tar.gz)

安裝(以mysql server為例，其他類似,以下都是Mysql_tar操作系統(tǒng)用戶操作):
cd /home/mysql_tar
tar -xvf mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz
ln -s mysql-8.0.17-linux-glibc2.12-x86_64 mysql_install(方便升級(jí))
...mysql-router...
....mysql_shell...

Some variables need to be changed, but cannot be done dynamically on the server.
NOTE: Please use the dba.configureInstance() command to repair these issues.

{
"config_errors": [
{
"action": "server_update",
"current": "CRC32",
"option": "binlog_checksum",
"required": "NONE"
},
{
"action": "server_update+restart",
"current": "OFF",
"option": "enforce_gtid_consistency",
"required": "ON"
},
{
"action": "server_update+restart",
"current": "OFF",
"option": "gtid_mode",
"required": "ON"
},
{
"action": "server_update+restart",
"current": "1",
"option": "server_id",
"required": "<unique ID>"
}
],
"status": "error"
}
MySQL mysql_host_a:33060+ ssl JS > /exit
Bye!

。。。完成了，基本的步驟就這些吧。
主要方法:
dba.configureInstance()

dba.createCluster()

Cluster.addInstance()----cluster=dba.getCluster()獲取cluster變量

Cluster.removeInstance()

Cluster.rejoinInstance()

（編輯：武林網(wǎng)）

上一篇：MYSQL RC 和RR隔離級(jí)別差別性

下一篇：MySQL DDL詳情揭示