Compose Database-as-a-Service Help and Documentation

Everything you need to know about Compose, Hosted or Enterprise, is here in our help system. Whether you run one database for your businesses' sole application or six different databases to support an entire corporation, we've got the information you need.

Compose for MySQL

MySQL is one of the foundations of the modern web - it is the M in the original LAMP stack (Linux, Apache, MySQL, Python/Perl/PHP) - and has evolved over the years from a simple SQL database for the web to an enterprise database solution capable of taking on mission critical tasks. The most recent versions use the InnoDB storage engine by default and include JSON document support as a native data type. Used by numerous applications as their default backend storage, MySQL is firmly established as the most popular database engine on the web.

Compose for MySQL for All is a general introduction to MySQL on Compose.

Are you wondering what you'll get, or can get, with a Compose MySQL deployment? Want to know what you'll need to do to manage it? Check out some of the implementation features and details down in MySQL for Ops and Admins.

Just deployed MySQL and want to get coding with it? Developing an application or want to try a new stack? Then see the
MySQL for Developers section for resources on how to connect from different languages, command line tools and more information to get you started.

Compose for MySQL for All

When deployed on Compose, MySQL has comes with these standard Compose features.

Compose deployments of MySQL also come with a few MySQL specific features:

  • An optional add-on for real-time log access.
  • Start with 1GB storage for $27 - as you grow each additional gigabyte costs $18.

Compose Configuration

Compose for MySQL deployments come with three data nodes and one haproxy portal. The three data nodes have 1GB of storage and 102MB of memory. The haproxy portal has 64MB of memory.

Expansion Options

Compose auto-scaling will grow your deployment size as your data grows. You may also manually scale your deployment from the Resources panel in the Compose UI. Scaling happens in 1GB storage/102MB memory units and when you scale, each data node moves up to the new resource size. The haproxy portals can also be scaled in 64MB units. Additional haproxy portals can be added in the Security panel in the Compose UI.

Datacenter Availability

See Compose Datacenter Availability for current location availability.

Billing and Costs

Compose deployments are billed based on disk usage and your MySQL deployment usage is measured hourly. It is then grouped into a single monthly billing cycle. This means that any scaling or add-on usage will be charged from when the new resource was provisioned; not just for the month. You can see your deployment's usage in the Overview panel, under Current Usage.

Initial deployment set up is $27/month. Depending on which scaling and add-ons options you choose, the cost will increase. For example, if you wish to add extra storage and RAM, it is billed at an additional $18/month per unit of 1GB storage/102MB memory, so an additional 2GB storage/204MB memory will cost an additional $36/month.

For Ops and Admins

High-availability and Failover Details

All MySQL Deployments are high-availability clusters with 3 data nodes. MySQL clusters consist of a leader and a follower member on separate machines in separate zones. In the event of a leader member failure, we've configured automatic promotion of the current slave within 60 seconds of the leader becoming unresponsive.

Each MySQL deployment has a proxy, which provides a single member connection string so there is no worrying with which member is currently leader. Failover will happen seamlessly without requiring you to change your application's connection configuration.

For Developers

CLI Tools

The mysql command is used to communicate with MySQL through the command-line. It comes with a package installation of MySQL for your local system or development environment. To use the mysql command, you will also want to make sure your connections are SSL enabled.

Connecting to MySQL

The Overview panel of the Compose UI provides the basic information you need to get connected to your databases. In the section Connection info you will find Credentials and Connection Strings for getting your application connected, and the Command line for you to get direct access via, well, the command-line. For more information and examples in a few languages, see the Connecting to Compose for MySQL page.

Additional Resources and Related Articles

The full list of documentation for MySQL is in the side-bar, in addition to all things Compose.
For more than just help docs, check out Compose Articles and our curated collection of Compose for MySQL-related topics with more resources and how-to's for using Compose.


Still Need Help?

If this article didn't solve things, summon a human and get some help!

Compose for MySQL