Aurora PostgreSQL vs MySQL Feature Comparison

Feature Comparison – Aurora PostgreSQL vs MySQL Feature Comparison

As of Sep 2019.

Features Features details Aurora PostgreSQL Aurora MySQL RDS PostgreSQL
High Availability Read-replica Yes ( Up to 15 ) with sub-10ms replica lag Yes ( Up to 15 ) with sub-10ms replica lag Yes ( Up to 5 )
cross-region read replicas No Yes Yes
Read-write stand by Multi-AZ Multi-AZ Multi-AZ
Aurora Global Database No Yes No
Multi-Master No Yes No
Sync Replication Multi-AZ for stand by instance Multi-AZ for stand by instance Multi-AZ for stand by instance
Async Replication No Supported Read Replica across region Read Replica across region
Multi-AZ deployment Create an Aurora Replica/Reader node in a different AZ Create an Aurora Replica/Reader node in a different AZ Create a standby instance
Automatic monitoring and failover Yes recovery in senconds Yes recovery in senconds No
Scalability Auto scaling Yes ( Up to 64 TB ) Yes ( Up to 64 TB ) Yes
Auto Scaling – Aurora read repica Yes Yes No
Backup Rentension 35 Days 35 Days 35 Days
Database Location Regional Yes Yes Yes
Global No Yes No
Database features One writer and multiple readers Yes Yes No
One writer and multiple readers – Parallel query No Yes No
Multiple writers No Yes No
Serverless Yes Yes No
Log types publish to CloudWatch Audit log NA Yes NA
Error log NA Yes NA
General Log NA Yes NA
Slow query log NA Yes NA
Upgrade log No No Yes
Postgresql log Yes No Yes
Maintenance window Select window Yes Yes Yes
Monitoring Enable Enhanced monitoring Yes Yes Yes
Performance Insights Yes Yes Yes
Connectivity client drivers Standard PostgreSQL Client driver Standard MySQL Client driver Standard PostgreSQL Client driver
Backtrack Backtrack No Yes ( Up to 72 hours ) No
Query parallel query parallel query in the head node parallel query in the storage nodes
Query Plan Management (QPM) Yes No No
Cluster Cache Management (CCM) Yes No No
Database Activity Streams (DAS) Yes Coming soon Coming soon

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s