Adding an RS secondary to a cluster

About this task

Let us add an RS node to our cluster.

Procedure

  1. Prepare the SQLHOSTS files
    All servers in the cluster must have SQLHOSTS entries for all others.
    g_mach11  group     -         -          i=10 myprim    ontlitcp 
            primhost  prim_port  g=g_mach11 hdr       ontlitcp  hdrhost   hdr_port  
          g=g_mach11 sds1      ontlitcp  sds1host 
            sds1_port  g=g_mach11 rss1      ontlitcp 
            rss1host  rss1_port  g=g_mach11
  2. On the primary, enable index page logging 
    onmode -wf LOG_INDEX_BUILDS=1
  3. On the primary, register the new RS secondary 
    onmode -d add RSS rss1
  4. Bring the RS secondary into online mode

    onmode -d RSS myprim

    Now RSS node is up and running! Run the onstat -g rss command to check RSS node status at both primary and RSS nodes. Now our cluster looks like this:
    Figure 1: The cluster: Primary and one SD secondary