docker-mysql-replication

MYSQL REPLICATION TEST

BUILD: docker-compose build

RUN: docker-compose up

RUN: ./status-master.sh result: +------------------+----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+-------------------+ | mysql-bin.000003 | 154 | xbrlgen | | | +------------------+----------+--------------+------------------+-------------------+

make sure File is "mysql-bin.000003" IF NOT RUN SQL ON SLAVE: CHANGE MASTER TO MASTER_HOST='mysql-master', MASTER_USER='replica', MASTER_PASSWORD='duren123', MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=0; RESTART slave

RUN: ./status-slave.sh make sure no error (Last_IO_Error and Last_SQL_Error)

TEST: Check slave data: docker exec -ti mysql-master mysql -u root --password=dodol123 xbrlgen run sql: SHOW TABLES; make sure no table exists

Run test sql on master: docker exec -i mysql-master mysql -u root --password=dodol123 xbrlgen < test.sql

Check slave data: docker exec -ti mysql-master mysql -u root --password=dodol123 xbrlgen run sql: SHOW TABLES; make sure table DATA1 exists SELECT * FROM DATA1; make sure table DATA1 is not empty

RUN: ./status-master.sh check the Position ./status-slave.sh check Exec_Master_Log_Pos equal with

CLEAN-UP: docker-compose rm -f