MySQL 5.7 互为主从
【备注】master1 xx.104.242.89 master2 xx.182.126.76同步的数据库 ultrax同步的数据库 blog在master1上面配置vi /etc/my.cnf主从配置master1 xx.104.242.89user = mysql log_bin = mysql-bin relay_log=relay-bin binlog_format=mixed serve
MySQL 5.7 数据库主从
主服务器(source)：vi /etc/my.cnf log_bin = mysql-bin # 这里是一个路径文件，名字自定义 server_id = 1 binlog-checksum = none expire-logs-days = 7 # 只保留7天的日志重启mysql，然后进入mysql执行：mysql> flush logs; mysql> show master st