//将docker中的数据库放入到真实文件夹/usr/local/mysql/data中
docker run -d -e MYSQL_ROOT_PASSWORD=admin --name mysql -v /usr/local/mysql/data:/var/lib/mysql -p 3306:3306 2a2a35106ec5
-d守护式方式
-e设置环境变量
docker run -i -t -e MYSQL_ROOT_PASSWORD=admin --name mysql -v /usr/local/mysql/data:/var/lib/mysql -p 3306:3306 2a2a35106ec5
-i以交互模式运行容器,通常与 -t 同时使用
//主从配置开始
docker run -d -e MYSQL_ROOT_PASSWORD=admin --name mysql-master -v /etc/soft/my-m.cnf:/etc/mysql/my.cnf -p 3306:3306 c73c7527c03a
c27c43e3f9006d30b4d834ce58926463606490bde4f27a7a6a9ac2b92aac3c57
//从
docker run -d -e MYSQL_ROOT_PASSWORD=admin --name mysql-slave -v /etc/soft/my-s2.cnf:/etc/mysql/my.cnf -p 3308:3306 c73c7527c03a
03235d40ba9e161a6e09d2ad023ba804fcae9c08190c7a6889aa3cf518b2a04a
//主库授权
grant all on *.* to 'puxubo'@'%' identified by '123456';
flush privileges;
show master status;
mysql-bin.000002 1687
//查看docker容器的IP地址
docker inspect 7c0ec150e60c | grep IPAddress
//从库设置
change master to master_host='172.17.0.2',master_user='puxubo',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=580,master_port=3306;
start slave;
show slave status
docker run -d -e MYSQL_ROOT_PASSWORD=admin --name mysql -v /usr/local/mysql/data:/var/lib/mysql -p 3306:3306 2a2a35106ec5
-d守护式方式
-e设置环境变量
docker run -i -t -e MYSQL_ROOT_PASSWORD=admin --name mysql -v /usr/local/mysql/data:/var/lib/mysql -p 3306:3306 2a2a35106ec5
-i以交互模式运行容器,通常与 -t 同时使用
//主从配置开始
docker run -d -e MYSQL_ROOT_PASSWORD=admin --name mysql-master -v /etc/soft/my-m.cnf:/etc/mysql/my.cnf -p 3306:3306 c73c7527c03a
c27c43e3f9006d30b4d834ce58926463606490bde4f27a7a6a9ac2b92aac3c57
//从
docker run -d -e MYSQL_ROOT_PASSWORD=admin --name mysql-slave -v /etc/soft/my-s2.cnf:/etc/mysql/my.cnf -p 3308:3306 c73c7527c03a
03235d40ba9e161a6e09d2ad023ba804fcae9c08190c7a6889aa3cf518b2a04a
//主库授权
grant all on *.* to 'puxubo'@'%' identified by '123456';
flush privileges;
show master status;
mysql-bin.000002 1687
//查看docker容器的IP地址
docker inspect 7c0ec150e60c | grep IPAddress
//从库设置
change master to master_host='172.17.0.2',master_user='puxubo',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=580,master_port=3306;
start slave;
show slave status