MySQL

MySQL is an open-source relational database management system (RDBMS)

::note MySQL requires a minimum of 512 Mb of memory, which does not work under the free tier of KintoHub. ::

Create a MySQL Database

All MySQL databases are 100% dedicated resources.

  1. Login to your KintoHub account
  2. Click Create Service at the top right of your environment
  3. Click the From Catalog tab at the top right
  4. Click the MySQL option in the list
  5. Enter or generate your desired Username Password and Root Password values
  6. Click Deploy at the top right and wait until the release is successful
  7. Once deployed, click on the Access Tab to read the access related options

Access Your MySQL Instances

You may only access your MySQL Instance from services running in the same environment. Learn more about how to connect to your MySQL Instance under the Access Tab.

::note In the near future you will be able to Tunnel from your machine to your service for easy access. Additionally, a feature to run commands directly to your mysql instance via a Shell terminal will be available as well. ::

MySQL Advanced Options

Replication

Enabling replication turns on a separate endpoint for MySQL readonly instances. You can enable replication under the Configurations tab when Creating a MySQL service. You may not enable this after the service has been created. It's recommended to enable Replication in production environments or any environments you wish to decrease the chances of downtime. Read more about read replicas here.

Cost Optimization

Enabling Cost Optimization is not recommended for production environments. Cost optimization places your instances on Spot or Pre-emptible cloud instances which can incur random downtime. For best effort uptime, you must disable cost optimization.

(Storage) Persistence

MySQL has an optional (Storage) Persistence and Volume Size options available under the Advanced Options Tab.