MARIADB DELAYED REPLICATION DOCKER

This repo contains docker-compose file which will set mariadb delayed replica

Getting Started:

Follow these steps

You need install following

copy .env.example to .env

cp .env.example .env

Now edit .env it has following variables

Variable Name	Description
MYSQL_MASTER_PASSWORD	Password of mariadb root for master node
MYSQL_SLAVE_PASSWORD	Password of mariadb root for replica node
MYSQL_REPLICATION_USER	Username which will be used to connect to master node by replica node
MYSQL_REPLICATION_PASSWORD	Password which will be used to connect to master node by replica node
MASTER_DELAY	Dealy for query to run in seconds

Run the containers by running following command

docker-compose up -d

Once every thing is up and running now run following command

docker ps

it will show you all of your container running there you can find docker-mysql-delayed-replication_mysql-master_1

 docker exec -ti docker-mysql-delayed-replication_mysql-master_1 bash

Connect to your database don't forget to replace YOUR_MASTER_ROOT_PASSOWRD

mysql -uroot -p<YOUR_MASTER_ROOT_PASSOWRD>;

Now create a database don't forget to replace DATA_BASE_NAME_HERE

CREATE DATABASE <DATA_BASE_NAME_HERE>;

Now connect to you replica node connect to mysql and check your database by running following command

SHOW DATABASES;

After time you specifed in .env you will see the new database. Now create a table and insert some recode and test resules.