MariaDB MySQL Master Slave Replication – Ubuntu 20.04 LTS

The following are the critical queries that you would be running during this tutorial.

CHANGE MASTER TO MASTER_HOST=’MASTER_IP’, MASTER_USER=’MASTER_USER’, MASTER_PASSWORD=’MASTER_PASSWORD’, MASTER_LOG_FILE=’MASTER_LOG_FILE’, MASTER_LOG_POS=LOG_POSITION;

START SLAVE;

SHOW SLAVE STATUS G;

CREATE DATABASE readydedis;