📄 설명

📣 기본

Docker를 이용해 간단히 Mariadb Replication 방법을 안내
bitnami/mariadb를 사용(아래 참고 문서 포함)

📄 사용방법

📣 MASTER

✍ 기본 명령어

$ docker run --name mariadb-master \
  -e MARIADB_ROOT_PASSWORD=master_root_password \
  -e MARIADB_REPLICATION_MODE=master \
  -e MARIADB_REPLICATION_USER=my_repl_user \
  -e MARIADB_REPLICATION_PASSWORD=my_repl_password \
  -e MARIADB_USER=my_user \
  -e MARIADB_PASSWORD=my_password \
  -e MARIADB_DATABASE=my_database \
  bitnami/mariadb:latest

✍ 추가 옵션 적용

$ docker run --name mariadb-master \
  -e MARIADB_ROOT_PASSWORD=master_root_password \
  -e MARIADB_REPLICATION_MODE=master \
  -e MARIADB_REPLICATION_USER=my_repl_user \
  -e MARIADB_REPLICATION_PASSWORD=my_repl_password \
  -e MARIADB_USER=my_user \
  -e MARIADB_PASSWORD=my_password \
  -e MARIADB_DATABASE=my_database \
  -v your data path:/bitnami/mariadb/data \ # volumn 설정
  -p 3306:3306 \ # 포트 설정
  --restart=always \ # 자동 재시작
  -d \ # 데몬 실행
  bitnami/mariadb:latest

📣 SLAVE

✍ 기본 명령어 (동일한 서버에 복제)

$ docker run --name mariadb-slave --link mariadb-master:master \
  -e MARIADB_REPLICATION_MODE=slave \
  -e MARIADB_REPLICATION_USER=my_repl_user \
  -e MARIADB_REPLICATION_PASSWORD=my_repl_password \
  -e MARIADB_MASTER_HOST=master \
  -e MARIADB_MASTER_ROOT_PASSWORD=master_root_password \
  bitnami/mariadb:latest

✍ 기본 명령어 (다른 서버에 복제)

$ docker run --name mariadb-slave \
  -e MARIADB_REPLICATION_MODE=slave \
  -e MARIADB_REPLICATION_USER=my_repl_user \
  -e MARIADB_REPLICATION_PASSWORD=my_repl_password \
  -e MARIADB_MASTER_HOST=slave_server_host \
  -e MARIADB_MASTER_ROOT_PASSWORD=master_root_password \
  bitnami/mariadb:latest

✍ 추가 옵션 적용

$ docker run --name mariadb-slave \
  -e MARIADB_REPLICATION_MODE=slave \
  -e MARIADB_REPLICATION_USER=my_repl_user \
  -e MARIADB_REPLICATION_PASSWORD=my_repl_password \
  -e MARIADB_MASTER_HOST=slave_server_host \
  -e MARIADB_MASTER_ROOT_PASSWORD=master_root_password \
  -v your_data_path:/bitnami/mariadb/data \ # volumn 설정
  -p 3306:3306 \ # 포트 설정
  -d \ # 데몬 실행
  bitnami/mariadb:latest

📄 참고자료

🎈 Document : https://github.com/bitnami/bitnami-docker-mariadb