Syarat: Replikasi DB
Versi DB Master/Slave Sama
1. Master
nano /etc/my.cnf.d/server.conf
[server]
# add follows in [server] section : get binary logs
log-bin=mysql-bin
# define uniq server ID
server-id=101
systemctl restart mariadb
mysql -u root -p
grant replication slave on *.* to replica@'%' identified by 'password';
flush privileges;
exit
2. Slave
nano /etc/my.cnf.d/server.conf
[server]
# add follows in [server] section : get binary logs
log-bin=mysql-bin
# define server ID (different one from Master Host)
server-id=102
# read only
read_only=1
# define own hostname
report-host=192.168.x.xxx #IP Slave
systemctl restart mariadb
3. Master
mysql -u root -p
flush tables with read lock;
show master status;
mysqldump -u root -p --all-databases --lock-all-tables --events > mysql_dump.sql
unlock tables;
exit;
scp mysql_dump.sql 192.168.x.xxx:/tmp/ #IP Slave
4. Slave
mysql -u root -p < /tmp/mysql_dump.sql
mysql -u root -p
change master to
master_host='192.168.1.252', #IP Master
master_user='replica',
master_password='*#Master01',
master_log_file='mysql-bin.000040',
master_log_pos=342;
start slave;
show slave status;
