Could you elaborate more about this part ?
“However, the drawback of WAL is its tight coupling with the inner structure of the database engine, making software upgrades on the leader and followers complicated.”
I think this drawback is with SBR as well, correct ?
Hi Shady_Yahia_AI_Shara,
Yes, you’re correct. Both Write-Ahead log (WAL) and Statement-based replication (SBR) can face challenges with software upgrades due to the drawback of their tight coupling with the inner workings of the database engine. Any changes or upgrades to the database engine may require corresponding adjustments to the replication mechanism to ensure compatibility and functionality across all nodes in the replication setup.
We hope Educative continues to inspire your learning journey!
Thank you,