Actions on RHEL 9 Machine

To migrate from the RHEL 7, follow the below preparatory steps in RHEL 9 machine.

To migrate from the RHEL 7:

1. Install SVM in RHEL 8 box. For more information, see RHEL 9.
2. Create admin migration user using the below commands

GRANT ALL PRIVILEGES ON *.* TO 'mig_admin'@'%' IDENTIFIED BY 'MIG_ADMIN' WITH GRANT OPTION;

FLUSH PRIVILEGES;

3. Add the below entries in /etc/my.cnf to [mysqld] section and restart MariaDB server to apply the new settings:

net_read_timeout=1000

connect_timeout=1000

On terminal: systemctl restart mariadb.service

4. Using the below command, try connecting to RHEL 7 using mig_admin user from the new RHEL 9:

mysql –umig_admin –pMIG_ADMIN -h<RHEL7IP>

5. Using the below command, try connecting to RHEL 9 from RHEL 7:

mysql –umig_admin –pMIG_ADMIN -h<RHEL9 IP>

6. Stop the services, using the below commands:

systemctl stop sgdaemon.service

systemctl stop scandaemon.service

systemctl stop haproxy.service

7. Drop the common and private databases (RHEL 9) using the below commands:

DROP DATABASE ca;

DROP DATABASE ca_; (Private database starts with ca_)

8. Drop the private db mysql users (which starts with customer id) using the below commands:

DROP USER '<cust_id*>'@'localhost'

FLUSH PRIVILEGES;