拉取網易蜂巢的mysql-server:5.6
docker pull hub.c.163.com/nce2/mysql:5.6
創建mysql5.6容器 1master+3個slave
docker run --name mysql-master -d -P hub.c.163.com/nce2/mysql:5.6docker run --name mysql-slave1 -d -P hub.c.163.com/nce2/mysql:5.6docker run --name mysql-slave2 -d -P hub.c.163.com/nce2/mysql:5.6docker run --name mysql-slave3 -d -P hub.c.163.com/nce2/mysql:5.6
驗證容器狀態
[root@bogon ~]# docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES907bbbf25d25 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 5 minutes ago Up 5 minutes 3306/tcp mysql-slave3a81df6c86808 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 5 minutes ago Up 5 minutes 3306/tcp mysql-slave2375eabd4c598 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 5 minutes ago Up 5 minutes 3306/tcp mysql-slave11651d1cab219 hub.c.163.com/nce2/mysql:5.6 "/run.sh" 14 minutes ago Up 14 minutes 3306/tcp mysql-master
通過主機命令行進入master容器
docker exec -it mysql-master bash[root@bogon ~]# docker exec -it mysql-master bashroot@1651d1cab219:/#
在master中創建一個數據庫test_docker
root@1651d1cab219:/# mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 4Server version: 5.6.19-v1-log MySQL Community Server (GPL)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test |+--------------------+5 rows in set (0.02 sec)mysql> create database test_docker;Query OK, 1 row affected (0.06 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test || test_docker |+--------------------+6 rows in set (0.00 sec)
在slave1中創建一個數據庫test_docker
[root@bogon ~]# docker exec -it mysql-slave bashError response from daemon: No such container: mysql-slave[root@bogon ~]# docker exec -it mysql-slave1 bashroot@375eabd4c598:/# mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 4Server version: 5.6.19-v1-log MySQL Community Server (GPL)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || #bak_database || mysql || performance_schema || test |+--------------------+5 rows in set (0.00 sec)
新聞熱點
疑難解答
圖片精選