Adding an RS secondary to a cluster

About this task

Let us add an RS node to our cluster.

Procedure

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

On the primary, enable index page logging
```
onmode -wf LOG_INDEX_BUILDS=1
```
On the primary, register the new RS secondary
```
onmode -d add RSS rss1
```
Take a level 0 backup of the primary
```
ontape -s -L 0
```

On the RS secondary, restore the backup

ontape -p
  Three questions will be asked.  Answer as shown below:
   Continue restore? (y/n) y
   Do you want to back up the logs? (y/n) n
   Restore a level 1 archive (y/n) n

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