sql databases optimize for consistency instead of availability. And even if you design your data model not to rely on joins, to use unique ids per node, and to replicate both directions or disallow writes on the slave, at least MariaDB failed on partitioning, and I didn´t want or tried to use an database not supported by the application. Obviously you may get by without encountering issues for quite some time, and this unfortunately is true for many replication scenario recommendations. Cheers, Joachim
-----Ursprüngliche Nachricht----- Von: Jeff Peng via Postfix-users <[email protected]> Gesendet: Samstag, 15. Juni 2024 07:20 An: postfix user <[email protected]> Betreff: [pfx] Re: distributed email system On 2024-06-15 12:46, Jean-François Bachelet via Postfix-users wrote: > Hello folks :) > isn't it what sql databases replication is good for ? > Replication becomes bad when network partition. ;) _______________________________________________ Postfix-users mailing list -- [email protected] To unsubscribe send an email to [email protected] _______________________________________________ Postfix-users mailing list -- [email protected] To unsubscribe send an email to [email protected]
