The procedures in this section are designed for the Multi-Site/Active-Active topology ONLY. Do NOT use these procedures for Composite Active/Active Clustering uing v6 onwards.
For version 6.x onwards, Composite Active/Active Clustering, please refer to Section 3.3, “Deploying Composite Active/Active Clusters”
To perform maintenance on the dataservice, for example to update the MySQL configuration file, can be achieved in a similar sequence to that shown in Section 6.16, “Performing Database or OS Maintenance”, except that you must also restart the corresponding Tungsten Replicator service after the main Tungsten Cluster service has been placed back online.
For example, to perform maintenance on the
east service:
Put the dataservice into
MAINTENANCE mode. This
ensures that Tungsten Cluster will not attempt to automatically recover
the service.
cctrl [east]> set policy maintenanceShun the first Replica datasource so that maintenance can be performed on the host.
cctrl [east]> datasource east1 shun
Perform the updates, such as updating
my.cnf, changing schemas, or
performing other maintenance.
If MySQL configuration has been modified, restart the MySQL service:
cctrl [east]> service host/mysql restartBring the host back into the dataservice:
cctrl [east]> datasource host recoverPerform a switch so that the Primary becomes a Replica and can then be shunned and have the necessary maintenance performed:
cctrl [east]> switchRepeat the previous steps to shun the host, perform maintenance, and then switch again until all the hosts have been updated.
Set the policy back to AUTOMATIC:
cctrl> set policy automaticOn each host in the other region, manually restart the Tungsten Replicator service, which will have gone offline when MySQL was restarted:
shell> mm_trepctl onlineIn the event of a replication fault, the standard cctrl, trepctl and other utility commands in Chapter 9, Command-line Tools can be used to bring the dataservice back into operation. All the tools are safe to use.
If you have to perform any updates or modifications to the stored MySQL data, ensure binary logging has been disabled using:
mysql> SET SESSION SQL_LOG_BIN=0;Before running any commands. This prevents statements and operations reaching the binary log so that the operations will not be replicated to other hosts.