EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #09317

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

I've been upgrading our servers in recent months (feels like years) and we currently have MySQL 8.0.33 with Ubuntu 20.04 and don't have any problems I'm aware of. Unless there are gremlins in there waiting to be found in the future...

Thanks,
James

On Tue, May 23, 2023 at 2:44 PM Tomasz Neugebauer via Eprints-tech <eprints-tech@ecs.soton.ac.uk> wrote:
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/
*** 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/