EPrints Technical Mailing List Archive

Message: #09320

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

Re: [EP-tech] upgrading from MySQL 5.7

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

Hi Tomasz,

 

if you switch over to MariaDB – avoid load balancer and Galera cluster. EPrints is not made for that and you would run into problems due to syncing problems with the cache tables.

A simple primary/replica setup does perfectly.

 

Kind regards,

 

Martin

 

--

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

 

 

From: eprints-tech-bounces@ecs.soton.ac.uk <eprints-tech-bounces@ecs.soton.ac.uk> on behalf of Tomasz Neugebauer via Eprints-tech <eprints-tech@ecs.soton.ac.uk>
Date: Tuesday, 23 May 2023 at 15:44
To: eprints-tech@ecs.soton.ac.uk <eprints-tech@ecs.soton.ac.uk>, Yuri <yurj@alfa.it>
Subject: Re: [EP-tech] upgrading from MySQL 5.7

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

Thank you, Yuri, that is useful to know MariaDB 10.3 is working well.

Is anyone running EPrints with MySQL 8?

 

Tomasz

 

From: eprints-tech-bounces@ecs.soton.ac.uk <eprints-tech-bounces@ecs.soton.ac.uk> on behalf of Yuri via Eprints-tech <eprints-tech@ecs.soton.ac.uk>
Sent: Monday, May 22, 2023 2:56 AM
To: eprints-tech@ecs.soton.ac.uk <eprints-tech@ecs.soton.ac.uk>
Subject: Re: [EP-tech] upgrading from MySQL 5.7

 

Attention This email originates from outside the concordia.ca domain. // Ce courriel provient de l'extérieur du domaine de concordia.ca

 

 

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

Hi!

 we are using MariaDB 10.3 from the beginning (Debian default to MariaDB instead of MySQL) and we had no issues.

 The simpler method is to sql dump the database and reload it in the new installation.

Il 19/05/23 22:38, Tomasz Neugebauer via Eprints-tech ha scritto:

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://github.com/eprints/eprints3.4/issues/196
https://github.com/eprints/eprints3.4/issues/247

 

(thank you!)

 

Tomasz

 

 

 



*** 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/