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 |
Learn Sql Team 