Skip to content

Instantly share code, notes, and snippets.

View t0e8r1r4y's full-sized avatar
🐡

Terry Shin t0e8r1r4y

🐡
View GitHub Profile
@t0e8r1r4y
t0e8r1r4y / sr
Created November 19, 2022 18:08
sr
*************************** 1. row ***************************
Slave_IO_State: Connecting to source
Master_Host: db_master
Master_User: db_name
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000006
Read_Master_Log_Pos: 157
Relay_Log_File: relaylog.000001
Relay_Log_Pos: 4
@t0e8r1r4y
t0e8r1r4y / slave-set
Created November 19, 2022 18:06
slave-set
mysql --host <ip> --port 33307 -uroot -p<password> -e "CHANGE MASTER TO MASTER_HOST='db_master', MASTER_USER='db_name', MASTER_PASSWORD='rootpassword', MASTER_LOG_FILE='mysql-bin.000007', MASTER_LOG_POS=157"
@t0e8r1r4y
t0e8r1r4y / result
Created November 19, 2022 18:04
result
*************************** 1. row ***************************
File: mysql-bin.000007
Position: 157
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set:
@t0e8r1r4y
t0e8r1r4y / slave
Created November 19, 2022 17:57
slave
[mysqld]
log-bin=mysql-bin
server-id=2
relay-log=relaylog
log-slave_updates=1
@t0e8r1r4y
t0e8r1r4y / master
Created November 19, 2022 17:56
master
[mysqld]
log-bin=mysql-bin
server-id=1
@t0e8r1r4y
t0e8r1r4y / dir
Created November 19, 2022 17:54
dir
.
β”œβ”€β”€ docker-compose.yml
β”œβ”€β”€ mariadb_root_password.txt
β”œβ”€β”€ master
β”‚Β Β  β”œβ”€β”€ config
β”‚Β Β  β”œβ”€β”€ data
β”‚Β Β  └── mysql-init-files
β”œβ”€β”€ run.sh
└── slave
β”œβ”€β”€ config
@t0e8r1r4y
t0e8r1r4y / dockerfile
Created November 19, 2022 17:48
dockerfile
version: "3.3"
services:
db_master:
image: mysql:latest
container_name: db_master
restart: always
environment:
MYSQL_ROOT_PASSWORD_FILE: /run/secrets/mariadb_root_password
volumes:
@t0e8r1r4y
t0e8r1r4y / dockerfile
Created November 19, 2022 17:47
dockerfile
version: "3.3"
services:
db_master:
image: mysql:latest
container_name: db_master
restart: always
environment:
MYSQL_ROOT_PASSWORD_FILE: /run/secrets/mariadb_root_password
volumes:
@t0e8r1r4y
t0e8r1r4y / dir
Created November 19, 2022 17:46
dir
.
β”œβ”€β”€ docker-compose.yml
β”œβ”€β”€ mariadb_root_password.txt
β”œβ”€β”€ master
β”‚Β Β  β”œβ”€β”€ Dockerfile
β”‚Β Β  β”œβ”€β”€ config
β”‚Β Β  β”œβ”€β”€ data
β”‚Β Β  └── mysql-init-files
β”œβ”€β”€ run.sh
└── slave