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.
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.
- Create Compose account
- Create MySQL deployment
- Install tools and then connect to your database using the
mysqlcommand run on a local system or with a GUI based tool.
- Connect to the MySQL deployment with
adminuser and password from the Compose console
- Add further users with the
- Connect your application using your programming language's driver
sudo apt-get install mysql-client to install the
mysql command as a standalone command.
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.
Versions of MySQL for most platforms are available from the MySQL Server Community Page along with installation instructions. All include the
See Compose Datacenter Availability for current location availability.
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.
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.
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.
If this article didn't solve things, summon a human and get some help!