Implementing a backup and recovery strategy for PHP applications using Docker Compose, Nginx, and MariaDB

<p><img src="/static/imghw/default1.png" data-src="https://img.php.cn/upload/article/000/465/014/169707557237628.jpg" class="lazy" alt="使用Docker Compose、Nginx和MariaDB实现PHP应用程序的备份和恢复策略"></p> <p>Implementing backup and recovery strategies for PHP applications using Docker Compose, Nginx and MariaDB</p> <p>Introduction: <br>In modern software development, backup and recovery strategies It's a crucial part. When designing a backup and recovery strategy for PHP applications, we can use a combination of Docker Compose, Nginx, and MariaDB to achieve a reliable and flexible solution. This article will provide detailed steps and code examples to help readers get started quickly. </p> <p>1. Create a Docker Compose file</p> <ol><li>First, we need to create a file named <code>docker-compose.yml</code> and define our service in it . The following is the basic structure of a sample file: </li></ol><div class="code" style="position:relative; padding:0px; margin:0px;"><pre class='brush:php;toolbar:false;'>version: '3' services: app: build: context: ./app dockerfile: Dockerfile volumes: - ./app:/var/www/html depends_on: - db restart: always db: image: mariadb ports: - 3306:3306 restart: always web: image: nginx ports: - 80:80 volumes: - ./nginx:/etc/nginx/conf.d depends_on: - app restart: always</pre><div class="contentsignin">Copy after login</div></div><ol start="2"><li>In the above example, we have three services defined: <code>app</code>, <code>db</code> and <code>web</code>. Among them, the <code>app</code> service is the container of the PHP application, the <code>db</code> service is the container of the MariaDB database, and the <code>web</code> service is the container of the Nginx server. </li><li>We also use the <code>volumes</code> attribute to mount the data volume. In the example, we mount the <code>./app</code> directory to the <code>/var/www/html</code> directory of the <code>app</code> service to persistently store application data. . </li></ol><p>2. Nginx backup strategy</p><ol><li>In the <code>docker-compose.yml</code> file, we define a file named <code>web</code> Nginx service. In order to implement the backup strategy, we will use Nginx’s <code>ngx_http_upstream_module</code> module to configure load balancing and reverse proxy. The following is a basic Nginx configuration example: </li></ol><div class="code" style="position:relative; padding:0px; margin:0px;"><pre class='brush:php;toolbar:false;'>http { upstream backend { server app:80; } server { listen 80; server_name localhost; location / { proxy_pass http://backend; proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; } } }</pre><div class="contentsignin">Copy after login</div></div><ol start="2"><li>In the above example, we used the <code>upstream</code> directive to define a file named <code>backend</code>'s backend service, and takes the address and port of the <code>app</code> service as its parameters. Next, we use the <code>proxy_pass</code> directive in the <code>server</code> block to set up a reverse proxy and forward the request to the <code>backend</code> service. </li><li>After the configuration is completed, we can use the <code>docker-compose up</code> command to start all services. At this time, Nginx will listen on port 80 of the host and forward the request to the <code>app</code> service. </li></ol><p>3. MariaDB backup and recovery strategy</p><ol><li>In the <code>docker-compose.yml</code> file, we define a file named <code> MariaDB service of db</code>. In order to implement the backup and recovery strategy, we will use MariaDB's <code>mysqldump</code> tool to implement database backup and recovery. The following is a basic backup script example: </li></ol><div class="code" style="position:relative; padding:0px; margin:0px;"><pre class='brush:php;toolbar:false;'>#!/bin/bash backup_path="/path/to/backup" date=$(date +%Y%m%d%H%M%S) db_container=$(docker ps --filter "name=db" --format "{{.ID}}") docker exec -it $db_container mysqldump -u root -p<password> --all-databases > $backup_path/db_backup_$date.sql</pre><div class="contentsignin">Copy after login</div></div><ol start="2"><li>In the above example, we used the <code>mysqldump</code> command to export the backup of the database and save it to the specified under the backup path. We also used the <code>date</code> command to generate a timestamp so that each backup has a unique filename. Finally, we execute the backup command in the <code>db</code> container through the <code>docker exec</code> command. </li><li>To restore the database, we can use the following command: </li></ol><div class="code" style="position:relative; padding:0px; margin:0px;"><pre class='brush:php;toolbar:false;'>docker exec -i $db_container mysql -u root -p<password> < $backup_path/db_backup_$date.sql</pre><div class="contentsignin">Copy after login</div></div><ol start="4"><li>In the above command, we used the <code>mysql</code> command to execute the backup file to restore the database. Through the <code><</code> symbol, we import the contents of the backup file into the <code>mysql</code> command. </li></ol> <p>Conclusion: <br>This article introduces how to use Docker Compose, Nginx and MariaDB to implement a backup and recovery strategy for PHP applications. We demonstrate Nginx's load balancing and reverse proxy configuration and MariaDB's backup and recovery scripts with sample code. Through these steps, readers should be able to get started quickly and apply it to their own PHP applications in actual projects. Hope this article can be helpful to readers. </p>

The above is the detailed content of Implementing a backup and recovery strategy for PHP applications using Docker Compose, Nginx, and MariaDB. For more information, please follow other related articles on the PHP Chinese website!