4 ms·
One thing I've noticed that in the medium term of a software service (2-5 years) is that your software should have the ability to do double-writes to and flip r
by AtlasBarfed 7y ago
One thing I've noticed that in the medium term of a software service (2-5 years) is that your software should have the ability to do double-writes to and flip reads between two different datastores.
That will afford migration with as close to transparent migration with as reduced a downtime or no downtime.
- earhart 7y agoThat gets tricky if one of the writes fails.
- hobs 7y agoGenerally you get two phase commit involved here, or an asynch mirror that you can restore over if there's failure.
- jatone 7y agowat. particularly today with logical replication this is pretty much unnecessary.
- smitty1e 7y agoThat sort of flexibility does not sound as though it would scale well as the data get big.
- madhadron 7y agoDefine "big." Double writing in some form is the only option for live migration and you either bolt it on later or plan for it now.