MySQL 的双主配置：打造高效、强大的数据库架构！

[mysqld]basedir=/data/mysqldatadir=/data/mysql/datasocket=/data/mysql/mysql.sockcharacter_set_server = utf8lower_case_table_names=1symbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidlog-bin=/data/mysql/mysql-bin-masterserver-id=1binlog-ignore-db=performance_schemabinlog-ignore-db=information_schemabinlog-ignore-db=sysbinlog-ignore-db=mysqlslave-skip-errors = allrelay_log=mysql-relay-binlog-slave-updates=1sync_binlog = 1auto_increment_offset = 1auto_increment_increment = 2sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONmax_allowed_packet = 512Minnodb_log_file_size = 2GBdefault-storage-engine = INNODBmax_connections=3000max_user_connections=800innodb_lock_wait_timeout = 50wait_timeout = 86400interactive_timeout = 86400max_connect_errors = 10000back_log=500transaction_isolation = READ-COMMITTEDcharacter-set-server = utf8mb4collation-server = utf8mb4_unicode_ciinit_connect=\\\'SET NAMES utf8mb4\\\'default-time_zone = \\\'+8:00\\\'
[client]port=3306default-character-set = utf8mb4
[mysql]default-character-set = utf8mb4socket=/data/mysql/mysql.sock

server-id=3auto_increment_offset = 2

systemctl restart mysqld

show master status;

grant replication slave on *.* to \\\'root\\\'@\\\'%\\\' identified by \\\'当前mysql root密码\\\';grant all privileges on *.* to \\\'root\\\'@\\\'%\\\' identified by \\\'当前mysql root密码\\\';flush privileges;

mysql -uroot -p mysql1密码 -h mysql2IP -P 3306

mysql -uroot -p mysql1密码 -h mysql1IP -P 3306

change master to master_host=\\\'mysql2的IP\\\',master_port=3306,master_user=\\\'root\\\',master_password=\\\'mysql2 root用户密码\\\',master_log_file=\\\'上图mysql2的File(mysql-bin-master.000013)\\\',master_log_pos=上图mysql2的Podition(1746);

start slave;show slave status \\\\G;

change master to master_host=\\\'mysql2的IP\\\',master_port=3306,master_user=\\\'root\\\',master_password=\\\'mysql1 root用户密码\\\',master_log_file=\\\'上图mysql1的File\\\',master_log_pos=上图mysql1的Podition;