EPrints Technical Mailing List Archive

Message: #07709

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

[EP-tech] Antwort: EPrints and MariaDB / MaxScale

Hi,

just to follow up: We let turn off the distribution of queries by the MaxScale load balancer and now everything works fine.

It seemed that the EPrints application was faster than the sync process between master and slave server. Cache table was written to master and Eprints tried to query the cache table from slave before it was synced from master.

Best regards,

Martin



Inactive hide details for "martin.braendle--- via Eprints-tech" ---07.02.2019 09:50:09---Hi, we had recently migrated our test "martin.braendle--- via Eprints-tech" ---07.02.2019 09:50:09---Hi, we had recently migrated our test environment to a MariaDB Master/Slave

Von: "martin.braendle--- via Eprints-tech" <eprints-tech@ecs.soton.ac.uk>
An: "Eprints Tech" <eprints-tech@ecs.soton.ac.uk>
Datum: 07.02.2019 09:50
Betreff: [EP-tech] EPrints and MariaDB / MaxScale
Gesendet von: eprints-tech-bounces@ecs.soton.ac.uk




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
*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/
*** EPrints developers Forum: http://forum.eprints.org/