Skip to main content

​
MySQL

Deploy fully managed MySQL databases with automated backups, high availability, and scaling capabilities.

​
What is MySQL?

MySQL is a popular open-source relational database management system. Antryk offers fully managed MySQL with zero administration overhead.

​
Key Features

  • MySQL 8.0: Latest stable version
  • Automated Backups: Daily backups with point-in-time recovery
  • High Availability: Multi-zone replication
  • Connection Pooling: Built-in connection management
  • Read Replicas: Scale read queries across replicas
  • Monitoring: Performance insights and query analytics
  • Storage: Automatic storage scaling

​
Use Cases

  • WordPress websites
  • PHP applications
  • Legacy applications
  • Content management systems
  • Small to medium web applications

​
Getting Started

  1. Create a MySQL database from your dashboard
  2. Choose plan (Dev, Starter, or Production)
  3. Configure region and database name
  4. Get connection string and credentials
  5. Connect your application

​
Connection Examples

​
Node.js

const mysql = require('mysql2/promise');

const connection = await mysql.createConnection({
  uri: process.env.DATABASE_URL,
  ssl: { rejectUnauthorized: false }
});

​
PHP

$mysqli = new mysqli(
    parse_url(getenv('DATABASE_URL'))['host'],
    parse_url(getenv('DATABASE_URL'))['user'],
    parse_url(getenv('DATABASE_URL'))['pass'],
    parse_url(getenv('DATABASE_URL'))['path']
);

​
Python

import mysql.connector

conn = mysql.connector.connect(
    uri=os.environ['DATABASE_URL'],
    ssl_verify_cert=True
)

​
Plans

  • Dev: Development and testing (single zone)
  • Starter: Small production workloads
  • Production: High availability with multi-zone replication

​
Scaling

  • Vertical Scaling: Increase CPU and memory
  • Horizontal Scaling: Add read replicas
  • Storage: Automatic storage scaling
  • Connection Limits: Configurable max connections

​
High Availability

  • Primary-Replica: Multi-zone replication
  • Automatic Failover: Automatic promotion of replica
  • Read Scaling: Distribute reads across replicas
  • Backup Retention: Configurable retention period

​
Security

  • SSL/TLS: Encrypted connections required
  • VPC Integration: Private network connectivity
  • IP Whitelisting: Restrict access by IP
  • Authentication: Username/password auth

​
Backups

  • Automatic Backups: Daily at scheduled time
  • Manual Backups: On-demand backups
  • Point-in-Time Recovery: Restore to specific timestamp
  • Backup Retention: 7-day retention (extendable)

​
Monitoring

Track database performance with:
  • Query Performance: Slow query log analysis
  • Connection Metrics: Active connections, threads
  • Storage: Disk usage and growth trends
  • Replication Lag: Monitor replica status

Create MySQL Database

Get started with MySQL