1. Install bind
[root@server data]# yum -y install bind bind-utils
A. Configuring MySQL Server on Server01
1. Edit & add db file conf /etc/my.cnf
server_id=1
replicate-do-db=teguht
#bind-address=10.10.10.10
log-bin = mysql-bin
binlog_do_db = teguht
set global read_only=on;
set global read_only=off;
skip-slave-start
set global read_only=1;
======
[root@MariaDB002 ~]# cat /etc/my.cnf.d/server.cnf
## -> only 1 database (teguhth)
[mariadb]
server_id=1
replicate-do-db=teguhth
#bind-address=10.10.10.10
log-bin = mysql-bin
binlog_do_db = teguhth
## -> more 2 database (teguhth, secretdb, labdb)
[mariadb]
server_id=1
replicate-do-db=teguhth
replicate-do-db=secretdb
replicate-do-db=labdb
#bind-address=10.10.10.10
log-bin = mysql-bin
binlog_do_db = teguhth
binlog_do_db = secretdb
binlog_do_db = labdb
sample log