How Can I Avoid Issues While Migrating the HVR 6 Hub Server and Repository?

Question

I want to migrate the HVR Hub Server and repository to a new server while ensuring:

• A successful cutover
• Minimal downtime
• No data integrity issues

How can I do this safely?

Environment

HVR 6

Answer

Prepare for the migration

1. Export the Hub Server configuration.

   i. On the current Hub Server, run the following hvrhubserverconfig command:

   hvrhubserverconfig -o hub_props_server.json
   

   ii. Securely store the generated hub_props_server.json file.

2. Suspend jobs and stop services.

   i. Suspend all HVR Capture jobs.

   ii. Wait until Integrate jobs finish processing router files, then suspend them.

   iii. Stop the HVR Hub service.

   iv. Stop all HVR Agents on agent servers.

3. Use the hvrsnapshotrestore command to export the Hub definition and create a snapshot.

4. Create backups.

   i. Take a snapshot of the Hub Server VM (System Administrator).

   ii. Back up the HVR repository database (Database Administrator).

Migrate the Hub server and repository

1. Transfer and prepare the environment.

   i. Move the landing zone, Hub configuration, and repository database to the new server.

   ii. Verify that no active HVR sessions or processes are running.

2. Start core services.

   i. Start the HVR Hub Server.

   ii. Start the repository database.

   iii. Validate network connectivity between the Hub, the repository database, all source and target systems, and Fivetran.

Validate and resume replication

1. Prepare the repository database.

   i. Confirm that the repository database is running on the new server.

   ii. Keep the Hub service down until you've validated the configuration.

2. Apply the Hub configuration.

   i. Ensure the Hub configuration file is in place:

   $HVR_CONFIG/etc/hvrhubserver.conf
   

   ii. Run the following:

   hvrhubserverconfig -V @key_file -o hub_props_server.json
   hvrhubserverconfig -a -V @key_file -i hub_props_server.json
   

3. Restart services and jobs.

   i. Start the HVR Hub service.

   ii. Review the Hub Server logs to confirm connectivity:

   $HVR_CONFIG/logs/hvrhubserver.out
   

   iii. Log in to the HVR web UI, activate all channels, and start all Capture and Integrate jobs.

4. Monitor the system.

   i. Monitor job statuses in the HVR web UI.

   ii. Review logs for errors and confirm expected latency levels.