MySQL

Deploy fully managed MySQL databases on Antryk with automated backups, secure access control, scalable infrastructure, and production-ready performance.

What is MySQL?

MySQL is one of the most widely used open-source relational database management systems, trusted for web applications, SaaS platforms, enterprise software, and high-performance workloads. It offers fast query performance, strong reliability, and broad ecosystem compatibility.

With Antryk MySQL, you can deploy fully managed MySQL databases in minutes while Antryk handles infrastructure management, backups, networking, and operational maintenance.

---

MySQL Features on Antryk

• Fully managed MySQL deployments
• Multiple MySQL version support
• Secure database access control
• Automated backups and retention management
• Regional database deployments
• Connection information dashboard
• Scalable plans for development and production
• Simplified database administration
• Secure credential management
• Production-ready infrastructure

---

Deploy a MySQL Database

Creating a MySQL database on Antryk takes only a few steps.

Step 1: Choose Database Type

From the deployment dashboard:

1. Click Create Database
2. Select MySQL

---

Step 2: Select MySQL Version

Choose the MySQL version you want to deploy.

Example versions may include:

• MySQL 5.7
• MySQL 8.0
• MySQL 8.4

Using the latest stable version is recommended for new applications unless your application requires compatibility with an older version.

---

Step 3: Configure Database Settings

Enter your database configuration details.

Database Configuration Fields

Field	Description
Database Name	Name of your MySQL database
Default Database	Primary database for your application
Username	Database admin username
Password	Secure password for authentication

Example Configuration

Database Name: production_db
Default Database: app_db
Username: admin_user
Password: ********

---

Step 4: Select Deployment Region

Choose the region closest to your users or application infrastructure.

Available regions include:

• USA
• ASIA
• EUROPE

Selecting the nearest region helps reduce latency and improves application performance.

---

Step 5: Configure Access Control

Antryk provides flexible database access management.

Option 1: Allow Specific IP Addresses

Restrict database access to trusted IP addresses only.

Example:

192.168.1.10
203.0.113.45

Option 2: Allow All IPs

Enable public access from all IP addresses.

Recommended only for development environments or temporary testing.

---

Step 6: Configure Automated Backups

Automated backups help protect your data and simplify disaster recovery.

Enable or Disable Backups

You can:

• Enable automated backups
• Disable automated backups

Backup Frequency Options

If backups are enabled, choose a backup schedule:

• Hourly
• Daily
• Monthly

Backup Retention Options

Select how long backups are stored:

• 7 Days
• 14 Days
• 30 Days
• 90 Days

Example:

Backup Frequency: Daily
Retention Period: 30 Days

---

Step 7: Select a Plan

Choose a MySQL plan based on your workload requirements.

Plans may vary based on:

• CPU
• Memory
• Storage
• Network performance
• Backup limits

---

Step 8: Deploy Database

After completing configuration:

1. Review all settings
2. Click Deploy Database

Antryk will automatically provision your MySQL instance and prepare it for use.

---

MySQL Database Overview Page

The Overview page provides essential database connection and deployment information.

Available Information

Connection String

Use the generated MySQL connection string directly in your applications.

Example:

mysql://username:password@host:3306/database

Host

Database hostname used for external connections.

Port

Default MySQL port:

3306

Default Database

The primary database configured during deployment.

Username

Database authentication username.

---

MySQL Settings Page

The Settings page allows you to manage database configuration and security.

Available Settings

Change Database Password

Rotate credentials securely without redeploying the database.

Regenerate API Key

Generate a new API key for secure integrations.

Rename Database

Update the database name when needed.

Update Access Control

Modify IP allowlists or enable/disable public access.

Delete Service

Permanently remove the MySQL deployment.

Warning: Deleting a service permanently removes the database and associated data.

---

MySQL Backup Page

The Backup page allows you to manage backup configurations and retention settings.

Backup Management Features

Update Backup Frequency

Change backup schedules anytime:

• Hourly
• Daily
• Monthly

Modify Retention Period

Adjust how long backups are stored:

• 7 Days
• 14 Days
• 30 Days
• 90 Days

Enable or Disable Backups

Turn automated backups on or off depending on project requirements.

---

Security Features

Antryk MySQL deployments include multiple security controls.

Built-In Security

• IP-based access control
• Secure password authentication
• Encrypted connections
• Credential management
• Secure infrastructure isolation

---

Common MySQL Use Cases

MySQL is suitable for many modern applications.

Popular Use Cases

• SaaS applications
• Web applications
• REST APIs
• Financial systems
• Analytics platforms
• Content management systems
• E-commerce platforms
• Enterprise applications

---

Connecting to MySQL

Use the connection information from the Overview page to connect your application.

Node.js Example

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

async function connectDatabase() {
  const connection = await mysql.createConnection(
    process.env.DATABASE_URL
  );

  console.log("Connected to MySQL");
}

connectDatabase();

---

Python Example

import os
import mysql.connector

conn = mysql.connector.connect(
    option_files=None,
    host=os.environ["MYSQL_HOST"],
    user=os.environ["MYSQL_USER"],
    password=os.environ["MYSQL_PASSWORD"],
    database=os.environ["MYSQL_DATABASE"]
)

print("Connected to MySQL")

---

PHP Example

<?php

$conn = new mysqli(
    getenv("MYSQL_HOST"),
    getenv("MYSQL_USER"),
    getenv("MYSQL_PASSWORD"),
    getenv("MYSQL_DATABASE")
);

if ($conn->connect_error) {
    die("Connection failed");
}

echo "Connected to MySQL";

---

Best Practices

Recommended Production Configuration

• Use restricted IP access
• Enable automated backups
• Select daily or hourly backups for production workloads
• Use strong passwords
• Deploy in the closest region to your users
• Regularly rotate credentials

---

Why Choose MySQL on Antryk?

Antryk simplifies MySQL infrastructure management so teams can focus on building applications instead of managing servers.

Benefits

• Fast database deployment
• Simplified operations
• Secure infrastructure
• Flexible backup management
• Regional deployments
• Production-ready performance
• Developer-friendly experience