Amazon RDS or Aurora Serverless
As we mentioned in the previous post , AWS offers two key services for managed databases. These are Amazon RDS, a managed service that launches and maintains database servers in the cloud, and Aurora Serverless, a relational database engine with a deployment model that doesn't require developers to manually start database servers.
Below we present the differences between the two services to deploy the one that best suits your needs and current database storage engines.
If you found this post interesting, we invite you to download our free ebook, " How to Migrate to Amazon Web Services?"
The main difference between Amazon RDS and Aurora Serverless
- Amazon RDS It gives us the option to choose the type and size of the database instance and also select a database engine, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle and Microsoft SQL Server.
- For its part, Aurora It is Amazon's native database engine, designed explicitly to work with the AWS cloud, being compatible only with PostgreSQL and MySQL
However, both solutions are compatible, since a good first step for database modernization projects is to start with Amazon RDS, which provides greater freedom in data management and scaling . Meanwhile, if a more specialized platform is needed, Aurora is the ideal choice because it facilitates the provisioning of engines like MySQL and PostgreSQL with higher performance.
Let's look in more detail at how each one works:
Amazon RDS
Amazon RDS is useful for applications with constant traffic such as e-commerce or large development applications. Here are its main features:
1. Ease of use: With RDS you can use the AWS Management Console , the Amazon RDS command-line interface , or API calls to deploy and manage data.
2. Automatic application of patches to the software: a major advantage is that it offers guidance on best practices by analyzing the configuration and usage metrics of database instances.
3. Storage: You can provision up to 6 TB of storage, on demand and with no downtime.
4. Replication: Allows up to five copies of live databases. However, it's important to note that RDS fault tolerance is implemented manually, so some data loss is possible.
5. Backup: allows you to create a daily snapshot copy of the databases and save transaction logs for recovery at any time.
6 performance
- Optimized OLTP : Storage is optimized for heavy workloads
- General purpose: cost-effective hardware that delivers 3 IOPS per GB of storage.
Amazon Aurora Serverless
Aurora Serverless is a good choice for applications that do not expect regular traffic, such as development or test environments, its advantages are:
1. Availability: Amazon Aurora offers greater availability and better resilience, performs continuous backups and can restore them with a very low recovery point target.
2. Storage: Scalable at any time, Amazon Aurora automatically increases storage from a minimum of 10 GB to a maximum of 64 TB, in 10 GB increments.
3. Replication: Failover or fault tolerance for reading the replica is performed automatically to prevent data loss. This is faster in Aurora, which supports up to 15 read replicas.
4. Backup: Backups are continuous incremental backups that do not affect database performance. Furthermore, frequent snapshots are not required to enable point-in-time recovery.
5. Performance: MySQL standard performance is improved by 5 times and PostgreSQL standard performance by 2 times, with the same hardware configuration.
Considering the key aspects of both platforms, it will be up to the current database engines to initiate a modernization and scale to more specialized services as the data requires. AWS offers the possibility of scaling from AWS RDS to Aurora in a simple way, so large investments in infrastructure will not be necessary.
At Apser, we have experts to help you with your cloud migration process through a customized roadmap. Contact us ; we'd love to learn about your project.
