Preparing the Network Environment

You must prepare the network environment for each database server in an Enterprise Replication domain.

The following files are involved in configuring the replication network:

  • sqlhosts: Specifies replication connectivity, including server groups, connection security, and network security.
  • hosts: Specifies hosts names if you are not using Domain Name Service (DNS).
  • services: Specifies the service name that is associated with a port number.
  • The trusted-hosts file. You specify this file by setting the REMOTE_SERVER_CFG configuration parameter. This file specifies the host names for trusted replication servers.
  • If you use Connection Managers for managing connectivity, you must create a Connection Manager configuration file.

You can manually specify sqlhost and trusted-host file information to each database server, or you can run the admin() or task() function with the cdr add trustedhost argument to add entries to the trusted host files, and then run the cdr autoconfig serv command to propagate sqlhost and trusted-host file entries to other database servers in an Enterprise Replication domain.

To prepare your network environment, configure the following for each replication server:

  1. If you are not using DNS, configure replication-server host information in the hosts file.
  2. Configure port information in the services files and the sqlhosts files.
  3. Create group entries for each replication servers in the sqlhosts file.
  4. If necessary, configure secure ports for replication servers in the sqlhosts file.
  5. If necessary, configure network security for client/server communications in the sqlhosts files.
  6. Create a trusted-host file and add entries for each trusted hosts.

Copyright© 2018 HCL Technologies Limited