On Tue, Sep 30, 2025 at 11:27:25AM -0400, John Merriam via Evergreen-dev wrote: > I am researching available options but so far have not come across something > that looks like it would be a great solution. Long time lurker, seldom poster. I'm not responsible for any Evergreen deploys for several years now, but I do still have care & feeding of PostgreSQL databases on the edges of work I do.
TL;DR: Evergreen's usage of PL/perl and extensions [3] make this very hard regardless of offering. If it was pure PostgreSQL-dialect SQL; then the best available multi-master solution would be CockroachDB (CRDB)'s offering - the performance is fundamentally limited on having extremely consistent time that is shared between the group of servers [consistent between them is more important than overall accurate] - 1ms delta ideally. Also beware licensing costs, and operational complexity to run the service. There are other solutions, like pgEdge that I'm aware of, but I haven't used them, and I don't know how well they are actively maintained, or interact with Evergreen. If I had to go and support postgres for Evergreen again, knowing what I now know, and didn't exist before: I would use the CNPG [1], on a Kubernetes cluster, for it's automated failover [2]. I expect many library orgs don't have significant Kubernetes experience, so this might be an insurmountable amount of work, so the relative complexity outweights the benefits. [1] https://github.com/cloudnative-pg/cloudnative-pg [2] https://cloudnative-pg.io/documentation/1.20/failover/ [3] https://github.com/evergreen-library-system/Evergreen/blob/659a3753c2ca3c9c7d485c358d19aaffa7fd9f41/Open-ILS/src/sql/Pg/create_database_extensions.sql#L19-L26 -- Robin Hugh Johnson (they/he) Gentoo Linux: Dev, Infra Lead, Foundation Treasurer E-Mail : [email protected] GnuPG FP : 11ACBA4F 4778E3F6 E4EDF38E B27B944E 34884E85 GnuPG FP : 7D0B3CEB E9B85B1F 825BCECF EE05E6F6 A48F6136 _______________________________________________ Evergreen-dev mailing list -- [email protected] To unsubscribe send an email to [email protected]
