I keep reading all these horror stories about Aurora (especially PostgreSQL). Is there anyone out there with an alternative story?
Source: Microsoft SQL Server performance tuner who runs an app that centralizes SQL Server performance data from thousands of servers. You'd think I would be running MSSQL on the back end, but the licensing costs just didn't make sense compared to Aurora Postgres.
Just don't use the AWS Database Migration Service if you can help it, that thing has a couple of badly documented pitfalls. (Fe. tables can't have ENUM fields)
It had so many gotchas and broken features. I'd be amazed if anyone got it really working on large applications without weeks of time invested.
It would be so cool though if it worked seamlessly. It addresses some of the hardest tasks in DB management, namely zero downtime server migration.