Installieren Sie Wordpress mit Docker und MySQL 8

Normalerweise verwende ich Docker, um Anwendungen in meiner Entwicklungsumgebung zu erstellen, insbesondere wenn ich einige Experimente oder Tests durchführen muss. Da das Ausführen von WordPress normalerweise die Installation eines Webservers, von PHP und eines Datenbankstapels umfasst, kann dies zeitaufwändig sein. Mit Tools wie Docker und Docker Compose können Sie den Einrichtungsprozess vereinfachen. Docker ist eine Containerisierungsplattform, mit der „Container“ erstellt und ausgeführt werden können.

Stellen Sie sich einen Docker-Container wie eine „leichte virtuelle Maschine“ vor. Darüber hinaus ist es mit Docker Compose möglich, eine beliebige Anzahl von Docker-Containern gleichzeitig auszuführen, miteinander zu kommunizieren und die Konfiguration in einer einfachen YAML-Datei zu verwalten.

In this post I’m going to show you some basics around building a multi-container WordPress stack application using Docker compose.

Dieser Stapel besteht aus 3 Docker-Containern:

WordPress 5.4.1 with php 7.4.
MySQL 8.0. as database
NGINX as front end web server.

Table of Contents

Voraussetzungen:

Installieren Sie Docker in Ihrem System.

Ich habe Ubuntu in WSL2 für Windows 10 im Insider-Programm verwendet. Darüber hinaus können Sie Docker in jedem Betriebssystem oder jeder Linux-Distribution installieren.

It’s beyond the scope of this post to explain how to install Docker or WLS2 for Windows 10. You can find more information at https://docs.docker.com/get-docker/ and https://docs.microsoft.com/en-us/windows/wsl/install-win10

Docker comes along with WSL2 backend installation as well. More information at https://docs.docker.com/docker-for-windows/wsl/.

Alle Konfigurationen definieren:

Wir beginnen ein Arbeitsverzeichnis zu erstellen:

mkdir wordpress && cd wordpress

Next we need to create two subdirectories to store the configuration files for the database and the webserver.

mkdir conf && mkdir nginx-conf

Define configuration for Nginx

Create a new file with nano or your favorite editor:

nano nginx-conf/nginx.conf

Paste the following code into the file.

# Upstream to abstract backend connection(s) for php
upstream php {
        ## server unix:/tmp/php-cgi.socket;
        ##name of wordpress container as it appears in docker compose config file
        server wordpress:9000;
}
server {
        ## Your website name goes here.
        server_name localhost;
        ## Your only path reference.
        root /var/www/html;
        ## This should be in your http block and if it is, it's not needed here.
        index index.php;
		
	client_max_body_size 100M;

        location = /favicon.ico {
                log_not_found off;
                access_log off;
        }

        location = /robots.txt {
                allow all;
                log_not_found off;
                access_log off;
        }

        location / {
                # This is cool because no php is touched for static content.
                # include the "?$args" part so non-default permalinks doesn't break when using query string
                try_files $uri $uri/ /index.php?$args;
        }

        location ~ \.php$ {
                #NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini
                include fastcgi_params;
                fastcgi_intercept_errors on;
				fastcgi_pass php;
                #The following parameter can be also included in fastcgi_params file
                fastcgi_param  SCRIPT_FILENAME $document_root$fastcgi_script_name;
	
        }
        location ~* \.(js|css|png|jpg|jpeg|gif|ico|woff|woff2)$ {
                expires max;
                log_not_found off;
        }
}

Directives:

I included the directive client_max_body_size to prevent problems later on in case you need to upload big files in WordPress.

Define PHP Configuration

I added a uploads.ini configuration to change some php runtine configuration settings in order to increase performance and upload file size.

nano uploads.ini

Paste the following properties:

file_uploads = On
memory_limit = 256M
upload_max_filesize = 64M
post_max_size = 64M
max_execution_time = 600

Define configuration for Mysql 8

I have found some posts about issues related to Mysql 8, WordPress and docker installations.¹

For this reason I configured MySQL 8 to accept connections from any IP address.

Create configuration file for MySQL 8.0.

nano conf/config-file.conf

Paste the following code into the file:

[mysqld]
bind-address	            = 0.0.0.0

Define Environment Variables

MySQL database and WordPresss application containers will need to access certain environment variables at runtime.

We set these variables in an .env file:

nano .env

The values that we will set in this file include a password for our MySQL root user, and a username and password that WordPress will use to access the database.

MYSQL_DATABASE=wordpress
MYSQL_ROOT_PASSWORD=somewordpress
MYSQL_USER=wordpress
MYSQL_PASSWORD=wordpress

Seeting up Docker Compose

The docker-compose.yml file contains the service definitions in this setup.

Open the docker-compose.yml file:

nano docker-compose.yml

Add the follogin code to Docker Compose file:

version: '3.1'

services:
  db:
    image: mysql:8.0
    container_name: db
    restart: unless-stopped
    env_file: .env
    volumes: 
      - dbdata:/var/lib/mysql
      - ./conf:/etc/mysql/conf.d
    command: '--default-authentication-plugin=mysql_native_password'
    networks:
      - app-network
  wordpress:
    depends_on: 
      - db
    image: wordpress:php7.4-fpm-alpine
    container_name: wordpress
    restart: unless-stopped
    env_file: .env
    environment:
      - WORDPRESS_DB_HOST=db:3306
      - WORDPRESS_DB_USER=wordpress
      - WORDPRESS_DB_PASSWORD=wordpress
      - WORDPRESS_DB_NAME=wordpress
      - WORDPRESS_TABLE_PREFIX=wp_
    volumes:
      - wordpress:/var/www/html
      - ./uploads.ini:/usr/local/etc/php/conf.d/uploads.ini
     networks:
      - app-network
  webserver:
    depends_on:
      - wordpress
    image: nginx:1.15.12-alpine
    container_name: webserver
    restart: unless-stopped
    ports:
      - "80:80"
    volumes:
      - wordpress:/var/www/html
      - ./nginx-conf:/etc/nginx/conf.d
    networks:
      - app-network
volumes:
    wordpress:
    dbdata:
networks:
    app-network:
      driver: bridge

Create the containers with docker-compose up and the -d flag, which will run the db, wordpress, and webserver containers in the background:

docker-compose up -d

You will see output confirming that your services have been created.

You can check the status of your services using ps.

docker-compose ps

If everything was successful, your db, wordpress and webserver services will be Up.

Now you can complete your WordPress installation through the web interface. In your web browser, you can reach your site via http://localhost

Finish WordPress installation with admin settings.

Once logged in, you will have access to the WordPress administration dashboard.

Fix WordPress Docker loopback errors

You need to change WordPress address URL and Site Address if you want to fix the WordPress Docker Compose loopback error that affects cron Jobs and prevents internal file modifications ²

Use following domain names: http://docker.for.win.localhost (windows) or http://docker.for.mac.localhost (mac).

After that you will reach your WordPress server installation via http://docker.for.win.localhost/ (windows) or http://docker.for.mac.localhost (mac)

Conclusion

We covered how to create a wordpress installation with mysql 8 using docker.

Hope you enjoyed the article!

You can give me support if you find this content is usefull!

Buy Me a Coffee

Installieren Sie Wordpress mit Docker und MySQL 8