search

oracle / centos2ol

Script and documentation to switch CentOS/Rocky Linux to Oracle Linux
https://linux.oracle.com/switch/centos/
Universal Permissive License v1.0
346 stars 84 forks source link

Convert CentOS to Oracle Linux -Mysql instance #121

Open devindya18 opened 2 years ago

devindya18 commented 2 years ago

Hello,

I have a Mysql-community instance on a server currently CentOS 8 and I want to convert it to Oracle Linux 8. Do I need to remove the repositories of mysql-community?

Thank you in advance for your reply.

Best regards, Devin

Djelibeybi commented 2 years ago

If it's MySQL 8.0, I recommend disabling the repo, migrating to Oracle Linux 8 and then installing the mysql-release-el8 RPM to enable the MySQL 8.0 repo from yum.oracle.com.

If it's a different version, then it should be fine. Backup first, though!

devindya18 commented 2 years ago

Thank you for your reply Djelibeybi .

devindya18 commented 2 years ago

I use proxysql as load balancer. However after running the centOS2OL script I lose all the data in proxysql. How can I recover the data ? Thank you in advance for your reply.

Djelibeybi commented 2 years ago

Unfortunately, I'm not familiar with ProxySQL so the best advice would be to restore that data from the backup you made before you migrated to Oracle Linux.

devindya18 commented 2 years ago

Proxysql uses sqlite database.Does the CentOS2OL script change something for SQLlite? I have to document the root cause

Djelibeybi commented 2 years ago

You would have to review all the packages that were updated between the CentOS system and Oracle Linux. The SQLite library and binaries may have been updated during that process, as they are part of the OS. We do mention that custom things like this should be backed up and restored after migration.