MySQL in the Cloud

Table of Contents

MySQL in the Cloud

Prev: scaling-mysql Next: compliance-with-mysql

Managed MySQL is more hands-off, more expensive and gives you less control.

Remember that these data-stores are probably mysql compatible, so they might not even be MySQL under the hood.

Amazon Aurora for MySQL

Aurora is a MySQL compatible hosted database (for MySQL 5.6). Aurora separates compute from storage, which allows them to scale separately and more flexibly. It takes snapshot backups, manages fast schema changes, does audit logging, and manages replication within a single region.

Aurora’s replication is, however, entirely proprietary.

Here are some other offerings it has:

Aurora Serverless:

Aurora Global Database:

Aurora Multi-Master

GCP Cloud SQL

GCP actually runs the community server of MySQL, but with certain features disabled.

  1. SUPER is diabled
  2. Plugins are dissabled
  3. mysqldump and mysqlimport are disabled.

However, there’s a few pros:

  1. Native high-availability
  2. Encryption at rest
  3. Flexibly managed upgrades using multiple methods

MySQL on Virtual Machines

You’ll need to think about what’s the right machine type for you and think about the following factors

  1. CPU
  2. Memory
  3. Network Performance
  4. SSD vs HDD
  5. IOPS and throughput

Prev: scaling-mysql Next: compliance-with-mysql