Skip to content

banggeunho/msa_mysql_replication

Repository files navigation

실행

./build.sh

마스터 DB / 테이블 생성 및 데이터 입력

docker exec mysql_master sh -c "export MYSQL_PWD=111; mysql -u root {DB_NAME} -e 'create table test(test int); insert test code values (100), (200)'"

슬레이브 DB / 데이터 확인

docker exec mysql_slave sh -c "export MYSQL_PWD=111; mysql -u root {DB_NAME} -e 'select * from test \G'"

Run command inside "mysql_master"

docker exec mysql_master sh -c 'mysql -u root -p111 -e "SHOW MASTER STATUS \G"'

Run command inside "mysql_slave"

docker exec mysql_slave sh -c 'mysql -u root -p111 -e "SHOW SLAVE STATUS \G"'

Enter into "mysql_master"

docker exec -it mysql_master bash

Enter into "mysql_slave"

docker exec -it mysql_slave bash

About

MySQL Replication 자동 설정 (Dokcer-compose, Shell)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages