同一条服务器（centos7）配置mysql 主从同步

本篇所有路径  接上一篇：CentOS7下yum安装MariaDB配置多实例 https://blog.csdn.net/u011342720/article/details/83213558

说明：以下的端口为3307的实例为主数据库，3308 对应的实例为从库

主数据库 配置文件

 cd /home/multiMysql/

vim ./etc/3307.cnf 

新增内容：

server-id=3307
log-bin=master-bin
log-bin-index=master-bin.index

binlog-do-db=test1

[client]
port = 3307
socket = /home/multiMysql/socket/mysql3307.sock
[mysqld]
datadir=/home/multiMysql/datadir/3307
port = 3307
socket = /home/multiMysql/socket/mysql3307.sock

tmpdir=/home/multiMysql/tmp/3307

myisam-recover-options = BACKUP

server-id=3307
log-bin=master-bin
log-bin-index=master-bin.index

binlog-do-db=test1

重启主数据库：

[root@server187 multiMysql]# ./bin/mysql3307 restart
Stoping MySQL...
Starting MySQL...
Start MySql OK! PORT:3307
[root@server187 multiMysql]# 

查看主库的状态：

[root@server187 multiMysql]# mysql -u root -p -S ./socket/mysql3307.sock 
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 15
Server version: 10.3.8-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' f