5.12.2. Reset All Sites in a Multisite/Multimaster topology

To reset all of the dataservices and restart the Tungsten Clustering and Tungsten Replicator services:

  1. Put the both dataservices into MAINTENANCE mode. This ensures that Tungsten Clustering will not attempt to automatically recover the service.

    cctrl [east]> set policy maintenance
    cctrl [west]> set policy maintenance
  2. Put the Tungsten Connector for both dataservices offline:

    cctrl [east]> router * offline
    cctrl [west]> router * offline
  3. Stop the services on each server in the east region (east{1,2,3}):

    shell east> /opt/continuent/tungsten/cluster-home/bin/stopall
    shell east> /opt/replicator/tungsten/cluster-home/bin/stopall
  4. Stop the services on each server in the west region (west{1,2,3}):

    shell west> /opt/continuent/tungsten/cluster-home/bin/stopall
    shell west> /opt/replicator/tungsten/cluster-home/bin/stopall
  5. Reset the cluster on east{1,2,3}:

    shell east> /opt/continuent/tungsten/tools/tpm reset
    shell east> /opt/replicator/tungsten/tools/tpm reset
  6. Reset the cluster on west{1,2,3}:

    shell west> /opt/continuent/tungsten/tools/tpm reset
    shell west> /opt/replicator/tungsten/tools/tpm reset
  7. Reset the replication services on east{1,2,3}:

    shell east> /opt/continuent/tungsten/tungsten-replicator/bin/replicator start offline
    shell east> /opt/continuent/tungsten/tungsten-replicator/bin/trepctl -service east reset -all -y
    shell east> /opt/replicator/tungsten/tungsten-replicator/bin/replicator start offline
    shell east> /opt/replicator/tungsten/tungsten-replicator/bin/trepctl -service west reset -all -y
  8. Reset the replication services on west{1,2,3}:

    shell west> /opt/continuent/tungsten/tungsten-replicator/bin/replicator start offline
    shell west> /opt/continuent/tungsten/tungsten-replicator/bin/trepctl -service west reset -all -y
    shell east> /opt/replicator/tungsten/tungsten-replicator/bin/replicator start offline
    shell east> /opt/replicator/tungsten/tungsten-replicator/bin/trepctl -service east reset -all -y
  9. Restart the services on each server in the east region (east{1,2,3}):

    shell east> /opt/continuent/tungsten/cluster-home/bin/startall
  10. Restart the services on each server in the west region (west{1,2,3}):

    shell west> /opt/continuent/tungsten/cluster-home/bin/startall
  11. Place all the Tungsten Replicator services on east{1,2,3} back online:

    shell east> /opt/replicator/tungsten/tungsten-replicator/bin/trepctl -service west online
  12. Place all the Tungsten Replicator services on west{1,2,3} back online:

    shell west> /opt/replicator/tungsten/tungsten-replicator/bin/trepctl -service east online