#在m1和m2上互相授予访问的权限
MariaDB [(none)]> grant replication slave on *.* to 'replication'@'192.168.142.%' identified by '123456';#在m1上指定m2的日志文件名和位置参数
MariaDB [(none)]> change master to master_host='192.168.142.134',master_user='replication',master_password='123456',master_log_file='mysql_bin.000001',master_log_pos=245;#在m2上指定m1的日志文件名和位置参数
MariaDB [(none)]> change master to master_host='192.168.142.131',master_user='replication',master_password='123456',master_log_file='mysql_bin.000001',master_log_pos=245;
7.在m1上开启同步功能
MariaDB [(none)]> start slave;
8.查看同步状态,两台主服务器都要看到Yes
MariaDB [(none)]> show slave status\G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
9.在m1上创建数据库
MariaDB [(none)]> create database school;
10.在m2上查看同步数据库
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema || mysql || performance_schema || school ||test|
+--------------------+
5 rows inset(0.00 sec)
11.在两台从上做-注意日志文件和位置参数的改变(都指向m1)
MariaDB [(none)]> change master to master_host='192.168.142.131',master_user='replication',master_password='123456',master_log_file='mysql_bin.000001',master_log_pos=245;
12.开启同步功能
MariaDB [(none)]> start slave;#在从服务器上查看同步数据信息
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema || mysql || performance_schema || school ||test|
+--------------------+
5 rows inset(0.00 sec)
[root@localhost ~]# vim /etc/mysql-mmm/mmm_mon.conf<monitor>
ip 127.0.0.1
pid_path /run/mysql-mmm-monitor.pid
bin_path /usr/libexec/mysql-mmm
status_path /var/lib/mysql-mmm/mmm_mond.status
#指向四台服务器的IP地址
ping_ips 192.168.142.131,192.168.45.134,192.168.45.130,192.168.45.135
auto_set_online 10
4.在所有数据库服务器上为mmm_agent授权
MariaDB [(none)]> grant super, replication client, process on *.* to 'mmm_agent'@'192.168.142.%' identified by '123456';
Query OK, 0 rows affected (0.02 sec)
5.在所有数据库服务器上为mmm_moniter授权
MariaDB [(none)]> grant replication client on *.* to 'mmm_monitor'@'192.168.18.%' identified by '123456';
Query OK, 0 rows affected (0.02 sec)