Ends in
00
days
00
hrs
00
mins
00
secs
ENROLL NOW

Get $4 OFF in AWS Solutions Architect & Data Engineer Associate Practice Exams for $10.99 each ONLY!

Amazon Aurora vs Amazon RDS

Home » AWS Cheat Sheets » Amazon Aurora vs Amazon RDS

Amazon Aurora vs Amazon RDS

Last updated on April 7, 2023

 

 

Aurora

RDS

Type of database

Relational database

Features

  • • MySQL and PostgreSQL compatible.

  • • 5x faster than standard MySQL databases and 3x faster than standard PostgreSQL databases.

  • • Use Parallel Query to run transactional and analytical workloads in the same Aurora database, while maintaining high performance.

  • • You can distribute and load balance your unique workloads across different sets of Aurora DB instances using custom endpoints.

  • • Aurora Serverless allows for on-demand, autoscaling of your Aurora DB instance capacity.
  • • Has several database instance types for different kinds of workloads and support five database engines – MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server.

  • • Can use either General Purpose Storage and Provisioned IOPS storage to deliver a consistent IOPS performance

Maximum storage capacity

128 TB

64 TB for MySQL, MariaDB, Oracle, and PostgreSQL engines

16 TB for SQL Server engine

DB instance classes

  • • Memory Optimized classes – for workloads that need to process large data sets in memory.

  • • Burstable classes – provides the instance the ability to burst to a higher level of CPU performance when required by the workload.

  • • Standard classes – for a wide range of workloads, you can use general purpose instance. It offers a balance of compute, memory, and networking resources.

  • • Memory Optimized classes – for workloads that need to process large data sets in memory.

  • • Burstable classes – provides the instance the ability to burst to a higher level of CPU performance when required by the workload.

Availability and durability

  • • Amazon Aurora uses RDS Multi-AZ technology to automate failover to one of up to 15 Amazon Aurora Replicas across three Availability Zones

  • • Amazon Aurora Global Database uses storage-based replication to replicate a database across multiple AWS Regions, with typical latency of less than 1 second.

  • • Self-healing: data blocks and disks are continuously scanned for errors and replaced automatically.
  • • Amazon RDS Multi-AZ deployments synchronously replicates your data to a standby instance in a different Availability Zone.

  • • Amazon RDS will automatically replace the compute instance powering your deployment in the event of a hardware failure.

Backups

  • • Point-in-time recovery to restore your database to any second during your retention period, up to the last five minutes.

  • • Automatic backup retention period up to thirty-five days.

  • • Backtrack to the original database state without needing to restore data from a backup.
  • • The automated backup feature enables point-in-time recovery for your database instance.

  • • Database snapshots are user-initiated backups of your instance stored in Amazon S3 that are kept until you explicitly delete them.

Scalability

  • • Aurora automatically increases the size of your volumes as your database grows larger (increments of 10 GB).

  • • Aurora also supports replica auto-scaling, where it automatically adds and removes DB replicas in response to changes in performance metrics.

  • • Cross-region replicas provide fast local reads to your users, and each region can have an additional 15 Aurora replicas to further scale local reads.
  • • The MySQL, MariaDB, SQL Server, Oracle, and PostgreSQL engines scale your storage automatically as your database workload grows with zero downtime.

  • • Read replicas are available for Amazon RDS for MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server. Amazon RDS creates a second DB instance using a snapshot of the source DB instance and uses the engines’ native asynchronous replication to update the read replica whenever there is a change to the source.

  • • Can scale compute and memory resources (vertically) of up to a maximum of 32 vCPUs and 244 GiB of RAM.

Security

  • • Isolate the database in your own virtual network via VPC.

  • • Connect to your on-premises IT infrastructure using encrypted IPsec VPNs or Direct Connect and VPC Endpoints.

  • • Configure security group firewall and network access rules to your database instances.

  • • Integrates with IAM.

Encryption

  • • Encrypt your databases using keys you manage through AWS KMS. With Amazon Aurora encryption, data stored at rest is encrypted, as are its automated backups, snapshots, and replicas in the same cluster.

  • • Supports the use of SSL (AES-256) to secure data in transit.
  • • Encrypt your databases using keys you manage through AWS KMS. With Amazon RDS encryption, data stored at rest is encrypted, as are its automated backups, read replicas, and snapshots.

  • • Supports Transparent Data Encryption in SQL Server and Oracle.

  • • Supports the use of SSL to secure data in transit

DB Authentication

  • • Password authentication

  • • Password and IAM database authentication
  • • Password authentication

  • • Password and IAM database authentication

  • • Password and Kerberos authentication

Maintenance

  • • Amazon Aurora automatically updates the database with the latest patches.

  • • Amazon Aurora Serverless enables you to run your database in the cloud without managing/maintaining any database infrastructure.
  • • Amazon RDS will update databases with the latest major and minor patches on scheduled maintenance windows. You can exert optional control over when and if your database instance is patched.

Monitoring

  • • Use Enhanced Monitoring to collect metrics from the operating system instance.

  • • Use Performance Insights to detect database performance problems and take corrective action.

  • • Uses Amazon SNS to receive a notification on database events.

Pricing

  • • A monthly charge for each database instance that you launch if you use on-demand. This includes both the instance compute capacity and the amount of storage being used.

  • • Option to reserve a DB instance for a one or three-year term (reserve instances) and receive discounts in pricing.

Use Cases

  • • Enterprise applications – a great option for any enterprise application that uses relational database since it handles provisioning, patching, backup, recovery, failure detection, and repair.

  • • SaaS applications – without worrying about the underlying database that powers the application, you can concentrate on building high-quality applications.

  • • Web and mobile gaming – since games need a database with high throughput, storage scalability, and must be highly available. Aurora suits the variable use pattern of these apps perfectly.
  • • Web and mobile applications – since the application needs a database with high throughput, storage scalability, and must be highly available. RDS also fulfills the needs of such highly demanding apps.

  • • E-commerce applications – a managed database service that offers PCI compliance. You can just focus on building high-quality customer experiences without thinking of the underlying database.

  • • Mobile and online games – game developers don’t need to worry about provisioning, scaling, and monitoring of database servers since RDS manages the database infrastructure.

 

Get $4 OFF in AWS Solutions Architect & Data Engineer Associate Practice Exams for $10.99 ONLY!

Tutorials Dojo portal

Be Inspired and Mentored with Cloud Career Journeys!

Tutorials Dojo portal

Enroll Now – Our Azure Certification Exam Reviewers

Tutorials dojo strip

azure reviewers tutorials dojo

Enroll Now – Our Google Cloud Certification Exam Reviewers

Tutorials Dojo Exam Study Guide eBooks

tutorials dojo study guide eBook

FREE AWS Exam Readiness Digital Courses

AWS Exam Readiness Courses

Subscribe to our YouTube Channel

Tutorials Dojo YouTube Channel

FREE Intro to Cloud Computing for Beginners

FREE AWS, Azure, GCP Practice Test Samplers

Recent Posts

Written by: Admin User-1

AWS, Azure, and GCP Certifications are consistently among the top-paying IT certifications in the world, considering that most companies have now shifted to the cloud. Earn over $150,000 per year with an AWS, Azure, or GCP certification!

Follow us on LinkedIn, YouTube, Facebook, or join our Slack study group. More importantly, answer as many practice exams as you can to help increase your chances of passing your certification exams on your first try!

View Our AWS, Azure, and GCP Exam Reviewers Check out our FREE courses

Our Community

~98%
passing rate
Around 95-98% of our students pass the AWS Certification exams after training with our courses.
200k+
students
Over 200k enrollees choose Tutorials Dojo in preparing for their AWS Certification exams.
~4.8
ratings
Our courses are highly rated by our enrollees from all over the world.

What our students say about us?