EPrints Technical Mailing List Archive

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

Message: #08400

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

Re: [EP-tech] solved: Debian9 full-upgrade to Debian10 likes to remove eprints

  • To: <th.lauke@arcor.de>
  • Subject: Re: [EP-tech] solved: Debian9 full-upgrade to Debian10 likes to remove eprints
  • From: David R Newman <drn@ecs.soton.ac.uk>
  • Date: Tue, 15 Dec 2020 11:52:26 +0000
Hi Thomas,
It would be interesting to know what trouble MySQL 8.0 introduces.  One of my colleagues is keen to upgrade MariaDB databases for repositories to 10.x.  There are a few steps required to do this, so I would not advise doing this unless you know what you are doing and have a backup of the database just in case.  I am not aware of any issues that upgrading to MariaDB 10.x would introduce as long as the upgrade and guided [1] conversion of the databases (to be 10.x compatibility) is successful.
Although MySQL 8.0 and MariaDB 10.x are different beasts, I led to understand a lot of the developments are quite similar (although maybe how they have been implement is somewhat different).  Therefore, any issues you experience with MySQL 8.0 would be useful to know to see if similar issues may exist with MariaDB 10.x.  My colleague and I have already done some database upgrades on test repositories and found no significant issues but it useful to spread your net wide to gather any potential issues before upgrading live production servers. 

Regards

David Newman

[1] https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmariadb.com%2Fkb%2Fen%2Fupgrading-from-mariadb-55-to-mariadb-100%2F&amp;data=04%7C01%7C%7C6591a141b48244d97d2f08d8a0efe5bf%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637436299488820656%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=EQe6a%2FrH04%2Frq%2F0%2FDVdrRadBJ%2BKGapgGNrr%2FMddcyE0%3D&amp;reserved=0

On 15/12/2020 11:33, th.lauke@arcor.de wrote:

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

Hi David,


It would be useful for clarity if you could detail the exact steps that you had to take ...

yes, for sure, after passing the final goal ... and successful reproduction on our production server;
fortunately `script` helps :)

although I reached my initial goal, I'm still not satisfied, because I couldn't imagine to have discovered the most straight way ... thus I will have another try on our next server ...!
In the meantime following findings:
Keep an eye on mysql-server!
Stick to mysql-server 5.7, because 8.0 introduces some more trouble!


adding MySQL's own APT repository so that it continue to exist according to your operating system ...

obviously mariaDB has to be deactivated in order to allow mysql the operation!

now it's done, but the deinstallation seems to be at first incomplete, i.e. has to be fixed manually :(
As promised, details will follow ... when everything is more clear!

Many thanks for your assistance
Thomas


--
This email has been checked for viruses by AVG.
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.avg.com%2F&amp;data=04%7C01%7C%7C6591a141b48244d97d2f08d8a0efe5bf%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637436299488820656%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=qkSvR%2BWyrgxZmGSjZnl1pGrGBIf05Nh5zAiy9VAoOJ0%3D&amp;reserved=0