（1）先docker images查看本機(jī)的鏡像有沒(méi)有mysql
- docker images命令
[root@Master ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
redis latest 987b78fc9e38 11 months ago 104MB
rabbitmq 3.7.7-management 2888deb59dfc 2 years ago 149MB
（2）沒(méi)有mysql鏡像的話拉取mysql鏡像唧龄，可以通過(guò)docker search mysql來(lái)查看mysql相關(guān)鏡像桨嫁，不過(guò)具體版本信息還是要在http://hub.docker.com上查詢强法，這里選擇拉取mysql:5.7版本的鏡像。
- docker search mysql命令和docker pull mysql:5.7命令
[root@Master ~]# docker search mysql
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
mysql MySQL is a widely used, open-source relation… 10760 [OK]
mariadb MariaDB Server is a high performing open sou… 4050 [OK]
mysql/mysql-server Optimized MySQL Server Docker images. Create… 791 [OK]
percona Percona Server is a fork of the MySQL relati… 533 [OK]
centos/mysql-57-centos7 MySQL 5.7 SQL database server 87
mysql/mysql-cluster Experimental MySQL Cluster Docker images. Cr… 81
centurylink/mysql Image containing mysql. Optimized to be link… 59 [OK]
bitnami/mysql Bitnami MySQL Docker Image 50 [OK]
databack/mysql-backup Back up mysql databases to... anywhere! 43
deitch/mysql-backup REPLACED! Please use http://hub.docker.com/r… 41 [OK]
prom/mysqld-exporter 37 [OK]
tutum/mysql Base docker image to run a MySQL database se… 35
schickling/mysql-backup-s3 Backup MySQL to S3 (supports periodic backup… 29 [OK]
linuxserver/mysql A Mysql container, brought to you by LinuxSe… 27
centos/mysql-56-centos7 MySQL 5.6 SQL database server 20
circleci/mysql MySQL is a widely used, open-source relation… 20
mysql/mysql-router MySQL Router provides transparent routing be… 19
arey/mysql-client Run a MySQL client from a docker container 17 [OK]
fradelg/mysql-cron-backup MySQL/MariaDB database backup using cron tas… 12 [OK]
yloeffler/mysql-backup This image runs mysqldump to backup data usi… 7 [OK]
openshift/mysql-55-centos7 DEPRECATED: A Centos7 based MySQL v5.5 image… 6
devilbox/mysql Retagged MySQL, MariaDB and PerconaDB offici… 3
ansibleplaybookbundle/mysql-apb An APB which deploys RHSCL MySQL 2 [OK]
jelastic/mysql An image of the MySQL database server mainta… 1
widdpim/mysql-client Dockerized MySQL Client (5.7) including Curl… 1 [OK]
[root@Master ~]# docker pull mysql:5.7
5.7: Pulling from library/mysql
f7ec5a41d630: Pull complete
9444bb562699: Pull complete
6a4207b96940: Pull complete
181cefd361ce: Pull complete
8a2090759d8a: Pull complete
15f235e0d7ee: Pull complete
d870539cd9db: Pull complete
7310c448ab4f: Pull complete
4a72aac2e800: Pull complete
b1ab932f17c4: Pull complete
1a985de740ee: Pull complete
Digest: sha256:e42a18d0bd0aa746a734a49cbbcc079ccdf6681c474a238d38e79dc0884e0ecc
Status: Downloaded newer image for mysql:5.7
docker.io/library/mysql:5.7
（3）最后再docker images查看下鏡像信息膏萧，確保本地同步好mysql鏡像漓骚，然后開(kāi)始啟動(dòng)mysql容器，因?yàn)閐ocker容器的特性榛泛，所以要雙開(kāi)mysql非常之方便蝌蹂，只需做好端口映射即可，每個(gè)容器都擁有自己的文件系統(tǒng)曹锨、CPU孤个、內(nèi)存、進(jìn)程空間等資源沛简，故無(wú)需在服務(wù)器上安裝兩個(gè)mysql數(shù)據(jù)庫(kù)齐鲤，然后修改my.cnf配置文件的端口，只需在docker容器啟動(dòng)時(shí)做好服務(wù)器外部端口映射即可椒楣。
參數(shù)說(shuō)明：
-p 3307:3306：服務(wù)器的3307端口映射到docker容器的3306端口给郊。
--name mysqlone：運(yùn)行容器服務(wù)名字。
-v /etc/mysql/conf.d:/etc/mysql/conf.d：對(duì)宿主機(jī)/etc/mysql/conf.d目錄下數(shù)據(jù)庫(kù)配置文件與容器/etc/mysql/conf.d目錄下數(shù)據(jù)庫(kù)配置文件進(jìn)行映射掛載捧灰。
-v /var/log/mysql:/var/log/mysql：對(duì)宿主機(jī)/var/log/mysql目錄下數(shù)據(jù)庫(kù)日志與容器/var/log/mysql目錄下數(shù)據(jù)庫(kù)日志進(jìn)行映射掛載淆九。
-v /var/lib/mysql:/var/lib/mysql：對(duì)宿主機(jī)數(shù)據(jù)庫(kù)/var/lib/mysql目錄下與容器數(shù)據(jù)庫(kù)目錄/var/lib/mysql進(jìn)行映射掛載。
-e MYSQL_ROOT_PASSWORD=123456：初始化 root 用戶的密碼毛俏。
-d mysql:5.7：后臺(tái)運(yùn)行mysql5.7炭庙。
--character-set-server=utf8mb4 ：設(shè)置字符集。
--collation-server=utf8mb4_unicode_ci：設(shè)置校對(duì)集煌寇。
- 比較重要的是-v xxx:xxx 掛載容器的數(shù)據(jù)庫(kù)文件到宿主機(jī)上焕蹄，相當(dāng)于一次備份，假若容器被刪除了唧席，那么數(shù)據(jù)還在的擦盾，如果不掛載，重啟容器是不會(huì)丟失數(shù)據(jù)的淌哟，但是為了安全保證迹卢，還是需要掛載備份，重啟容器時(shí)也會(huì)從宿主機(jī)目錄下去加載相關(guān)文件徒仓。
- docker run -p 3307:3306 --name mysqlone -v /etc/mysql/conf.d:/etc/mysql/conf.d -v /var/log/mysql:/var/log/mysql -v /var/lib/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci 命令一
- docker run -p 3308:3306 --name mysqltwo -v /etc/mysql/conf.d:/etc/mysql/conf.d -v /var/log/mysql:/var/log/mysql -v /var/lib/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci 命令二
[root@Master ~]# docker run -p 3307:3306 --name mysqlone -v /etc/mysql/conf.d:/etc/mysql/conf.d -v /var/log/mysql:/var/log/mysql -v /var/lib/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
6e64d2aefdd37c1bd76c64f45936ea272f2ac074906fb9b2b0a9ab69f8f6d41e
[root@Master ~]# docker run -p 3308:3306 --name mysqltwo -v /etc/mysql/conf.d:/etc/mysql/conf.d -v /var/log/mysql:/var/log/mysql -v /var/lib/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
8aef946b1dd270b1601174f4bec41af46753971c3307bd7568802fb3327bbd27
- docker ps -a 命令列出所有容器情況腐碱，可以看到有兩個(gè)正在運(yùn)行的mysql，服務(wù)器外部端口3307和3308，這樣我們可以通過(guò)navicat來(lái)連接服務(wù)器的兩個(gè)mysql數(shù)據(jù)庫(kù)症见。
[root@Master ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
8aef946b1dd2 mysql:5.7 "docker-entrypoint.s…" About a minute ago Up About a minute 33060/tcp, 0.0.0.0:3308->3306/tcp mysqltwo
6e64d2aefdd3 mysql:5.7 "docker-entrypoint.s…" About a minute ago Up About a minute 33060/tcp, 0.0.0.0:3307->3306/tcp mysqlone
cf945a87496b 2888deb59dfc "docker-entrypoint.s…" 10 months ago Exited (255) 13 hours ago 4369/tcp, 5671/tcp, 0.0.0.0:5672->5672/tcp, 15671/tcp, 25672/tcp, 0.0.0.0:15672->15672/tcp rabbitmq3.7.7
4903a31afb36 redis:latest "docker-entrypoint.s…" 10 months ago Exited (255) 13 hours ago 0.0.0.0:6379->6379/tcp determined_banach
-
navicat連接兩個(gè)mysql
3307mysql.png
3308mysql.png
- docker logs查看mysqlone容器日志喂走，參數(shù) -t 表示顯示時(shí)間戳，-f 跟蹤日志輸出谋作，--tail 僅列出最新N條容器日志
[root@Master ~]# docker logs -t -f --tail 10 mysqlone
2021-04-17T15:08:17.272288827Z 2021-04-17T15:08:17.272248Z 0 [Warning] CA certificate ca.pem is self signed.
2021-04-17T15:08:17.272317126Z 2021-04-17T15:08:17.272292Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-04-17T15:08:17.272824510Z 2021-04-17T15:08:17.272786Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-04-17T15:08:17.272835327Z 2021-04-17T15:08:17.272820Z 0 [Note] IPv6 is available.
2021-04-17T15:08:17.272839017Z 2021-04-17T15:08:17.272828Z 0 [Note] - '::' resolves to '::';
2021-04-17T15:08:17.272862363Z 2021-04-17T15:08:17.272839Z 0 [Note] Server socket created on IP: '::'.
2021-04-17T15:08:17.273439643Z 2021-04-17T15:08:17.273404Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2021-04-17T15:08:17.280404233Z 2021-04-17T15:08:17.280357Z 0 [Note] Event Scheduler: Loaded 0 events
2021-04-17T15:08:17.280607320Z 2021-04-17T15:08:17.280525Z 0 [Note] mysqld: ready for connections.
2021-04-17T15:08:17.280616667Z Version: '5.7.33' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
- docker exec -it mysqlone /bin/bash命令進(jìn)入mysqlone容器
[root@Master ~]# docker exec -it mysqlone /bin/bash
root@22e10973a47d:/#
- 在mysqlone容器中連接mysql芋肠，輸入mysql -u root -p回車然后輸入密碼，可以看到就進(jìn)入mysql了遵蚜。
root@22e10973a47d:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.33 MySQL Community Server (GPL)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> quit
Bye
root@22e10973a47d:/#
- 退出容器
root@22e10973a47d:/# exit
exit
[root@Master ~]#
- docker inspec 容器名/容器ID命令查看容器掛載于宿主機(jī)目錄
[root@Master ~]# docker inspect mysqlone
可在HostConfig的binds查看掛載映射目錄
docker inspec命令.png
- docker stop和docker rm命令暫停和刪除mysqlone容器
[root@Master ~]# docker stop mysqlone
mysqlone
[root@Master ~]# docker rm mysqlone
mysqlone
最后docker ps -a檢查有沒(méi)有刪除成功即可帖池。
