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

[drn at ecs.soton.ac.uk (David R Newman)]

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&data=04%7C01%7C%7C6591a141b48244d97d2f08d8a0efe5bf%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637436299488820656%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=EQe6a%2FrH04%2Frq%2F0%2FDVdrRadBJ%2BKGapgGNrr%2FMddcyE0%3D&reserved=0

On 15/12/2020 11:33, th.lauke at 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&data=04%7C01%7C%7C6591a141b48244d97d2f08d8a0efe5bf%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637436299488820656%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=qkSvR%2BWyrgxZmGSjZnl1pGrGBIf05Nh5zAiy9VAoOJ0%3D&reserved=0