Tuesday 4 February 2020

READ COMMITTED Isolation Level on reading Replicas supported by Amazon Aurora

Amazon Aurora, a relational database that is compatible with MySQL and PostgreSQL and built for the cloud combining the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness features of open source databases, now supports the ANSI READ COMMITTED isolation level on reading replicas. It offers an isolation level that helps in executing long-running queries on an Aurora read replica without impacting the throughput of writes on the writer node. Amazon Aurora provides better results than both MySQL and PostgreSQL as it’s up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. Not only is the speed faster, but it also provides security, availability, and reliability of commercial databases at 1/10th the cost. It helps in automating time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups as it’s completely managed by Amazon Relational Database Service (RDS) that. The READ COMMITTED isolation level which is compatible with MySQL 5.6, and with engine version 2.07 and above, is available with Aurora MySQL engine version 1.21 and above. It is a great combination of performance and availability of high-end commercial databases and offers a simple yet cost-effective architecture.

No comments:

Post a Comment

Maximizing Content Delivery Efficiency: Optimizing Performance in AWS CloudFront

  Unleash Blazing-Fast Content Delivery: Your Guide to CloudFront Optimization Introduction: AWS CloudFront stands as a cornerstone of moder...