[EP-tech] upgrading from MySQL 5.7

[Tomasz.Neugebauer at concordia.ca (Tomasz Neugebauer)]

CAUTION: This e-mail originated outside the University of Southampton.
Hi everyone!

I will need to upgrade our database sometime soon, as we are currently running on MySQL5.7
We are on EPrints 3.4.3.

Has anyone been through the process of upgrading the DB recently?
Do you have any comments/recommendations based on how it went?
What would be the optimal upgrade path for the DB, should we upgrade with MySQL 8 or perhaps switch over to MariaDB (10.11 LTS)?

David kindly shared with me the following two issues
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fissues%2F196&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9235f3a26b6e4fa64e5408db58a8f72f%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638201254943955292%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=XPrkyJiyGXHkyv2kLWO1sL7PWznfB7iPMe6hIDxKQs4%3D&reserved=0
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fissues%2F247&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C9235f3a26b6e4fa64e5408db58a8f72f%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638201254943955292%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=42Eg3CTlNUGUOtLaeO1EzG3%2BZ25uUqGmcMRwNbpRGX0%3D&reserved=0

(thank you!)

Tomasz




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20230519/fbe7880c/attachment.html