Docker case analysis: Building a MySQL database service

Use the official MySQL image to build the database service. The current latest version corresponds to version 8.0.19. To prevent compatibility issues in the following steps after the official version is updated, you can specify version 8.0.19 when using the image.

1 Create configuration and data directories

Create a directory on this machine to store MySQL configuration and data.

• Configuration file directory: ~/docker/conf/mysql
• Data file directory: ~/docker/data/mysql

docker pull mysql

3 Copy the configuration file from the image to the host

The internal configuration files of the image are stored in the /etc/mysql directory. A temporary container is created to copy the configuration file directory to the local ~/docker/conf/ directory.

# Create a container named mysql docker run --name mysql -e MYSQL_ROOT_PASSWORD=crane -d mysql

# Copy the configuration file in the docker container to the local ~/docker/conf/mysql directory docker cp mysql:/etc/mysql /Users/crane/docker/conf/

# Stop and delete the temporary container docker stop mysql
docker rm mysql

4 Create and run the mysql container

Mount the host configuration and data file directories into the Docker container and execute the following commands in the terminal:

# ~/docker/conf/mysql contains the mysql configuration file # ~/docker/data/mysql contains the mysql data file # The local port 3306 and 33060 are mapped to the 3306 and 33060 ports in docker respectively # The database root password is crane
# -d Run docker in the background
docker run --name mysql -v ~/docker/conf/mysql:/etc/mysql/conf.d -v ~/docker/data/mysql:/var/lib/mysql -p 3306:3306 -p 33060:33060 -e MYSQL_ROOT_PASSWORD=crane -d mysql

5 Host connects to database

5.1 Terminal command connection

After the container is started successfully in the previous step, execute the following command in the host terminal to connect to the database

# Enter the following command and press Enter, enter the database password crane
mysql -uroot -p --protocol=tcp

The above command specifies to use TCP to connect to the database. If you do not add --protocol=tcp, the default connection will be socket, and the following error will be reported

5.2 Database tool connection

You can also connect using database tools, such as DataGrip, to perform related data operations.

6 View mysql log

During the normal operation of the container, you can use the following command to view the log

docker logs -f mysql

Use externally mounted configurations and data when building services to facilitate data backup and migration. If you start a container on another host using the same version of the Docker image and mount the backed-up configuration and data, you will get exactly the same database configuration and data.

Refer to the official MySQL image

The above is my personal experience. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.