Re:Modern cloud architecture on AWS: server fleets and datab...
by nunez on Saturday February 08, 2020 @07:41PM
(#22279653)
You would move to RDS the minute you know you're committed to AWS and know that you don't want to
worry about things like backups, upgrades or clustering. The disadvantage to doing so is that you
lose a lot of administrative privileges to the database server itself and you don't get access to
the filesystem or underlying OS. We had trouble migrating a sizable SQL Server installation onto RDS
because it had a ton of triggers and stored procedures (SPs) that relied on files in the filesystem.
[ Parent
| on HN ]
Re:Modern cloud architecture on AWS: server fleets and datab...
by bradknowles on Sunday February 09, 2020 @03:32AM
(#22281054)
Yeah, well. That’s SQL Server for you. There’s a lot of things that RDS can’t do for you in the SQL Server flavor.
RDS MySQL != RDS Postgres && RDS (MySQL || Postgres) >> RDS SQL Server