3 ms·

Our experience with pg aurora was awful. I cannot recommend it to anyone. Our primary would run out of memory and fail over every few hours and all amazon suppo

Our experience with pg aurora was awful. I cannot recommend it to anyone. Our primary would run out of memory and fail over every few hours and all amazon support had to say is that it’s a known issue. We ended up adding even more functionality to our audit trigger package (based on a SecondQuadrant fork, https://github.com/icheishvili/audit-trigger https://github.com/icheishvili/audit-trigger) to allow us to get off of aurora. AWS does a good job at locking you in.

nwah1 7y ago
Other downsides are that it is more expensive than Aurora MySQL and there's no automated upgrade tools.
js2 7y ago
Here's another recent report of a bad experience with a reply from the Principal Product Manager for Aurora PostgreSQL: https://www.reddit.com/r/aws/comments/bv70k8/aurora_postgres_disastrous_experience/ https://www.reddit.com/r/aws/comments/bv70k8/aurora_postgres...
jitl 7y ago
Came here to echo this. I’ve heard the same story from a few different companies that tried to use Postgres Aurora as their primary database: insurmountable production issues, limited response from Amazon, eventual migration away.
qatanah 7y ago
Very interesting audit trigger. Would like to try it w/ partition table instead of doing separate tables.