国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > MySQL > 正文

詳解Docker創建Mysql容器并通過命令行連接到容器

2019-11-02 16:50:31
字體:
來源:轉載
供稿:網友

拉取網易蜂巢的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)
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 中山市| 泾源县| 闽侯县| 延津县| 天柱县| 城市| 肇庆市| 江达县| 奉节县| 博乐市| 盘山县| 宁城县| 泰来县| 河北省| 北安市| 商南县| 泰和县| 延安市| 彰武县| 台州市| 明溪县| 东丰县| 阿荣旗| 双桥区| 南郑县| 岑溪市| 罗甸县| 进贤县| 板桥市| 犍为县| 同江市| 灵台县| 鄂州市| 洪湖市| 河曲县| 衡南县| 宜丰县| 马龙县| 新源县| 女性| 松桃|