Difference between revisions of "MySQL 5.7 Replication"
(→Master Mysql Server Settings) |
|||
| Line 3: | Line 3: | ||
==Master Mysql Server 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: | ||
| + | <source> | ||
| + | log-bin = /var/log/mysql/mysql-bin.log | ||
| + | binlog-do-db=DATABASE_NAME1 | ||
| + | binlog-do-db=DATABASE_NAME2 | ||
| + | server-id=1 | ||
| + | </source> | ||
| + | |||
| + | |||
| + | https://www.lexiconn.com/blog/2014/04/how-to-set-up-selective-master-slave-replication-in-mysql/ | ||
==Slave Mysql Settings== | ==Slave Mysql Settings== | ||
Latest revision as of 06:00, 9 November 2018
Set Up Selective Master Slave Replication in MySQL
Contents
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/
