On 11/1/22 01:53, Laurenz Albe wrote:
On Tue, 2022-11-01 at 06:44 +0000, Sacheen Birhade wrote:
If replication is in asynchronous then there will be data loss, right Laurenz?
Why? The data will perhaps show up on the standby a little later, but why is
that data loss? Remember that the question was about replication, and there
was no mention of failover.
No, the question was about a crash during replication: OP (not Sacheen, unless that person is using two email addresses) explicitly asked "
When the primary crashes due an unforeseen reason (what happens)?"
If the two database systems are really busy, and especially if the network connection isn't fast enough,
async replication means there
might be some transactions committed on Primary which were queued for transmission, but hadn't yet made it to the Secondary, right?
--
Angular momentum makes the world go 'round.