andrefernandes/docker-mysql repository overview

⁠docker-mysql

CentOS 7 + Oracle MySQL Community

This is a MySQL image meant for general use. This work is heavily based on the official MySQL image, but uses a base CentOS image instead of Ubuntu.

Original work can be found at "https://github.com/docker-library/mysql⁠".

CentOS and RHEL-based images might be a better fit for RHEL shops.

⁠Useful scripts

• build.sh : builds the image locally (docker build);
• runmysqld.sh : convenient way to start MySQL on a named daemon container (fast-food, auto-destroy);
• runbash.sh : convenient way to run commands on a new container (fast-food, auto-destroy) or even to just open a bash shell to play.

⁠How to use this image

⁠start a MySQL instance

docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=mysecretpassword -d andrefernandes/docker-mysql

This image includes EXPOSE 6379 (the mysql port), so standard container linking will make it automatically available to the linked containers (as the following examples illustrate).

⁠start with persistent storage

Mounting the container VOLUME "/var/lib/mysql" on the "/opt/mysql-data" host folder:

docker run --name some-mysql -v /opt/mysql-data:/var/lib/mysql -d andrefernandes/docker-mysql

Persistent data for VOLUME "/var/lib/mysql" can also be stored in a volume container, which can be used with --volumes-from some-volume-container:

docker run --name some-mysql-data -d -v /var/lib/mysql busybox echo "Data volume container for MySQL"
docker run -d --volumes-from some-mysql-data --name some-mysql andrefernandes/docker-mysql

Using persistent data is an obvious need. You must decide whether to use host-mounted folders or volume containers. It it your call.

⁠connect to it from an application

docker run --name some-app --link some-mysql:mysql -t -i --rm application-that-uses-mysql

The above command starts a named container application that sees "some-mysql" container with a "mysql" hostname. The exposed "some-mysql" ports are available to the application.

⁠… or play with mysql client

# starts mysql with our convenient script (creates named "mysql" container)
./runmysqld.sh
# now start ANOTHER container, linked to "mysql", to run mysql client
# yes, using the same image, why not?
docker run -it --link mysql:mysql --rm andrefernandes/docker-mysql mysql -h mysql -ppassword