Actions on CentOS Virtual Appliance

To migrate from the Ubuntu Virtual Appliance, follow the below preparatory steps in CentOS Virtual Appliance.

To migrate from the Ubuntu Virtual Appliance:

1.

Create admin migration user using the below commands:

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

FLUSH PRIVILEGES;

2.

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

3.

Using the below command, try connecting to Ubuntu VA using mig_admin user from the new CentOS VA:

mysql –umig_admin –pMIG_ADMIN -h<ubuntu VA IP>

4.

Using the below command, try connecting to CentOS VA from Ubuntu VA:

mysql –umig_admin –pMIG_ADMIN -h<Centos VA IP>

Note:Make sure both the servers can connect each other, if any issue found in MySQL connection then check /etc/mysql/my.cnf file and comment # bind-address 127.0.0.0 (or) change the bind address to 0.0.0.0.

5.

Stop the services, using the below commands:

systemctl stop sgdaemon.service

systemctl stop scandaemon.service

systemctl stop haproxy.service

6.

Drop the common and private databases (Centos VA) using the below commands:

DROP DATABASE ca;

DROP DATABASE ca_; (Private database starts with ca_)

7.

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

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

FLUSH PRIVILEGES;