MySQL InnoDB Cluser | Mysql 5.7 集群
#mysqlsh ## 检查mysql 配置文件 (3台主机都要操作此步骤)dba.checkInstanceConfiguration('root@db1:3306')
+----------------------------------+---------------+----------------+--------------------------------------------------+
| Variable | Current Value | Required Value | Note |
+----------------------------------+---------------+----------------+--------------------------------------------------+
| binlog_checksum | CRC32 | NONE | Update the server variable or restart the server |
| binlog_format | MIXED | ROW | Update the server variable or restart the server |
| enforce_gtid_consistency | OFF | ON | Restart the server |
| gtid_mode | OFF | ON | Restart the server |
| log_slave_updates | 0 | ON | Restart the server |
| master_info_repository | FILE | TABLE | Restart the server |
|> | transaction_write_set_extraction | OFF | XXHASH64 | Restart the server |
+----------------------------------+---------------+----------------+--------------------------------------------------+
## 修复mysql 配置文件， 必须用 root(3台主机都要操作此步骤)
dba.configureLocalInstance('root@db1:3306')
Please provide the password for 'root@db1:3306':
Detecting the configuration file...
Found configuration file at standard location: /etc/my.cnf
Do you want to modify this file? :: Y
## 重启mysql
## 重新检查(3台主机都要操作此步骤)
dba.checkInstanceConfiguration('root@db1:3306')
Please provide the password for 'root@db1:3306':
Validating instance...
The instance 'db1:3306' is valid for Cluster usage
{
"status": "ok"
}
页:
[1]