# pixel-guru/wordpress-multi-instance-with-mysql-replication architecture

> Architecture diagram of the GitHub repository pixel-guru/wordpress-multi-instance-with-mysql-replication, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/pixel-guru/wordpress-multi-instance-with-mysql-replication
- Repository: https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication

## Overview

A Docker Compose stack for hosting multiple isolated WordPress sites with dedicated MySQL databases and replication. The documented user path is HTTP traffic through Traefik to WordPress, which uses its local MySQL database; that database replicates to a MySQL replica. Volumes preserve site files and database data. The only implementation file is the Compose YAML; relationships below are based on README documentation, not inspected configuration excerpts.

Main entry points: [`muti_wordpress_em_docker.yaml`](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml) (WordPress instance)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingress["Ingress and routing"]
  node_traefik["Traefik"]
  node_bridge["Traefik bridge"]
end

subgraph group_site["WordPress site"]
  node_wp["WordPress instance"]
  node_site_network["Site network"]
  node_wp_volume[("WordPress files")]
end

subgraph group_data["Database and persistence"]
  node_mysql[("Site MySQL")]
  node_replica[("MySQL replica")]
  node_mysql_volume[("MySQL data")]
end

node_visitor(("Site visitor"))

node_visitor -->|"sends requests"| node_traefik
node_traefik -->|"routes requests"| node_wp
node_wp -->|"uses database"| node_mysql
node_mysql -->|"replicates data"| node_replica
node_wp -->|"communicates on"| node_site_network
node_mysql -->|"communicates on"| node_site_network
node_wp -->|"connects through"| node_bridge
node_mysql -->|"connects through"| node_bridge
node_replica -->|"replicates through"| node_bridge
node_wp -->|"persists site files"| node_wp_volume
node_mysql -->|"persists database"| node_mysql_volume

click node_traefik "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"
click node_wp "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"
click node_site_network "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"
click node_bridge "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"
click node_mysql "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"
click node_replica "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"
click node_wp_volume "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"
click node_mysql_volume "https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_traefik,node_bridge toneBlue
class node_wp,node_site_network,node_wp_volume toneAmber
class node_mysql,node_replica,node_mysql_volume toneMint
class node_visitor toneIndigo
```

## Components

### Ingress and routing

- [Traefik](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`
- [Traefik bridge](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`

### WordPress site

- [WordPress instance](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`
- [Site network](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`
- [WordPress files](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`

### Database and persistence

- [Site MySQL](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`
- [MySQL replica](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`
- [MySQL data](https://github.com/pixel-guru/wordpress-multi-instance-with-mysql-replication/blob/main/muti_wordpress_em_docker.yaml): `muti_wordpress_em_docker.yaml`

### Other components

- **Site visitor**

## Connections

- Site visitor → Traefik: sends requests (evidence: `README.md`)
- Traefik → WordPress instance: routes requests (evidence: `README.md`)
- WordPress instance → Site MySQL: uses database (evidence: `README.md`)
- Site MySQL → MySQL replica: replicates data (evidence: `README.md`)
- WordPress instance → Site network: communicates on (evidence: `README.md`)
- Site MySQL → Site network: communicates on (evidence: `README.md`)
- WordPress instance → Traefik bridge: connects through (evidence: `README.md`)
- Site MySQL → Traefik bridge: connects through (evidence: `README.md`)
- MySQL replica → Traefik bridge: replicates through (evidence: `README.md`)
- WordPress instance → WordPress files: persists site files (evidence: `README.md`)
- Site MySQL → MySQL data: persists database (evidence: `README.md`)
