Mysql主主配置

时间:2022-05-21 05:19:04

 1.vim /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

server-id=1
log_bin=mysqlbin
relay_log=relaylog

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 2.service mysqld restart

 3.进入 Mysql

mysql> grant all on *.* to [email protected]‘192.168.146.%‘ identified by ‘123‘;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Mysql主主配置

 4.进入从服务器

 5.vim /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

server-id=2
log_bin=mysqllog
relay_log=mysqlrelay

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 6.进入从Mysql

mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> change master to master_host=‘192.168.146.6‘, master_user=‘tom‘,master_password=‘123‘,master_log_file=‘mysqlbin.000003‘,master_log_pos=315;
Query OK, 0 rows affected (0.39 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

mysql> show slave status G;

  Mysql主主配置

 

 

 配置主主,从第6步在主服务器上重复操作