# 创建docker-compose.yml文件
$ cat > docker-compose.yml << 'EOF'
version: '3.8'

services:
  web:
    image: nginx:latest
    ports:
      - "8080:80"
    volumes:
      - ./nginx.conf:/etc/nginx/nginx.conf:ro
      - ./html:/usr/share/nginx/html:ro
    depends_on:
      - app

  app:
    image: fgedu/myapp:latest
    ports:
      - "8000:8000"
    environment:
      - DATABASE_URL=mysql://fgedu:SecurePassword123!@db:3306/fgedudb
    depends_on:
      - db

  db:
    image: mysql:8.0
    environment:
      - MYSQL_ROOT_PASSWORD=SecurePassword123!
      - MYSQL_DATABASE=fgedudb
      - MYSQL_USER=fgedu
      - MYSQL_PASSWORD=SecurePassword123!
    volumes:
      - mysql-data:/var/lib/mysql

volumes:
  mysql-data:
EOF

# 创建nginx.conf文件
$ cat > nginx.conf << 'EOF'
events {
    worker_connections 1024;
}

http {
    include /etc/nginx/mime.types;
    default_type application/octet-stream;

    server {
        listen 80;
        server_name localhost;

        location / {
            proxy_pass http://app:8000;
            proxy_set_header Host $host;
            proxy_set_header X-Real-IP $remote_addr;
            proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
            proxy_set_header X-Forwarded-Proto $scheme;
        }
    }
}
EOF

# 创建html目录
$ mkdir -p html
$ echo "
Welcome to Docker Desktop
" > html/index.html

# 启动应用
$ docker-compose up -d

Creating network "docker-desktop_default" with the default driver
Creating volume "docker-desktop_mysql-data" with default driver
Pulling db (mysql:8.0)...
Pulling app (fgedu/myapp:latest)...
Pulling web (nginx:latest)...
Creating docker-desktop_db_1 ... done
Creating docker-desktop_app_1 ... done
Creating docker-desktop_web_1 ... done

# 查看服务状态
$ docker-compose ps

      Name                    Command               State           Ports
--------------------------------------------------------------------------------
docker-desktop_app_1    python app.py                Up      0.0.0.0:8000->8000/tcp
docker-desktop_db_1     docker-entrypoint.sh mysqld   Up      3306/tcp, 33060/tcp
docker-desktop_web_1    nginx -g daemon off;          Up      0.0.0.0:8080->80/tcp

学习交流加群风哥QQ113257174

4.3 Docker数据库与Docker Desktop集成实战

案例：在Docker Desktop中运行MySQL数据库

# 运行MySQL容器
$ docker run --name mysql-db \
    -p 3306:3306 \
    -e MYSQL_ROOT_PASSWORD=SecurePassword123! \
    -e MYSQL_DATABASE=fgedudb \
    -e MYSQL_USER=fgedu \
    -e MYSQL_PASSWORD=SecurePassword123! \
    -v /Docker/fgdata/mysql:/var/lib/mysql \
    -d \
    mysql:8.0

1234567890abcdef...

# 连接MySQL数据库
$ docker exec -it mysql-db mysql -u fgedu -p

Enter password: SecurePassword123!
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.34 MySQL Community Server - GPL
...
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| fgedudb            |
| information_schema |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

# 创建表
mysql> CREATE TABLE fgedu_users (
    -> id INT AUTO_INCREMENT PRIMARY KEY,
    -> name VARCHAR(50),
    -> email VARCHAR(100)
    -> );

Query OK, 0 rows affected (0.01 sec)

# 插入数据
mysql> INSERT INTO fgedu_users (name, email) VALUES
    -> ('张三', 'zhangsan@example.com'),
    -> ('李四', 'lisi@example.com'),
    -> ('王五', 'wangwu@example.com');

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

# 查询数据
mysql> SELECT * FROM fgedu_users;

+----+--------+----------------------+
| id | name   | email                |
+----+--------+----------------------+
|  1 | 张三   | zhangsan@example.com |
|  2 | 李四   | lisi@example.com     |
|  3 | 王五   | wangwu@example.com   |
+----+--------+----------------------+
3 rows in set (0.00 sec)