Creating replica nodes

Before you begin

Back up and restore the global data, as described in Preparing the primary for new replicas.

About this task

It is assumed that:
  1. There is an existing replication setup with a replication set, primary and replica node or nodes.
  2. The Netezza Replication Services software is installed on the new replica that you intend to add to the existing setup.

Run all the commands in the following procedure from the primary Netezza Performance Server node.

Procedure

  1. Log in to the host pod and run the nzsql command to connect to the SYSTEM database.
  2. Make sure no replicated transactions are in progress.
    select * from _v_pg_transaction where replicated;
  3. Run the following command for each replica node:
    CREATE REPLICATION NODE replset.<replicaname> ROLE
    SUBORDINATE
    where <replicaname> is the node name that you set while installing NRS on the replica.
  4. On the primary node, issue the following command to determine which databases were added for replication:
    nzreplanalyze -recoveryfile recoveryfile> -set replset
  5. Create a set of synchronized backups by issuing the following command:
    nzreplbackup -recoveryfile <recoveryfile> backup-destination>

What to do next

When you completed the procedure, initialize the replica node. Follow the instructions that are described in Initializing a replica node.