EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #07684

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] EPrints and MariaDB / MaxScale

Hi,

we had recently migrated our test environment to a MariaDB Master/Slave setup including a MariaDB MaxScale load balancer that distributes queries to the slave and master.
We observe some strange behaviour and we guess it has to do with that EPrints creates cache tables.

Before, we had a MySQL Master/Slave setup, but without load balancer. All queries were routed to the master. The slave was just used for backup. Everything worked fine for years.

Are there any experiences and recommendations with a loadbalanced database setup in the EPrints community?

Thanks,

Martin

--
Dr. Martin Brändle
Zentrale Informatik
Universität Zürich
Stampfenbachstr. 73
CH-8006 Zürich