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

About Compose for MySQL

About 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 capable 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.

Features of Compose for MySQL Deployments:

Like all Compose databases, Compose for MySQL Deployments allow developers to focus on what they do best (developing useful applications) and avoid the guesswork of capacity planning. These deployments are deployed on fast SSDs, fully replicated, and have access to huge amounts of RAM. As an application’s data size increases, the deployment resources scale fluidly to maintain consistent performance, and are billed based on actual usage.

MySQL uses RAM and I/O efficiently. Because of this, we scale RAM at a 1-to-10 ratio with datasize. As your data size increases by 1GB, we include 100MB of RAM.

  • Uses the latest MySQL 5.7.15 InnoDB Cluster release
  • Automatically scaling RAM, CPU, and I/O as your MySQL data grows.
  • Guaranteed resources per deployment.
  • 3 data-nodes clusters
  • Automatic failover process begins after leader node is down for 60 seconds
  • Running on extremely fast SSD (solid state drives)
  • No limit on database creation or schema creation
  • No-cost backups, no matter how big your deployment grows.
  • SSL connections enabled
  • Start with 1GB for $27.00 - as you grow each additional gigabyte of data costs $18.

Getting Started

  1. Create Compose account
  2. Create MySQL deployment
  3. Install tools and then connect to your database using the mysql command run on a local system or with a GUI based tool.
  4. Connect to the MySQL deployment with admin user and password from the Compose console
  5. Add further users with the mysql command.
  6. Connect your application using your programming language's driver

Installing tools

Ubuntu

Run sudo apt-get install mysql-client to install the mysql command as a standalone command.

macOS

Users will can install MySQL, the database, to get the. You can download from the MySQL Community Page.

Another option it to install MySQL Workbench and then add /Applications/MySQLWorkbench.app/Contents/MacOS to your shell's path. The mysql command can be found in that directory.

Other platforms

Versions of MySQL for most platforms are available from the MySQL Server Community Page along with installation instructions. All include the mysql command.

Data Center Availability

See Compose Datacenter Availability for current location availability.

Backups & Disaster Recovery

MySQL Deployments include the following automatic daily backup pattern:

  • Daily backups for 7 days
  • Weekly backups for 4 weeks
  • Monthly backups for 3 months

Backups include all MySQL data files, and are available for download. Backup downloads include a README file. See this file for instructions on restoring the data.

High Availability

All MySQL Deployments are high-availability clusters with 3 data nodes. Data nodes are powered by fully redundant architecture from the datacenter to the server. 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.

Additional Resources and Related Articles

The full list of documentation for Compose for MySQL is in the sidebar, in addition to all things Compose.

For more than just help docs, check out Compose Articles for more how-to's and information on Compose for MySQL.


Still Need Help?

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

Compose for MySQL

About Compose for MySQL