Abasthan
DocsMariaDB

MariaDB

High-performance, managed MariaDB databases optimized for speed and reliability.

Database Instances

Abasthan provisions MariaDB instances in isolated containers within our private network. Every instance is configured with optimized defaults for production workloads.

  • Reliability: Built on the latest stable MariaDB releases.
  • Automatic Backups: Daily snapshots ensure your data is always safe.
  • Storage: Backed by high-speed NVMe SSDs for minimal latency.

Connecting Your App

For applications running on Abasthan, connecting to MariaDB is seamless. When you link a MariaDB service to your app, we automatically inject the following environment variables:

MARIADB_HOST=db-abasthan-prod
MARIADB_PORT=3306
MARIADB_USER=abasthan_user
MARIADB_PASSWORD=your_secure_password
MARIADB_DATABASE=app_db
DATABASE_URL=mysql://user:pass@host:port/db

External Access (SSH Proxy)

For security, Abasthan databases are not exposed to the public internet. To connect from your local machine (e.g., using MySQL Workbench or TablePlus), use our built-in SSH database proxy.

Connect via SNI-routing:

[app_id].mariadb.db.abasthan.app:24028

This connection requires STARTTLS and is routed through our secure database gateway.

Best Practices

  • Storage Engines: We recommend using the InnoDB storage engine for its reliability and performance features.
  • UTF-8 Support: Use utf8mb4 character set to ensure full support for emojis and international characters.
  • Query Tuning: Regularly check your slow query logs in the Insights tab to identify and optimize performance bottlenecks.

Troubleshooting

If you encounter "Too many connections" errors, verify your app's connection pool settings or consider upgrading your plan to increase the connection limit.

← PostgreSQLMongoDB →