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

martin.braendle at id.uzh.ch martin.braendle at id.uzh.ch
Tue Feb 19 11:28:58 GMT 2019


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

Best regards,


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


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?



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: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C4a23d297e4fa404b05c808d6965d7397%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=9LhCJF4tJSyrBPSfxVPxH4xlBpZRsz3%2FbNv1HyQGIEg%3D&amp;reserved=0
*** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C4a23d297e4fa404b05c808d6965d7397%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Rws2zlTUhYXWA1asJBwKBfHVTwlQV2%2BsyMVpgTzBTkE%3D&amp;reserved=0
*** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C4a23d297e4fa404b05c808d6965d7397%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=yHQJe836PUY1AeEnyLEp8FTgFHDe0zOcxo3FWbzVeH8%3D&amp;reserved=0

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20190219/915887ff/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20190219/915887ff/attachment.gif 

More information about the Eprints-tech mailing list