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
                }
            }
        }
    }
]