1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
| cd ~
mkdir -p mydata/mysql-master/log
mkdir -p mydata/mysql-master/data
mkdir -p mydata/mysql-master/conf
mkdir -p mydata/mysql-slave/log
mkdir -p mydata/mysql-slave/data
mkdir -p mydata/mysql-slave/conf
cd mydata/mysql-master/conf
vi my.cnf
docker pull --platform linux/x86_64 mysql:5.7.30
docker run -p 3307:3306 --name mysql-master \
-v ~/mydata/mysql-master/log:/var/log/mysql \
-v ~/mydata/mysql-master/data:/var/lib/mysql \
-v ~/mydata/mysql-master/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7.30
docker run -p 3308:3306 --name mysql-slave \
-v ~/mydata/mysql-slave/log:/var/log/mysql \
-v ~/mydata/mysql-slave/data:/var/lib/mysql \
-v ~/mydata/mysql-slave/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7.30
docker exec -it mysql-master mysql -uroot -p123456 -e "CREATE USER 'slave'@'%' IDENTIFIED BY '123456';"
docker exec -it mysql-master mysql -uroot -p123456 -e "GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%';"
docker exec -it mysql-slave mysql -uroot -p123456 -e "change master to master_host='host.docker.internal', master_user='slave', master_password='123456', master_port=3307, master_log_file='mall-mysql-bin.000003', master_log_pos=617, master_connect_retry=30;"
docker exec -it mysql-slave mysql -uroot -p123456 -e "START SLAVE;"
docker exec -it mysql-slave mysql -uroot -p123456 -e "show slave status \G;"
docker exec -it mysql-slave mysql -uroot -p123456 -e "STOP SLAVE IO_THREAD FOR CHANNEL '';"
docker exec -it mysql-master mysql -uroot -p123456 -e "CREATE DATABASE testdb;"
docker exec -it mysql-master mysql -uroot -p123456 -e "USE testdb; CREATE TABLE testtable (id INT NOT NULL PRIMARY KEY); INSERT INTO testtable (id) VALUES (1);"
docker exec -it mysql-slave mysql -uroot -p123456 -e "SELECT * FROM testdb.testtable;"
docker exec -it mysql-master mysql -uroot -p123456 -e "USE testdb; INSERT INTO testtable (id) VALUES (2);"
|