News for hackers. Stuff that matters.
Re:Announcing RDS/Aurora Snapshot Export to S3 by otterley on Friday January 24, 2020 @02:53PM (#22141832)
We recommend you do migrate - lots of great features in Aurora while remaining 100% MySQL compatible.

(EDIT: I should have said "wire and protocol compatible" as opposed to "100%". I regret the error.)

Re:Announcing RDS/Aurora Snapshot Export to S3 by verelo on Friday January 24, 2020 @03:17PM (#22142022)
Would you sign your first born over to me on that promise? Obviously I'm joking, but i have in the past got nervous that there might be issues with this claim. I.e. previously i found that the MySQL welcome banner that Aurora gave me claimed it was a very specific version, but when i tested a bug fixed in a previous MySQL version (a weird edge cases for us around transactions) it failed the test. I'm worried that while the goal is for it to be 100% compatible, the number is closer to 99.X% and that means the migration isn't a small amount of work to verify.
Re:Announcing RDS/Aurora Snapshot Export to S3 by otterley on Friday January 24, 2020 @03:34PM (#22142174)
Definitely send us a support ticket if you find a regression in Aurora/MySQL's behavior for a specific point release.
Re:Announcing RDS/Aurora Snapshot Export to S3 by verelo on Friday January 24, 2020 @03:46PM (#22142282)
That is what I did back then, i actually got a great response and the explanation of why this issue existed was valid. Not a real concern, I just don't love the way Amazon suggests "use Aurora" all the time when the real issue from the customers perspective is "Other non-Aurora RDS offerings are lacking features, and we have to keep using them - at least for now".
Re:Announcing RDS/Aurora Snapshot Export to S3 by PeterZaitsev on Friday January 24, 2020 @03:23PM (#22142075)
Aurora compatibility with MySQL is great. But as any 100% compatibility claims this one is bullshit. You can get close but you never really quite hit 100%

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...

The following features are supported in MySQL 5.7.12 but are currently not supported in Aurora MySQL 5.7:

Group replication plugin

Increased page size

InnoDB buffer pool loading at startup

InnoDB full-text parser plugin

Multisource replication

Online buffer pool resizing

Password validation plugin

Query rewrite plugins

Replication filtering

The CREATE TABLESPACE SQL statement

X Protocol

Re:Announcing RDS/Aurora Snapshot Export to S3 by mritun on Friday January 24, 2020 @09:04PM (#22144156)
Those are all irrelevant for Aurora - which is a fully hosted, natively replicated database.
Re:Announcing RDS/Aurora Snapshot Export to S3 by sandGorgon on Friday January 24, 2020 @05:23PM (#22143002)
This is something we face as well on the postgresql side. We don't want to migrate.

And we want to maintain large number of multi-terabyte backups (that are RESTORABLE) in Glacier for compliance reasons.

There is orders of magnitude of cost difference between snappshots and Glacier. Also i cant maintain beyond 30 days.