Running mysql in a docker container.
First thing we do is to pull the mysql image and then inspect it and look for the volume location.
[root@centos7 ~]# docker pull mysql
Using default tag: latest
latest: Pulling from library/mysql
be8881be8156: Already exists
c3995dabd1d7: Pull complete
9931fdda3586: Pull complete
bb1b6b6eff6a: Pull complete
a65f125fa718: Pull complete
2d9f8dd09be2: Pull complete
37b912cb2afe: Pull complete
54242fcd8eaa: Pull complete
0a9d4d211511: Pull complete
270ae5bd02c2: Pull complete
9b55b8e72e70: Pull complete
68083f7985cd: Pull complete
Digest: sha256:d39a8ab7679df309e7eff6ddba434ad5747cc2a2acee2d7c60d8221c9acedcad
Status: Downloaded newer image for mysql:latest
[root@centos7 ~]# docker inspect mysql
[
{
"Id": "sha256:29e0ae3b69b9031ab7d7fd3024057b9441d74c8244e583cfb48697109148ca71",
"RepoTags": [
"mysql:latest"
],
"RepoDigests": [
"mysql@sha256:d39a8ab7679df309e7eff6ddba434ad5747cc2a2acee2d7c60d8221c9acedcad"
],
"Parent": "",
"Comment": "",
"Created": "2018-08-14T20:28:17.862454662Z",
"Container": "e09e8846dfec565c09eb0c3bdad39b596f3f594f4b9f101754db329bc6d3b810",
"ContainerConfig": {
"Hostname": "e09e8846dfec",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": false,
"AttachStderr": false,
"ExposedPorts": {
"3306/tcp": {},
"33060/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"GOSU_VERSION=1.7",
"MYSQL_MAJOR=8.0",
"MYSQL_VERSION=8.0.12-1debian9"
],
"Cmd": [
"/bin/sh",
"-c",
"#(nop) ",
"CMD [\"mysqld\"]"
],
"ArgsEscaped": true,
"Image": "sha256:fb95401a92d79b74a58472e5b75f36eefd85dd53e8ffe375ee1df856d6d621b2",
"Volumes": {
"/var/lib/mysql": {}
},
"WorkingDir": "",
"Entrypoint": [
"docker-entrypoint.sh"
],
"OnBuild": [],
"Labels": {}
},
"DockerVersion": "17.06.2-ce",
"Author": "",
"Config": {
"Hostname": "",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": false,
"AttachStderr": false,
"ExposedPorts": {
"3306/tcp": {},
"33060/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"GOSU_VERSION=1.7",
"MYSQL_MAJOR=8.0",
"MYSQL_VERSION=8.0.12-1debian9"
],
"Cmd": [
"mysqld"
],
"ArgsEscaped": true,
"Image": "sha256:fb95401a92d79b74a58472e5b75f36eefd85dd53e8ffe375ee1df856d6d621b2",
"Volumes": {
"/var/lib/mysql": {}
},
"WorkingDir": "",
"Entrypoint": [
"docker-entrypoint.sh"
],
"OnBuild": [],
"Labels": null
},
"Architecture": "amd64",
"Os": "linux",
"Size": 484472587,
"VirtualSize": 484472587,
"GraphDriver": {
"Data": {
"LowerDir": "/var/lib/docker/overlay2/8ec1e1150e83c11b58fe0a989e005bf4bb28abfa7cf71e35181db50a194eefc0/diff:/var/lib/docker/overlay2/52cb08a5a9ceda6247568dbfb77176cbf3c038ab52eb2e841c69b82408182274/diff:/var/lib/docker/overlay2/19929688b293207a8f1a1ca2e759757140f06bc3fe3b20aaca34bfd1804b0b3c/diff:/var/lib/docker/overlay2/c152c52a8251f4f680af3f9d05adb7c9d1d17a47a333df3a6727688890904aa7/diff:/var/lib/docker/overlay2/8d913aa59bd3328a3dfa0e249bebf3cacf1e595362e2675ab6675e8513a0ade4/diff:/var/lib/docker/overlay2/029fbd06dc5afc7c23c3d4e6d5ec70c6bc6fc46430e8518f813d3b1cec8f7f94/diff:/var/lib/docker/overlay2/e8a0a459f7f3fc45dc388f9a28573647f7c0b7d8938e522a84589d98a232ced1/diff:/var/lib/docker/overlay2/eaf599694ce209c8cd6cea5d89f24ed73e671e4f2b724459b12f832f301d7f49/diff:/var/lib/docker/overlay2/e79b6cd445a97a3e227c2d06283a6242fab59428e8ec9cb44bd8ec0e2379a125/diff:/var/lib/docker/overlay2/7f667e332b36b315bf68254c1d8be86634505ce22248561fcf81871fb9ca850f/diff:/var/lib/docker/overlay2/b55b9f1b1420e29dc9f89f9a3528bb8fc7855b3fe9ac86338c52924a5cb18370/diff",
"MergedDir": "/var/lib/docker/overlay2/296a21237803ead843c5d6319dcb0bb863dde308b1c4d12b99cd414ecf9044bf/merged",
"UpperDir": "/var/lib/docker/overlay2/296a21237803ead843c5d6319dcb0bb863dde308b1c4d12b99cd414ecf9044bf/diff",
"WorkDir": "/var/lib/docker/overlay2/296a21237803ead843c5d6319dcb0bb863dde308b1c4d12b99cd414ecf9044bf/work"
},
"Name": "overlay2"
},
"RootFS": {
"Type": "layers",
"Layers": [
"sha256:cdb3f9544e4c61d45da1ea44f7d92386639a052c620d1550376f22f5b46981af",
"sha256:6f8d38b0e2b61da2a2b42e8eda21d3cca2ec6b26626f4acbf31af8e2b95c4502",
"sha256:aae63f31dee9107165b24afa0a5e9ef9c9fbd079ff8a2bdd966f8c5d8736cc98",
"sha256:4801a487d51a6f24b6b405eb0684dda4efd51550226c9bd2e5260750517c6d0d",
"sha256:c0c26734fb830aea374bc08586b1a01acb90bef2a40700893c103febd104238c",
"sha256:94f8d8f5acbf9f96311f97d4c647f0023e61acec8cc6d845cb6c0fdec2d68946",
"sha256:8aeebb3964c1f91cfa4878694fc425fe5776b19d3cd32cd5242e3291ffcde370",
"sha256:532c715507aece39247e087ee8f484fb8618f84d5cf0ab791e3a70cae2d880bf",
"sha256:be2a88827be9d3aad8b49ec43a187e9973ef4c67d096e6dc97f62fa4987dc35b",
"sha256:2e37b580e7ce74fdbc2e90250a5ae2cacfb5cb8d35d35ecfdf57af6731e700bb",
"sha256:a268d42df3cd6432af565771ee7fffad6f9c925c127c8e5a981bdc71b318c483",
"sha256:5c66b70cb3f063d9cb17fbd814872538b5e338fe51ffff30a5ff2dc0bba47cd2"
]
},
"Metadata": {
"LastTagTime": "0001-01-01T00:00:00Z"
}
}
]
At this point we are ready to run the mysql db and define the volume, we will get the a volume name of mysql-db.
#[root@centos7 ~]# docker run -d --name mysql -e MYSQL_ALLOW_EMPTY_PASSWORD=true -v mysql-db:/var/lib/mysql mysql
b471373cda62106049de49fbcbfb7879d11800f9039a412805b4355480f94afb
[root@centos7 ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
b471373cda62 mysql "docker-entrypoint.sâ¦" 6 seconds ago Up 6 seconds 3306/tcp, 33060/tcp mysql
[root@centos7 ~]# docker volume ls
DRIVER VOLUME NAME
local mysql-db
We will stop the running mysql container.
[root@centos7 ~]# docker stop b471373cda62
b471373cda62
[root@centos7 ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
The volume mysql-db had remained after stop the mysql container.
[root@centos7 ~]# docker volume ls
DRIVER VOLUME NAME
local mysql-db
Rerun the mysql image and reuse the volume mysql-db.
[root@centos7 ~]# docker run -d --name mysql2 -e MYSQL_ALLOW_EMPTY_PASSWORD=true -v mysql-db:/var/lib/mysql mysql
88fb1c8f5310c3bbd0e7b956b6890e6e3a8d454594beafe0c8ca789c6aa4b195
[root@centos7 ~]# docker volume ls
DRIVER VOLUME NAME
local mysql-db
The inspection belows tells us that it's reusing the volume that was defined earlier.
[root@centos7 ~]# docker inspect mysql2
[
{
"Id": "88fb1c8f5310c3bbd0e7b956b6890e6e3a8d454594beafe0c8ca789c6aa4b195",
"Created": "2018-08-16T19:30:01.034416673Z",
"Path": "docker-entrypoint.sh",
"Args": [
"mysqld"
],
"State": {
"Status": "running",
"Running": true,
"Paused": false,
"Restarting": false,
"OOMKilled": false,
"Dead": false,
"Pid": 4037,
"ExitCode": 0,
"Error": "",
"StartedAt": "2018-08-16T19:30:01.253955009Z",
"FinishedAt": "0001-01-01T00:00:00Z"
},
"Image": "sha256:29e0ae3b69b9031ab7d7fd3024057b9441d74c8244e583cfb48697109148ca71",
"ResolvConfPath": "/var/lib/docker/containers/88fb1c8f5310c3bbd0e7b956b6890e6e3a8d454594beafe0c8ca789c6aa4b195/resolv.conf",
"HostnamePath": "/var/lib/docker/containers/88fb1c8f5310c3bbd0e7b956b6890e6e3a8d454594beafe0c8ca789c6aa4b195/hostname",
"HostsPath": "/var/lib/docker/containers/88fb1c8f5310c3bbd0e7b956b6890e6e3a8d454594beafe0c8ca789c6aa4b195/hosts",
"LogPath": "/var/lib/docker/containers/88fb1c8f5310c3bbd0e7b956b6890e6e3a8d454594beafe0c8ca789c6aa4b195/88fb1c8f5310c3bbd0e7b956b6890e6e3a8d454594beafe0c8ca789c6aa4b195-json.log",
"Name": "/mysql2",
"RestartCount": 0,
"Driver": "overlay2",
"Platform": "linux",
"MountLabel": "",
"ProcessLabel": "",
"AppArmorProfile": "",
"ExecIDs": null,
"HostConfig": {
"Binds": [
"mysql-db:/var/lib/mysql"
],
"ContainerIDFile": "",
"LogConfig": {
"Type": "json-file",
"Config": {}
},
"NetworkMode": "default",
"PortBindings": {},
"RestartPolicy": {
"Name": "no",
"MaximumRetryCount": 0
},
"AutoRemove": false,
"VolumeDriver": "",
"VolumesFrom": null,
"CapAdd": null,
"CapDrop": null,
"Dns": [],
"DnsOptions": [],
"DnsSearch": [],
"ExtraHosts": null,
"GroupAdd": null,
"IpcMode": "shareable",
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
"ReadonlyRootfs": false,
"SecurityOpt": null,
"UTSMode": "",
"UsernsMode": "",
"ShmSize": 67108864,
"Runtime": "runc",
"ConsoleSize": [
0,
0
],
"Isolation": "",
"CpuShares": 0,
"Memory": 0,
"NanoCpus": 0,
"CgroupParent": "",
"BlkioWeight": 0,
"BlkioWeightDevice": [],
"BlkioDeviceReadBps": null,
"BlkioDeviceWriteBps": null,
"BlkioDeviceReadIOps": null,
"BlkioDeviceWriteIOps": null,
"CpuPeriod": 0,
"CpuQuota": 0,
"CpuRealtimePeriod": 0,
"CpuRealtimeRuntime": 0,
"CpusetCpus": "",
"CpusetMems": "",
"Devices": [],
"DeviceCgroupRules": null,
"DiskQuota": 0,
"KernelMemory": 0,
"MemoryReservation": 0,
"MemorySwap": 0,
"MemorySwappiness": null,
"OomKillDisable": false,
"PidsLimit": 0,
"Ulimits": null,
"CpuCount": 0,
"CpuPercent": 0,
"IOMaximumIOps": 0,
"IOMaximumBandwidth": 0,
"MaskedPaths": [
"/proc/acpi",
"/proc/kcore",
"/proc/keys",
"/proc/latency_stats",
"/proc/timer_list",
"/proc/timer_stats",
"/proc/sched_debug",
"/proc/scsi",
"/sys/firmware"
],
"ReadonlyPaths": [
"/proc/asound",
"/proc/bus",
"/proc/fs",
"/proc/irq",
"/proc/sys",
"/proc/sysrq-trigger"
]
},
"GraphDriver": {
"Data": {
"LowerDir": "/var/lib/docker/overlay2/3f5be4879f576bf84adcc087c041f9a285688318a880a2f5fc062e7bd10683f9-init/diff:/var/lib/docker/overlay2/296a21237803ead843c5d6319dcb0bb863dde308b1c4d12b99cd414ecf9044bf/diff:/var/lib/docker/overlay2/8ec1e1150e83c11b58fe0a989e005bf4bb28abfa7cf71e35181db50a194eefc0/diff:/var/lib/docker/overlay2/52cb08a5a9ceda6247568dbfb77176cbf3c038ab52eb2e841c69b82408182274/diff:/var/lib/docker/overlay2/19929688b293207a8f1a1ca2e759757140f06bc3fe3b20aaca34bfd1804b0b3c/diff:/var/lib/docker/overlay2/c152c52a8251f4f680af3f9d05adb7c9d1d17a47a333df3a6727688890904aa7/diff:/var/lib/docker/overlay2/8d913aa59bd3328a3dfa0e249bebf3cacf1e595362e2675ab6675e8513a0ade4/diff:/var/lib/docker/overlay2/029fbd06dc5afc7c23c3d4e6d5ec70c6bc6fc46430e8518f813d3b1cec8f7f94/diff:/var/lib/docker/overlay2/e8a0a459f7f3fc45dc388f9a28573647f7c0b7d8938e522a84589d98a232ced1/diff:/var/lib/docker/overlay2/eaf599694ce209c8cd6cea5d89f24ed73e671e4f2b724459b12f832f301d7f49/diff:/var/lib/docker/overlay2/e79b6cd445a97a3e227c2d06283a6242fab59428e8ec9cb44bd8ec0e2379a125/diff:/var/lib/docker/overlay2/7f667e332b36b315bf68254c1d8be86634505ce22248561fcf81871fb9ca850f/diff:/var/lib/docker/overlay2/b55b9f1b1420e29dc9f89f9a3528bb8fc7855b3fe9ac86338c52924a5cb18370/diff",
"MergedDir": "/var/lib/docker/overlay2/3f5be4879f576bf84adcc087c041f9a285688318a880a2f5fc062e7bd10683f9/merged",
"UpperDir": "/var/lib/docker/overlay2/3f5be4879f576bf84adcc087c041f9a285688318a880a2f5fc062e7bd10683f9/diff",
"WorkDir": "/var/lib/docker/overlay2/3f5be4879f576bf84adcc087c041f9a285688318a880a2f5fc062e7bd10683f9/work"
},
"Name": "overlay2"
},
"Mounts": [
{
"Type": "volume",
"Name": "mysql-db",
"Source": "/var/lib/docker/volumes/mysql-db/_data",
"Destination": "/var/lib/mysql",
"Driver": "local",
"Mode": "z",
"RW": true,
"Propagation": ""
}
],
"Config": {
"Hostname": "88fb1c8f5310",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": false,
"AttachStderr": false,
"ExposedPorts": {
"3306/tcp": {},
"33060/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"MYSQL_ALLOW_EMPTY_PASSWORD=true",
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"GOSU_VERSION=1.7",
"MYSQL_MAJOR=8.0",
"MYSQL_VERSION=8.0.12-1debian9"
],
"Cmd": [
"mysqld"
],
"ArgsEscaped": true,
"Image": "mysql",
"Volumes": {
"/var/lib/mysql": {}
},
"WorkingDir": "",
"Entrypoint": [
"docker-entrypoint.sh"
],
"OnBuild": null,
"Labels": {}
},
"NetworkSettings": {
"Bridge": "",
"SandboxID": "c7dc83f2b2018f907c4e19853e71f0b359a28843b2ba0b02420f933b82febc80",
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"Ports": {
"3306/tcp": null,
"33060/tcp": null
},
"SandboxKey": "/var/run/docker/netns/c7dc83f2b201",
"SecondaryIPAddresses": null,
"SecondaryIPv6Addresses": null,
"EndpointID": "db5dcd68b5021fcf2800e331a962c737a22dd7bebc5f9454fa83ccf5ac459f14",
"Gateway": "172.17.0.1",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"IPAddress": "172.17.0.2",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"MacAddress": "02:42:ac:11:00:02",
"Networks": {
"bridge": {
"IPAMConfig": null,
"Links": null,
"Aliases": null,
"NetworkID": "eb8d733bf91d848e1874fdd908136b911fcc42c8ec4f99bba203a87cfb2781ae",
"EndpointID": "db5dcd68b5021fcf2800e331a962c737a22dd7bebc5f9454fa83ccf5ac459f14",
"Gateway": "172.17.0.1",
"IPAddress": "172.17.0.2",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"MacAddress": "02:42:ac:11:00:02",
"DriverOpts": null
}
}
}
}
]
Recent comments