Pull database from other server

This feature allows you to pull the ESMC database from an existing ESMC VA running in your infrastructure. It is supported only on the ESMC Server, not on the other components (MDM, ERA Proxy 6.x). It is convenient when upgrading your ERA VA to the latest version, or if you want to migrate your ESMC VA.

validation-status-icon-warning IMPORTANT

In case of migration, you need to keep your old ESMC VA accessible in order for the hostname/IP address change policy to apply to all client computers. Otherwise, clients will not be connecting to your new ESMC VA and keep trying to connect to the old one.

Make sure that SSH is enabled on your old ESMC VA.

A database pull can only be performed when moving to a newer version or the same version of ESMC server. During the pull procedure, the database structure is updated but this process will fail when pulling to an older server. Database pull is not the recommended way of upgrading. It is recommended to upgrade via Components Upgrade task and after successful upgrade pull the database to another server if needed.

To perform database pull, follow the steps below:

1.Deploy a new ESMC VA, but do not configure it yet.

2.Open VM's console and while in the main screen, press Enter on your keyboard to Enter management mode of your newly deployed ESMC VA.

validation-status-icon-warning IMPORTANT

Type eraadmin and press Enter twice to login.

pull_db_login

3.Select Pull database from other server using the arrow keys and press Enter.

pull_db

4.Enter database root password on the remote ESMC VA you want to pull ESMC database from (your old ESMC VA). If you are using only one password on your old ESMC VA, type it here.

5.Enter connection to remote ESMC VA (SSH) - type user name (root) and your old ESMC VA host name or IP address in the following format: root@IPaddress or root@hostname

6.Type yes  if you are asked about The authenticity of host, otherwise ignore this step.

7.Type the VM password of your old ESMC VA and press Enter. The message Remote ERA Server database was backed up will be displayed when backup operations are finished.

details_hoverNOTE

The length of time needed for backup and restore operations to complete will vary depending on the size of the database.

8.Type the VM password of your old ESMC VA again. You might be asked to enter the password multiple times during copying. This depends on how long it takes to copy the database, especially if it is large.

9.Wait until the database is restored.

pull_db_interactive

10. If you are doing Upgrade, after a successful ESMC database pull, shutdown old ESMC VA to decommission it. However, we recommend that you preserve your old ESMC VA long enough to verify that the new instance is functioning properly, after which the old instance can be deleted.

11. Configure your new appliance: configuration will vary based on your reason for migration, for example, in case of:

Upgrade - configure your new VA exactly the same as your previous ESMC VA.

Migration - change configuration to suite a new domain or network properties, for example if you've moved your ESMC VA to a different network.

details_hoverNOTE

Make sure all data are preserved, all clients are connecting to your new server and your the ESMC VA behaves the same way as the previous one.