MySQL 5.7 Replication

Set Up Selective Master Slave Replication in MySQL

Oracle VM Virtual Box Settings

Master Mysql Server Settings

  • The first step is to set up the master database for replication. This can be done while the database server is running. You would edit the my.cnf file on the master database:
log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=DATABASE_NAME1
binlog-do-db=DATABASE_NAME2
server-id=1


https://www.lexiconn.com/blog/2014/04/how-to-set-up-selective-master-slave-replication-in-mysql/

Slave Mysql Settings

Federated Tables

MySQL Errors to File

Retrieved from ‘http://rasimsen.com/index.php?title=MySQL_5.7_Replication&oldid=821’