On Fri, Oct 1, 2021 at 7:20 PM bened...@apache.org <bened...@apache.org> wrote:
> I haven’t encountered Galera – do you have any technical papers to hand? > > Yes, but it's a whole thesis :-) https://www.inf.usi.ch/faculty/pedone/Paper/199x/These-2090-Pedone.pdf I guess parts of that were presented in conference papers. Pedone's work implements a protocol with Snapshot Isolation. More recent work from down under describe a similar system providing Serializeable Snapshot Isolation: http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.228.185&rep=rep1&type=pdf The best known implementation of Pedone's work would be Galera Cluster, which hooks the "Galera" replication library into MySQL. It's also included with MariaDB Cluster and Percona XtraDB Cluster. Oracle later did an independent implementation (for IPR ownership reasons) which is known as InnoDB Cluster. This page in the Galera docs has a great diagram to get you started: https://galeracluster.com/library/documentation/certification-based-replication.html For an end user oriented beginner lecture, search conference video recordings for Seppo Jaakola: https://www.youtube.com/watch?v=5e3unwy_OVs Worth calling out that we are in RDBMS land now, and the above is just a replication solution, there is no sharding anywhere. For the Serializeable paper, I struggle to even imagine how it could scale to multiple shards. For SI it's kind of easier as only write conflicts need to be checked. henrik -- Henrik Ingo +358 40 569 7354 <358405697354> [image: Visit us online.] <https://www.datastax.com/> [image: Visit us on Twitter.] <https://twitter.com/DataStaxEng> [image: Visit us on YouTube.] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_channel_UCqA6zOSMpQ55vvguq4Y0jAg&d=DwMFaQ&c=adz96Xi0w1RHqtPMowiL2g&r=IFj3MdIKYLLXIUhYdUGB0cTzTlxyCb7_VUmICBaYilU&m=bmIfaie9O3fWJAu6lESvWj3HajV4VFwgwgVuKmxKZmE&s=16sY48_kvIb7sRQORknZrr3V8iLTfemFKbMVNZhdwgw&e=> [image: Visit my LinkedIn profile.] <https://www.linkedin.com/in/heingo/>
