Home Operation and Maintenance Docker How to do database mirroring with docker

How to do database mirroring with docker

Apr 26, 2023 am 10:27 AM

Docker is currently the most popular containerization technology, which can package applications and their dependencies into an independent container and run in different environments. Databases are a core component of applications, and running databases in Docker is a very common scenario because it provides a convenient, safe, and repeatable way to test, deploy, and scale database applications.

So, how to create a database image in Docker? The steps to create a MySQL database mirror are described in detail below.

1. Download the official MySQL image

You can download the official MySQL image from Docker Hub. We can use the following command to download the MySQL image from Docker Hub:

docker pull mysql/mysql-server
Copy after login

2. Create a customized MySQL image

Although we can use the official MySQL image directly, it may not meet our needs, such as configuration files, initialization scripts, data backup, etc. Therefore, we must create a customized image based on the official image to meet our needs.

1. Create a Dockerfile

Dockerfile is a text file that contains a series of instructions to build a Docker image. We use the MySQL official image as the basis, and then create a customized image by adding configuration files, initialization scripts, data backup, etc.

In this example, we create a Dockerfile file with the following content:

FROM mysql/mysql-server

# 安装telnet和net-tools
RUN yum update && yum install -y telnet net-tools

# 添加自定义配置文件
ADD my.cnf /etc/mysql/my.cnf

# 添加初始化脚本
ADD init.sql /docker-entrypoint-initdb.d/

# 添加数据备份
ADD backup.sql /tmp/backup.sql
Copy after login

The explanation of the above Dockerfile file is as follows:

  • FROM mysql/mysql-server : Use the MySQL official image as the base image.
  • RUN yum update && yum install -y telnet net-tools: Install telnet and net-tools tools.
  • ADD my.cnf /etc/mysql/my.cnf: Add the custom configuration file my.cnf to the /etc/mysql/ directory.
  • ADD init.sql /docker-entrypoint-initdb.d/: Add the initialization script init.sql to the /docker-entrypoint-initdb.d/ directory.
  • ADD backup.sql /tmp/backup.sql: Add data backup backup.sql to the /tmp/ directory.

2. Build the image

In this example, we have prepared Dockerfile files, custom configuration files, initialization scripts, data backup and other resources. Next, you need to execute the following command in the directory where the Dockerfile file is located to build the image:

docker build -t my-mysql:latest .
Copy after login

Among them, -t is used to name the image, and :latest means to use the latest version.

3. Run the MySQL container

Now that we have successfully created a custom MySQL image, we will run the image in the container and assign a name to the container:

docker run -d -p 3306:3306 --name my-mysql -v /data/mysql:/var/lib/mysql my-mysql
Copy after login

Among them, -d means running the container in the background, -p maps the container's 3306 port to the host's 3306 port, -v maps the host's /data/mysql directory to the container's /var/lib/mysql directory, my -mysql indicates the name of the container.

Now we can use the MySQL client tool to connect to the MySQL container and test that it is running properly.

mysql -h 127.0.0.1 -P 3306 -u root -p
Copy after login

4. Conclusion

Through this process, we have learned how to create a custom MySQL image in Docker and run the image. This makes it easier to test, deploy, and scale database applications. In actual projects, we can add more custom configurations and initialization scripts as needed, as well as backup and recovery data and other functions.

The above is the detailed content of How to do database mirroring with docker. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to exit the container by docker How to exit the container by docker Apr 15, 2025 pm 12:15 PM

Four ways to exit Docker container: Use Ctrl D in the container terminal Enter exit command in the container terminal Use docker stop <container_name> Command Use docker kill <container_name> command in the host terminal (force exit)

How to copy files in docker to outside How to copy files in docker to outside Apr 15, 2025 pm 12:12 PM

Methods for copying files to external hosts in Docker: Use the docker cp command: Execute docker cp [Options] <Container Path> <Host Path>. Using data volumes: Create a directory on the host, and use the -v parameter to mount the directory into the container when creating the container to achieve bidirectional file synchronization.

Docker Interview Questions: Ace Your DevOps Engineering Interview Docker Interview Questions: Ace Your DevOps Engineering Interview Apr 06, 2025 am 12:01 AM

Docker is a must-have skill for DevOps engineers. 1.Docker is an open source containerized platform that achieves isolation and portability by packaging applications and their dependencies into containers. 2. Docker works with namespaces, control groups and federated file systems. 3. Basic usage includes creating, running and managing containers. 4. Advanced usage includes using DockerCompose to manage multi-container applications. 5. Common errors include container failure, port mapping problems, and data persistence problems. Debugging skills include viewing logs, entering containers, and viewing detailed information. 6. Performance optimization and best practices include image optimization, resource constraints, network optimization and best practices for using Dockerfile.

Docker Volumes: Managing Persistent Data in Containers Docker Volumes: Managing Persistent Data in Containers Apr 04, 2025 am 12:19 AM

DockerVolumes ensures that data remains safe when containers are restarted, deleted, or migrated. 1. Create Volume: dockervolumecreatemydata. 2. Run the container and mount Volume: dockerrun-it-vmydata:/app/dataubuntubash. 3. Advanced usage includes data sharing and backup.

How to update the image of docker How to update the image of docker Apr 15, 2025 pm 12:03 PM

The steps to update a Docker image are as follows: Pull the latest image tag New image Delete the old image for a specific tag (optional) Restart the container (if needed)

How to check the name of the docker container How to check the name of the docker container Apr 15, 2025 pm 12:21 PM

You can query the Docker container name by following the steps: List all containers (docker ps). Filter the container list (using the grep command). Gets the container name (located in the "NAMES" column).

How to restart docker How to restart docker Apr 15, 2025 pm 12:06 PM

How to restart the Docker container: get the container ID (docker ps); stop the container (docker stop <container_id>); start the container (docker start <container_id>); verify that the restart is successful (docker ps). Other methods: Docker Compose (docker-compose restart) or Docker API (see Docker documentation).

How to start mysql by docker How to start mysql by docker Apr 15, 2025 pm 12:09 PM

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

See all articles