3 ms·
Except for the DB. The official way to migrate from a Lightsail DB to RDS is to do a logical dump and restore. For MySQL, or if you have a monotonic column in
by sgarland 11mo ago
Except for the DB. The official way to migrate from a Lightsail DB to RDS is to do a logical dump and restore.
For MySQL, or if you have a monotonic column in Postgres, that might be doable if you dumped in parallel, but otherwise it’s an unacceptable amount of downtime when you reach the limits of Lightsail.
It is baffling to me that AWS doesn’t offer a one-click option to B/G from Lightsail —> RDS, as that’s a very reasonable growth pattern for many startups.
- raw_anon_1111 11mo agoIf it is already in a DB, why wouldn’t that be treated as just a DB in the now peered Lightsail VPC?
- sgarland 11mo agoYour options are severely limited for Lightsail; it maxes out at 8 GB RAM and 240 GB storage for a DB.
- raw_anon_1111 11mo agoIsn’t that enough for a starter project as a hobbyist?
- sgarland 11mo agoYes, but when your starter project takes off and you start to get serious traffic, there’s no good path to migrate off. It’s all very manual, and involves a fair amount of downtime unless you have the requisite knowledge to set up logical replication; even then, unless you know how to chain replication, you’re going to thrash your buffers, and cause slow queries for existing traffic.