How to Deploy MySQL using Devopness in 5 Minutes

Deploy a production-ready MySQL instance with security best practices using Devopness' web interface or CLI. Complete guide with both methods:

Prerequisites

1. Provisioned server in Devopness (Guide: How to Provision a Server)
2. Environment permissions:
   • Service: Add
   • Service: Deploy
   • Service: Update
   • Server: Deploy

Complete Deployment Flow

1. Create MySQL Service

Web Interface:

1. Navigate to Projects > Your Project > Environments > Your Environment > Services

2. In Services section, click Add Service

3. Select MySQL from database engines

4. Configure parameters:

   Version: 8.0
   Port: 3306
   Storage: 25GB
   

CLI:

devopness service create \
  --type=mysql \
  --version=8.0 \
  --port=3306 \
  --storage=25

2. Configure Environment Variables

Set custom configurations through both interfaces:

Variable	Example Value	Description
MAX_CONNECTIONS	200	Concurrent connections

Web Interface:

1. Service Details page > Variables
2. Add variables manually or import via .env file

CLI:

devopness variables set \
  --service=mysql \
  MAX_CONNECTIONS=200

3. Execute Deployment

Web Interface:

1. Service Details page > Deploy
2. Select 1+ servers from list
3. Review configurations
4. Click Start Deployment

CLI:

# List available servers
devopness servers list

# Deploy to specific server
devopness deploy start \
  --service=mysql \
  --servers='SRV-12345'

4. Monitor Deployment Progress

Both interfaces show real-time status updates:

Deployment Stages:

1. Installation → 2. Configuration → 3. Logs

Web Interface:

• Interactive action graph on service page

CLI:

devopness actions list --service=mysql

Post-Deployment Management

Operation	Web Interface	CLI Command
Restart Service	Restart button on service page	devopness service restart mysql
View Logs	Logs tab	devopness logs mysql --tail
Update Version	Version section + Redeploy	devopness service update --version=8.1

Credential Email

After successful deployment, you'll receive an email with:

Service: MySQL
Port: 3306
Root User: root
Root Password: [auto-generated-secure-password]
Default User: [auto-generated-name]
Default User Password: [auto-generated-secure-password]
Default Database: devopness_default

---

Start Now and get MySQL running in 5 minutes with Devopness!