> For the complete documentation index, see [llms.txt](https://docs.zus.network/zus-devops/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.zus.network/zus-devops/wordpress-and-mysql.md).

# WordPress & MySQL

https\://blog.zus.network/wp-admin - WordPress & MySQL both are deployed over Hetzner Robot Cloud server.

Docker-compose simplifies WordPress and MySQL deployment by coordinating containers for both services. Docker-compose.yml sets up WordPress and MySQL containers by specifying settings, linkages, and networks. This effective deployment strategy improves portability, scalability, and administrative simplicity, resulting in a cohesive and optimized environment for WordPress-powered websites.

**Pre-requisites -** 

1. **Install Docker and Docker Compose**

Install Docker Engine on Ubuntu official doc - <https://docs.docker.com/engine/install/ubuntu/>

Install Docker Compose on Ubuntu official doc - <https://docs.docker.com/compose/install/>

```shellscript
sudo apt-get update
sudo apt-get install ca-certificates curl gnupg lsb-release -y

sudo mkdir -p /etc/apt/keyrings
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg
echo \
  "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu \
  $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/docker.list > /dev/null

sudo apt-get update

sudo apt-get install docker-ce docker-ce-cli containerd.io docker-compose-plugin -y

sudo curl -L "https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
sudo chmod +x /usr/local/bin/docker-compose
```

2. **Install AWS CLI**

Install AWS CLI on Ubuntu Official doc - <https://docs.aws.amazon.com/cli/latest/userguide/getting-started-install.html>

```
curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"
unzip awscliv2.zip
sudo ./aws/install
```

3. **Install Certbot**

```
sudo apt update
sudo apt install certbot python3-certbot-nginx -y 
```