MariaDB主服务器：

vi /etc/my.cnf

[mysqld]

skip_name_resolve = ON

innodb_file_per_table = ON

server-id = 1

log-bin = master-log

mysql>

grant replication slave,replication client on *.* to 'repluser'@'10.10.10.%' identified by '123456';

flush privileges;

show master status\G

将查询到的结果做好记录，一会儿配置从服务器的时候需要用到

MariaDB从服务器：

vi /etc/my.cnf

[mysqld]

skip_name_resolve = ON

innodb_file_per_table = ON

server-id = 2

relay-log = slave-log

mysql>

change master to master_host='10.10.10.111',master_port=55501,master_user='repluser',master_password='123456',master_log_file='master-log.000001',master_log_pos=499;

start slave;

show slave status\G

除特别注明外，本站所有文章均为奇妙伞原创，转载请注明出处来自https://www.qm3.com.cn/post/210.html