TimesTen reconstruction of the backup machine standard operation [TimesTen O & M]
During TimesTen's O & M process, rebuilding the slave is the most frequently performed operation in daily O & M. Here we record the operation steps for rebuilding the slave, Which is easy for beginners to refer.
1. comment out the scheduled task script
$ Crontab-e
: % S/^/#/g
2. Check master-slave Synchronization
Ttisql-connstr
Command> call ttbookmark;
Command> call ttbookmark;
3. Stop the master node replication process
Ttisql-connstr-v 1-e "call ttrepstop; bye ;"
4. Check the TT status and the role of the Operation node.
Ttstatus
Ttisql-connstr-v 1-e "call ttrepstateget; bye;" -- confirm the standby role standby
5. Stop and delete the slave
$ Ttadmin-cachestop
$ Ps-fu timesten --- query all application processes and monitoring processes and kill them.
Command> call ttckpt; --- Perform two checkpoints
Command> call ttckpt;
$ Ttadmin-ramunload --- unload DSN
$ Ttstatus
$ Ttdestroy --- Delete DSN
$ Ttdestroy-force --- Delete the DSN. The Data Store containing the Cache Group needs to add the force parameter. Or, delete all Cache groups according to the normal operation.
6. Check the shared memory.
$ Ttdaemonadmin-stop -- if the standby machine only has a DSN, the Daemon process is stopped. If one instance has multiple datastores, skip this step.
$ Ps-fu timesten
$ Ipcs-a | grep timesten
7. Rebuild the backup server
Start the replication process on the master node
Ttisql-connstr-v 1-e "call ttrepstart; bye ;"
$ Ttdaemonadmin-start
Nohup $ {TT_HOME}/bin/ttRepAdmin \
-Duplicate-from $ {STORENAME}-host $ {ACTIVEHOST }\
-SetMasterRepStart-ramLoad-delXla \
-UID $ {UID}-PWD $ {PWD }\
-Compression 0-verbosity 2 \
-KeepCG-cacheUid $ {CACHEUID}-cachePwd $ {CACHEPWD }\
-Localhost $ {STANDBYHOST }\
-ConnStr "dsn = $ DSN; uid = $ UID; pwd = $ PWD "\
> Nohup. log
# ACTIVEHOST = master node Host Name
# STANDBYHOST = backup node Host Name
# STORENAME = DS file prefix
# UID = database username. Here, timesten is generally used, and tt7.x. x is used to manage users in the database. The admin permission is required.
# PWD = Password
# CACHEUID = the management user of the Cache Group. tt7.x. x is generally the same as the above user.
# CACHEPWD = the administrator password of the Cache Group.
8. Check the Memory loading policy.
Command> host ttadmin-query # generally set to manual, ttadmin-rampolicy manual $ DSN;
9. Start the replication process and CacheAgent Process
$ Ttadmin-cachestop
$ Ttadmin-repstop --- start all master and slave nodes
10. Check the running status and node role
$ Ttstatus
Command> call ttrepstateget;
10. Set that the memory is not loaded automatically. If the TT is loaded automatically, it may cause memory depletion.
$ Ttadmin-noautoreload
$ Ttstatus-debug | grep-I auto -- check whether the setting is successful
11. Check whether the TT memory library runs normally. enable monitoring, notify the developer of the application and check the application.
Precautions for rebuilding the backup server
A. check whether a Daemon runs multiple DSN instances.
B. Check whether the shared memory segments are normally released to avoid loading two memories.
C. You can run ttstatus multiple times during the operation, which helps to determine the time and ensure that the machines to be operated are correct.