
MySQL
MySQL database with persistent storage
Deploy MySQL in 3 Steps
Connect Your VPS
Add your server credentials to Server Compass
Select MySQL
Choose from our template library
Deploy & Configure
Fill in settings and click Deploy
DIY MySQL Deployment
Learn how to self-host MySQL with this hands-on deployment guide.
Start a Secure Shell Session
Open your terminal and connect to your server. Replace the IP address with your VPS IP.
# SSH into your server
ssh root@your-server-ip
# Using a custom SSH key
ssh -i ~/.ssh/id_rsa root@your-server-ipFirst time? Need Docker? Install it: curl -fsSL https://get.docker.com | sh
Prepare Your Workspace
Set up a clean directory for your application.
# Create and navigate to project directory
mkdir -p ~/apps/mysql
cd ~/apps/mysqlSet Up Container Configuration
Set up the container stack using this Docker Compose configuration:
services:
mysql:
image: mysql:8
ports:
- "3306:3306"
environment:
- MYSQL_ROOT_PASSWORD=<your-mysql-root-password>
- MYSQL_DATABASE=app
- MYSQL_USER=app
- MYSQL_PASSWORD=<your-mysql-password>
volumes:
- mysql_data:/var/lib/mysql
restart: unless-stopped
healthcheck:
test: ["CMD-SHELL", "mysqladmin ping -h localhost -u root -p$$MYSQL_ROOT_PASSWORD || exit 1"]
interval: 10s
timeout: 5s
retries: 5
volumes:
mysql_data:
PORTHost port to expose(default: 3306)MYSQL_ROOT_PASSWORDRoot passwordMYSQL_DATABASEDatabase name(default: app)MYSQL_USERDatabase username(default: app)MYSQL_PASSWORDDatabase passwordBring Up the Application
Launch your application stack in the background.
# Start the containers in detached mode
docker compose up -d
# Check if containers are running
docker compose ps
# View logs
docker compose logs -fConfigure Firewall
Configure your firewall to permit external connections.
# Allow the application port through firewall
sudo ufw allow 3306/tcp
sudo ufw reload
# Access your app at:
# http://your-server-ip:3306Prefer a visual interface? Use Server Compass.
Let Server Compass handle the complexity. Deploy MySQL with a simple, intuitive interface.
- Visual configuration UI
- One-click deployment
- Automatic SSL setup
- Zero-downtime updates
- Built-in monitoring
- One-click rollbacks
After Deployment
After deploying MySQL with Server Compass, complete these steps to finish setup
Test database connection
Create additional users with specific privileges
Configure automated backup scripts
Set up monitoring and alerts
Optimize MySQL configuration for your workload
Review and apply security best practices
Need help? Check out our documentation for detailed guides.
MySQL FAQ
Common questions about self-hosting MySQL
How do I deploy MySQL with Server Compass?
Simply download Server Compass, connect to your VPS, and select MySQL from the templates list. Fill in the required configuration and click Deploy. The entire process takes under 3 minutes.
What are the system requirements for MySQL?
MySQL requires a minimum of 512MB RAM. We recommend a VPS with at least 1024MB RAM for optimal performance. Any modern Linux server with Docker support will work.
Can I migrate my existing MySQL data?
Yes! Server Compass provides volume mapping that allows you to import existing data. You can also use standard MySQL backup and restore procedures.
How do I update MySQL to the latest version?
Server Compass makes updates easy. Simply click the Update button in your deployment dashboard, and the latest MySQL image will be pulled and deployed with zero downtime.
Is MySQL free to self-host?
MySQL is open-source software. You only pay for your VPS hosting (typically $5-20/month) and optionally Server Compass ($29 one-time). No subscription fees or per-seat pricing.
Ready to Self-Host MySQL?
Download Server Compass and deploy MySQL to your VPS in under 3 minutes. No Docker expertise required.
Download Server Compass



