To restore an entire dataservice from filesystem snapshots, the steps below should be followed. The same snapshot should be used on each host so that data on each host is the same. The following steps should be followed:
Set the dataservice into the
MAINTENANCE
policy mode:
[LOGICAL:EXPERT] /alpha > set policy maintenance
The following steps must be completed on each server before completing the next step:
Stop the Tungsten Cluster services:
shell> stopall
Stop MySQL:
shell> sudo /etc/init.d/mysql stop
Replace the MySQL data files with the filesystem or snapshot data.
Delete the THL files for each of the services that need to be reset:
shell> rm /opt/continuent/thl/alpha
/*
Start MySQL to perform maintenance on the Tungsten schemas:
shell> sudo /etc/init.d/mysql start
Delete any Tungsten service schemas:
mysql> DROP DATABASE tungsten_alpha
;
Once these steps have been executed on all the servers in the cluster, the services can be restarted.
On the current Primary, start the Tungsten Cluster services:
shell> startall
Now start the services using the same command on each of the remaining servers.