2 ms·
The gist is that postgres replication, by design[1], can not go out of sync. This is a major difference to MySQL replication, where silent divergence between M
by moe 15y ago
The gist is that postgres replication, by design[1], can not go out of sync.
This is a major difference to MySQL replication, where silent divergence between Master/Slave is a common problem. You don't notice it until you run into spurious SQL errors or perform a manual table-checksum. In a worst case you don't notice it until that day when your master fails...
[1] http://awurl.com/0g7Eshe5L#first_awesome_highlight http://awurl.com/0g7Eshe5L#first_awesome_highlight