Actions on RHEL 9 Machine

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

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;