Analysis of the configuration process of installing mariadb based on docker

1. Installation Search the mariadb version to be installed through dockerhub. Execute docker pull to pull the image to the local computer.

Start mariadb

docker run --name mariadb-prod -p 3306:3306 -e MYSQL_ROOT_PASSWORD=QBdata@1017 -v /data/software_docker/mariadb_test/data:/var/lib/mysql -d mariadb:10.5.6

• --name starts the container and sets the container name to mariadb-prod
• -p sets the container's port 3306 to map to the host's port 3306
• -e MYSQL_ROOT_PASSWORD sets the environment variable database root user password to the password of the database root user.
• -v sets the container directory /var/lib/mysql to map to the local directory /data/software_docker/mariadb_prod/data
• -d Run the mariadb container in the background and return the container id

Is the installation successful?

Check if the container is running

docker ps -a

Modify the container to start automatically

docker container update --restart=always container id

2. Modify the table name to be case insensitive

Check the container ID through docker ps, and then enter the container with the following command

docker exec -it 5344dfbfc7bc /bin/bash

Enter the /etc/mysql directory and modify the my.cfg file

#Install vimapt-get updateapt-get install vim#Modify my.cfg, add lower_case_table_name=1vim my.cnf

Exit the container and restart the container via docker stop/rm/run

Attachment: Modify the default directory of docker

https://ld246.com/article/1566017283738

For new versions of Docker (greater than v17.05.0), modify the installation (storage) directory: modify (create) /etc/docker/daemon.json and specify the value of the data-root parameter

Proceed as follows:

vim /etc/docker/daemon.json

join in

{
  "data-root": "/store/software/docker",
  "storage-driver": "overlay2" # This is the default setting for Docker, you don't need to add it here}

Then restart the docker service

systemctl restart docker

After completing the migration using any of the above methods and confirming that Docker can work properly, delete the backed-up original directory data:

rm -rf /var/lib/docker.bak

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.