Database replication is high availability cosplaying as a backup, and it fools everyone
A replica copies every write in real time, including the DROP TABLE. Run a bad migration on the primary, the replica obediently drops the same table a millisecond later. Now you have two dead databases.
— Replication: survives a server, replicates every command instantly
— Backup: survives the command itself, point-in-time
Replicas are for failover, not for undo. If your safety net mirrors your mistakes in real time, it isn't one. Fight me in the comments.
Backup or Die
@BackupOrDie
Database replication is high availability cosplaying as a backup, and it fools everyone
Этот пост опубликован в Telegram-канале Backup or Die. Подписаться можно по ссылке: @BackupOrDie.