-
For Relational Databases, Amazon RDS & Aurora both exist for common goal ?
updated 1 year, 7 months ago
2 Members
·
3
Posts
-
Why Amazon RDS service & Aurora DB co-exist as both are performing same task ?
-
Hi Gurpreet001,
Thank you for your message.
AWS offers a variety of purpose-built databases for all your application needs – from relational, NoSQL, in-memory, data warehouse, and other database types.
If you need a relational database, you can use Amazon RDS or Amazon Aurora. These databases have 4 key properties: Atomicity, Consistency, Isolation, and Durability or “ACID” for short. These properties guarantee the data integrity of your transactions.
The Amazon Relational Database Service is a relational database that is managed by both you and AWS. The time-consuming tasks of hardware provisioning, patching, backups, and maintenance are all handled by AWS, but you also have a certain level of control as well. You can choose and configure the underlying EC2 instance that will be used for your database – from its size, storage, instance type, and network access. You also get to decide the actual time when RDS will apply the DB patches in its maintenance window. Amazon RDS makes it easy for you to run various database engines such as Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, Oracle, Aurora, and others.
Amazon Aurora is both a database engine and a fully managed service owned by AWS. Aurora is a relational database that is compatible with both MySQL and PostgreSQL DB engines. This means that your existing code, application, and tools that you use with MySQL or PostgreSQL databases can also be used with Aurora with little or no change. It scales automatically, performs faster, and costs lower than other databases.
Amazon Aurora is just like Amazon RDS, but better! It can automatically grow or scale its storage as needed. Aurora is usually deployed as a database cluster. A cluster usually consists of a primary DB instance and multiple Aurora replicas or DB instances. These instances are like the standby or read replicas in Amazon RDS – but instead of calling it Amazon Aurora Multi-AZ deployments, it is simply called a “database cluster”. By default, a cluster has a single-master configuration where applications can only write data to a single, master DB instance. In a multi-master cluster, all DB instances have read/write capability.
Amazon RDS and Amazon Aurora are both suitable for applications that read or write constantly changing data, such as Online Transaction Processing applications or OLTP. An example of an OLTP application is an eCommerce website that processes thousands of online transactions per hour.
You may refer to below link for the direct comparison between these two AWS services.
Let us know if you need further assistance. The Tutorials Dojo team is dedicated to help you pass your AWS exam on your first try!
Best Regards,
JM @ Tutorials Dojo
-
Thank you so much JM, This is very crisp and clear description. Also, vs section in cheat sheet is really helpful.
Regards,
Gurpreet
Log in to reply.