MySQL (Amazon RDS)

Component description

MySQL is the world's most popular open source relational database. The component is available in two engines:

  • MySQL Standard: The well-know traditional MySQL-Engine which makes it easy to use and scale MySQL in cloud environments.

  • MySQL Aurora: A MySQL-compatible database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. It is up to five times faster than standard MySQL databases. Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 128TB per database instance. Therefore we recommend Aurora for most use cases.


Variants

MySQL Standard

  • Single: 1 Node

  • Fail-Over: 1 Node + 1 Fail-Over Node (Multi-AZ)

  • Cluster: 1 Node + 1 Fail-Over Node (Multi-AZ) + 1 ReadReplica)

MySQL Aurora

  • Single: 1 Node

  • Fail-Over: 1 Node + 1 Fail-Over Node with ReadOnly capability

  • Cluster: 1 Node + 1 Fail-Over Node with ReadOnly capability + 1-n ReadReplicas (incl. Autoscaling)

Currently supported versions

Engine

Version

known issues

Standard

<= MySQL 5.7.33

<= MySQL 8.0.23

AWS has announced MySQL 5.6 end of life by August 2021

Aurora

MySQL 5.7 using InnoDB

MySQL 8.0 using InnoDB

 

Aurora Serverless

MySQL 8.0 using InnoDB

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.limitations

The latest versions and further information can be found here:

Pricing

For AWS pricing see https://aws.amazon.com/rds/pricing/.

For root360 Managed Services pricing please contact our Service Team.

Related tutorials

 

root360 Knowledge Base - This portal is hosted by Atlassian (atlassian.com | Privacy Policy)