Compose for MySQL
MySQL is a fast, easy-to-use, and flexible RDBMS. As the central component of the LAMP (Linux, Apache, MySQL and PHP) web service model, it sports a number of connectors, including Python, PHP and C++ for development needs. MySQL is the most popular relational open source database in the world because of its flexibility and vast supported ecosystem.Try Compose for MySQL free for 30-days
Every MySQL deployment on Compose is built in a highly-available, 3-node clustered configuration with one HAproxy portal to serve as a proxy and provide SSL support to the cluster. Compose for MySQL clusters consist of a leader and a follower member on separate machines in separate zones.
Automated backups are made every day and retained for 7 days along with 4 weekly backups and 3 monthly backups. The on-demand option of Compose backups allows up to 10 backups to be made a week. Backups are included at no extra cost and can also be created and retrieved using the Compose API.
As storage usage grows, the Compose platform will automatically maintain a 1:10 ratio of memory (RAM) to storage so your database is always performant. Users can also manually control scaling via the Compose console for specialized workloads or events.
All Compose database deployments offer daily logging and real-time memory usage metrics from the Compose console.
SSL enabled by default, so users can simply direct their applications to the URL shown in the Compose UI. Compose for MySQL will also accept non-SSL connections, however. The HAproxy portal can also use IP whitelisting to further restrict which clients can connect to the database.
Outgoing connections from the deployment include a Syslog-NG add-on for real-time exporting of logs to Loggly, Papertrail and other services.
A standard MySQL deployment consists of a three node cluster, and one HAproxy portal to serve as a proxy and provide SSL support to the cluster. Each data node has 1GB of storage and 102MB of memory. The HAproxy portal has 64MB of memory.
InnoDB storage engine
Compose for MySQL uses the InnoDB storage engine by default which includes JSON document support as a native data type.
We use the MySQL Group Replication technology to create our highly available cluster. Group replication requires that every table has a unique primary key — integer, UUID or string — to ensure replication works reliably.
We currently offer MySQL 5.7.17. All new deployments default to the most recent, stable release which we make available through the web UI. Upgrading to new versions can be done within your account with a few simple clicks.
Serious about security
MySQL runs on its own private VLAN, isolated from other traffic and access is entirely managed by active portals. SSL is configured by default. MySQL deployments run on their own private, isolated networks and the only way to connect to them is by using our SSH access portal. The TCP portals can use a whitelist to restrict access to the databases and that can be as tight as only allowing connections from the SSH portal to be routed.
The Compose console for managing and viewing your databases operates with its own account scheme, with multiple sub-users and roles to enable you to control access to your database administration. The Compose account scheme also includes the option to use two factor authentication to ensure the right people are logging in.
All your databases, one platform
Compose makes it easy to deploy your favorite open source databases in minutes into your preferred cloud datacenter on fast SSDs. Everything you need to run a performant database is available through the Compose web console or Compose APIs.
Ready to get started?
Deploy MySQL or any one of our production-ready, cloud hosted databases in minutes with just a few clicks.Try Compose Free for 30 Days