[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[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





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



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: 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