How to build your own cloud database in docker

Author's words

Cloud databases of major cloud service providers are very expensive , If we want to build our own cloud database to reduce costs , What to do ？ We can use cloud server to realize , There are two ways , One is directly on the cloud server （linux edition ) Jacket linux Version of mysql, The other is in docke Create your own by pulling the image mysql Containers , Its advantage is that it can create multiple mysql Containers , Install directly in the cloud service mysql, Only one cloud database can be installed .

preparation

technology ：docker knowledge linux command
Tools ：navicat mysql database Virtual machine ESC
Environmental Science ：centos 7

Code implementation

1. Check to see if... Is already installed mysql Mirror image

Use docker images View the installation image , If it were not so , adopt docker pull ( Mirror source ) Pull one mysql Mirror image

[[email protected] root]# docker images
REPOSITORY                     TAG                 IMAGE ID            CREATED             SIZE
centos/mysql-57-centos7        latest              f83a2938370c        6 weeks ago         452MB

2. see docker Operation status in the container

adopt docker ps see dockers The state of the container in ,docker ps Show status Has been suspended up The container of .docker ps -a The display status is exiit The container of , Delete container ,docker rm CONTAINER ID, Example ：docker rm 0b

[[email protected] root]# docker ps
CONTAINER ID        IMAGE                     COMMAND                  CREATED             STATUS              PORTS                    NAMES
0b71daef059c        centos/mysql-57-centos7   "container-entrypoin…"   4 weeks ago         Up 13 days          0.0.0.0:3307->3306/tcp   mysql02

3.docker Startup and operation mysql Mirror image

docker run -p 3308:3306 --name mysql03 -e MYSQL_ROOT_PASSWORD=123456 -d centos/mysql-57-centos7
-p Represents a port mapping
–name : Name your container
-e MYSQL_ROOT_PASSWORD=123456 ： Set parameters
-d The background to perform
Note that the mapping cannot be written as 3306:3306, It may be related to your local 3306 Caused by conflict

 [[email protected] root]# docker run -p 3308:3306 --name mysql03 -e MYSQL_ROOT_PASSWORD=123456 -d centos/mysql-57-centos7
ceec68111b3078e87bb5a7fa9d4b7923a18a2b9c9743cad939ad6cce78141570
[[email protected] root]# docker ps
CONTAINER ID        IMAGE                     COMMAND                  CREATED             STATUS              PORTS                    NAMES
ceec68111b30        centos/mysql-57-centos7   "container-entrypoin…"   10 seconds ago      Up 7 seconds        0.0.0.0:3308->3306/tcp   mysql03
0b71daef059c        centos/mysql-57-centos7   "container-entrypoin…"   4 weeks ago         Up 13 days          0.0.0.0:3307->3306/tcp   mysql02

4. use navicat Connect to the cloud database we created

Turn on the computer , use navicat Enter the name of the virtual machine ip and docker Where we run mysql Connect with the container port number , Click ok ok, Cloud data succeeded

5. design sketch

Okay , Your own cloud database can be used . If you want to build another one , Just repeat

6 I hope I can help you , If you need technical service help, you can add me QQ:1728608455
Follow my official account to get Java Learning materials .