PolarDB集群式配置及启动命令

1、节点my.cnf

(serverId:集群间不重复，可用ip，最大不超过4 294 967 295)

[mysqld]  
basedir = /opt/polardbx_engine  
log_error_verbosity = 2  
default_authentication_plugin = mysql_native_password  
gtid_mode = ON  
enforce_gtid_consistency = ON  
log_bin = mysql-binlog  
binlog_format = row  
binlog_row_image = FULL  
master_info_repository = TABLE  
relay_log_info_repository = TABLE  
log_bin_trust_function_creators=1  
transaction_isolation=READ-COMMITTED  
lower_case_table_names=1  
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION  
max_connections=2000  
default-time_zone = '+8:00'
#change me if need  
datadir = /data/polardbx-engine/data  
tmpdir = /data/polardbx-engine/tmp  
socket = /data/polardbx-engine/tmp.mysql.sock  
log_error = /data/polardbx-engine/log/alert.log  
port = 3306  
cluster_id = 1234  
cluster_info = 172.26.225.34:14886;172.26.225.38:14886@1  
server_id = 1722622534

innodb_buffer_pool_size = 8G  
innodb_buffer_pool_instances = 8  
table_open_cache = 4000  
table_definition_cache = 2000
#IO 配置  
innodb_io_capacity = 2000  
innodb_io_capacity_max = 4000  
innodb_flush_method = O_DIRECT  
innodb_write_io_threads = 8
[mysqld_safe]  
pid_file = /data/polardbx-engine/run/mysql.pid

2、其余节点修改处
cluster_info = 172.26.225.34:14886;172.26.225.38:14886@2
server_id = 1722622538

3、节点1的初始化及启动命令

/opt/polardbx_engine/bin/mysqld --defaults-file=my.cnf --clusterinfo='172.26.225.34:14886;172.26.225.38:14886@1' --initialize-insecure
/opt/polardbx_engine/bin/mysqld_safe --defaults-file=my.cnf --cluster-info='172.26.225.34:14886;172.26.225.38:14886@1' &

4、节点2的初始化及启动命令

/opt/polardbx_engine/bin/mysqld --defaults-file=my.cnf --cluster-info='172.26.225.34:14886;172.26.225.38:14886@2' --initialize-insecure
/opt/polardbx_engine/bin/mysqld_safe --defaults-file=my.cnf --cluster-info='172.26.225.34:14886;172.26.225.38:14886@2' &

⚠️️切记开放对应的集群端口（14886），以防万一也可将服务端口（3306）开放⚠️️

firewall-cmd --zone=public --add-port=14886/tcp --permanent  
#切记重载
firewall-cmd --reload

修改密码：

ALTER USER 'root'@'localhost' IDENTIFIED BY 'nx4MAx&beKNpGK';
FLUSH PRIVILEGES;

远程登陆：

use mysql;
UPDATE user SET Host='%' WHERE User='root' AND Host='localhost';
FLUSH PRIVILEGES;