**Primary keywords:** managed mysql hosting, mysql cloud hosting, hosted mysql, mysql managed database, deploy mysql
---
MySQL powers a huge fraction of the web. WordPress, Drupal, Laravel, most PHP apps, and a large portion of Node.js backends rely on MySQL or its close cousin MariaDB. It's battle-tested, widely understood, and supported by virtually every ORM and framework.
The problem isn't MySQL itself — it's managing it. Installing, tuning, patching, backing up, monitoring, and recovering a MySQL server takes real time and expertise. Managed MySQL hosting hands those tasks to a provider so your team can focus on the application.
## What Managed MySQL Hosting Gives You
When you use a managed MySQL service, you get a running database instance without having to touch the server it runs on. The provider handles:
- **OS and MySQL version patching** — security updates applied without you scheduling maintenance windows
- **Automated backups** — daily snapshots with point-in-time recovery
- **High availability** — replica failover if the primary fails
- **Storage scaling** — disk grows with your data
- **Monitoring** — query performance, connection counts, slow query logs
ApexWeave.com
You keep full control over your schema, queries, users, and data.
## When to Choose MySQL
MySQL is the right choice when:
- You're running a PHP application — Laravel, Symfony, CodeIgniter, and WordPress all treat MySQL as the primary database
- Your team already knows MySQL well and wants to minimize unknowns
- You need a simple, well-documented relational database without complex feature requirements
- You're migrating an existing MySQL-backed app to the cloud
For greenfield Node.js or Python projects, PostgreSQL is often preferred, but MySQL is a solid choice and perfectly capable for most production workloads.
## Deploying a MySQL-Backed App on ApexWeave
ApexWeave provides managed MySQL hosting starting at $5/month. Here's the full workflow from zero to a connected production database.
### 1. Provision the Database
In the ApexWeave dashboard, go to **Databases** → **Create Database**, select **MySQL**, choose a plan, and click **Create**. You'll see a connection string immediately:
```
mysql://user:password@host:3306/dbname
```
### 2. Set the Database URL in Your App
```bash
apexweave env:set DATABASE_URL=mysql://user:password@host:3306/dbname
```
Verify:
```bash
apexweave env:list
```
### 3. Deploy Your App
```bash
apexweave deploy
```
ApexWeave builds and deploys your application with the new environment variable available at runtime.
## Connecting MySQL to Common Frameworks
### PHP / Laravel
In your `.env` file (or set via `apexweave env:set` for each key):
```
DB_CONNECTION=mysql
DB_HOST=host
DB_PORT=3306
DB_DATABASE=dbname
DB_USERNAME=user
DB_PASSWORD=password
```
Run migrations after deploy:
```bash
php artisan migrate --force
```
Many teams wire this into their deploy script so migrations run automatically.
### Node.js with mysql2
```javascript
const mysql = require('mysql2/promise');
const pool = mysql.createPool(
uri: process.env.DATABASE_URL,
waitForConnections: true,
connectionLimit: 10,
queueLimit: 0
);
async function query(sql, params)
const [rows] = await pool.execute(sql, params);
return rows;
```
### Python with PyMySQL
```python
import pymysql
import os
from urllib.parse import urlparse
url = urlparse(os.environ['DATABASE_URL'])
conn = pymysql.connect(
host=url.hostname,
user=url.username,
strapi cms production hosting
password=url.password,
database=url.path.lstrip('/'),
port=url.port or 3306,
ssl='ssl':
)
```
### WordPress (wp-config.php)
If you're deploying a custom WordPress setup (not using ApexWeave's WordPress plans), you can parse the database URL:
```php
$db_url = parse_url(getenv('DATABASE_URL'));
define('DB_NAME', ltrim($db_url['path'], '/'));
define('DB_USER', $db_url['user']);
define('DB_PASSWORD', $db_url['pass']);
define('DB_HOST', $db_url['host'] . ':' . $db_url['port']);
define('DB_CHARSET', 'utf8mb4');
```
## MySQL Configuration Tips for Production
### Use utf8mb4, Not utf8
MySQL's `utf8` is a 3-byte encoding that doesn't support emoji or certain Unicode characters. Always use `utf8mb4`:
```sql
ALTER DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```
Set this when creating tables too:
```sql
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```
### Enable the Slow Query Log
Understanding which queries are slow is the fastest path to performance improvements. Managed MySQL providers often expose slow query logs in the dashboard. Locally:
```sql
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 1; -- log queries slower than 1 second
```
### Index Strategically
MySQL's `EXPLAIN` output tells you whether queries use indexes:
```sql
EXPLAIN SELECT * FROM orders WHERE user_id = 42 AND status = 'pending';
```
Look for `type: ALL` (full table scan) as a sign you need an index:
```sql
CREATE INDEX idx_orders_user_status ON orders(user_id, status);
```
### Use InnoDB, Not MyISAM
InnoDB is the default storage engine in modern MySQL and supports transactions, foreign keys, and row-level locking. There's almost never a reason to use MyISAM on new tables.
## Running Migrations
### Laravel
```bash
php artisan migrate --force
```
The `--force` flag is needed to run migrations in production mode.
### Sequelize (Node.js)
```bash
npx sequelize-cli db:migrate
```
### Alembic (Python/SQLAlchemy)
```bash
ApexWeave hosting
alembic upgrade head
```
### Flyway
```bash
flyway -url=jdbc:mysql://host:3306/dbname -user=user -password=pass migrate
```
A common pattern on ApexWeave is to run migrations as a deploy hook — the migration runs as part of the deploy process before new application instances start handling traffic.
## Handling Connection Limits
MySQL has a `max_connections` setting that limits concurrent connections. On shared managed plans this can be relatively low (e.g., 25–75). Use a connection pool:
```javascript
// mysql2 pool with controlled concurrency
const pool = mysql.createPool(
node.js cloud hosting platform
uri: process.env.DATABASE_URL,
connectionLimit: 5, // keep well below max_connections
);
```
For PHP/Laravel, set `DB_POOL_SIZE` in your `.env` or use PHP-FPM's process count to limit concurrency.
## Backup and Recovery
ApexWeave runs automated daily backups. To take a manual backup locally:
```bash
mysqldump -h host -u user -p dbname > backup.sql
```
Restore:
```bash
mysql -h host -u user -p dbname < backup.sql
```
Always test your restore process before you need it. Run a restore to a test database and verify the data looks correct.
## Security Checklist
- Enable SSL for all connections (ApexWeave enforces this)
- Use a dedicated application user with only the permissions it needs
- Never use the root MySQL user in application code
- Rotate passwords periodically using `apexweave env:set`
- Don't expose port 3306 publicly — access through your application only
```sql
-- Create a least-privilege application user
CREATE USER 'appuser'@'%' IDENTIFIED BY 'secure_password';
GRANT SELECT, INSERT, UPDATE, DELETE ON mydb.* TO 'appuser'@'%';
FLUSH PRIVILEGES;
```
## ApexWeave MySQL Plans
- **DB Starter ($5/mo)** — Great for development, staging, and small production apps
- **DB Pro ($12/mo)** — Higher connection limits, larger storage, extended backup retention for production traffic
## Start With a Free Trial
Managed MySQL hosting on ApexWeave takes about 60 seconds to set up. Provision a database, get a connection string, and connect your app — no server configuration required.
Try it free for 7 days. No credit card required.
```bash
npm install -g apexweave-cli
apexweave login
apexweave deploy
ApexWeave hosting
apexweave env:set DATABASE_URL=mysql://user:password@host:3306/dbname
```
Focus on your app. Let ApexWeave handle the database.