1.vim /etc/my.cnf 2.service mysqld restart 3.進入 Mysql 4.進入從伺服器 5.vim /etc/my.cnf 6.進入從Mysql 配置主主,從第6步在主伺服器上重覆操作 ...
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 tom@'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)
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;
配置主主,從第6步在主伺服器上重覆操作