Public | Automated Build

Last pushed: 3 years ago
Short Description
Short description is empty for this repo.
Full Description

ctlc-docker-mysql

Base docker image to run a MySQL database server

Usage

To create the image ctlc/mysql, execute the following command on the ctlc-mysql folder:

sudo docker build -t ctlc/mysql .

The first time that you run your container, a new user admin with all privileges
will be created in MySQL with a random password. To get the password, check the logs
of the container by running:

sudo docker logs $CONTAINER_ID

You will see an output like the following:

========================================================================
You can now connect to this MySQL Server using:

    mysql -uadmin -p47nnf4FweaKu -h<host> -P<port>

Please remember to change the above password as soon as possible!
MySQL user 'root' has no password but only allows local connections
========================================================================

In this case, 47nnf4FweaKu is the password allocated to the admin user. To get
the allocated port to MySQL, execute:

sudo docker port $CONTAINER_ID 3306

It will print the allocated port (like 4751). You can then connect to MySQL:

 mysql -uadmin -p47nnf4FweaKu -h127.0.0.1 -P4751

Remember that the root user has no password but it's only accesible from within the container.

Mounting the database file volume

In order to persist the database data, you can mount a local folder from the host on the container to store the database files. To do so:

$ID=$(sudo docker run -d -v /path/in/host:/var/lib/mysql ctlc/mysql-php /bin/bash -c "/usr/bin/mysql_install_db")

This will mount the local folder /path/in/host inside the docker in /var/lib/mysql (where MySQL will store the database files by default). mysql_install_db creates the initial database structure.

Remember that this will mean that your host must have /path/in/host available when you run your docker image!

Initializing the server

To set your initial root password, run:

ID=$(sudo docker run -d ctlc/mysql /bin/bash -c "/set_root_pw.sh <newpassword>")

Where <newpassword> is the password to be set for the root account. It will store the new container ID (like d35bf1374e88) in $ID. To create an image from that, execute:

sudo docker commit $ID ctlc/my-mysql-server

To import a SQL backup which is stored for example in the folder /tmp/sqlbackup in the host, run the following:

ID=$(sudo docker run -d -v /tmp/sqlbackup:/tmp ctlc/my-mysql-server /bin/bash -c "/import_sql.sh <rootpassword> /tmp/<dump.sql>")

Where <rootpassword> is the root password set earlier and <dump.sql> is the name of the SQL file to be imported.

You can now push your changes to the registry:

sudo docker push ctlc/my-mysql-server

Migrating an existing MySQL Server

In order to migrate your current MySQL server to a docker, perform the following commands from your current server:

To dump your databases structure:

mysqldump -u<user> -p --opt -d -B <database(s)> > dbserver_schema.sql

To dump your database data:

mysqldump -u<user> -p --quick --single-transaction -t -n -B <database(s) > dbserver_data.sql

Running the MySQL server

Run the /run.sh script to start MySQL (via supervisor):

ID=$(sudo docker run -d -p 3306 ctlc/my-mysql-server /run.sh)

It will store the new container ID (like d35bf1374e88) in $ID. Get the allocated external port:

sudo docker port $ID 3306

It will print the allocated port (like 4751). Test your deployment:

mysql -uroot -p -h127.0.0.1 -P4751

Done!

Docker Pull Command
Owner
ctlc