Step 4, 查看replication 的状态
1,A机器:
$ ttRepAdmin -showstatus fxtest_aa
Replication Agent Status as of: 2008-08-18 15:49:46
DSN : fxtest_aa
Process ID : 18411 (Started)
Replication Agent Policy : manual
Host : BJINMS216.BJ.COM
RepListener Port : 59916 (AUTO)
Last write LSN : 0.823656
Last LSN forced to disk : 0.823656
Replication hold LSN : 0.819456
Replication Peers:
Name : FXTEST_BB
Host : BJINMS221.BJ.COM
Port : 60934 (AUTO) (Connected)
Replication State : STARTED
Communication Protocol : 23
TRANSMITTER thread(s):
For : FXTEST_BB
Start/Restart count : 1
Send LSN : 0.821280
Transactions sent : 0
Total packets sent : 19
Tick packets sent : 15
MIN sent packet size : 64
MAX sent packet size : 152
AVG sent packet size : 69
Last packet sent at : 15:49:37
Total Packets received: 19
MIN rcvd packet size : 64
MAX rcvd packet size : 120
AVG rcvd packet size : 109
Last packet rcvd'd at : 15:49:37
RECEIVER thread(s):
For : FXTEST_BB
Start/Restart count : 1
Transactions received : 0
Total packets sent : 19
Tick packets sent : 0
MIN sent packet size : 64
MAX sent packet size : 120
AVG sent packet size : 109
Last packet sent at : 15:49:45
Total Packets received: 19
MIN rcvd packet size : 64
MAX rcvd packet size : 152
AVG rcvd packet size : 69
Last packet rcvd'd at : 15:49:45
2,B机器:
bjinms221.bj.com> ttRepAdmin -showstatus fxtest_bb
Replication Agent Status as of: 2008-08-18 16:02:59
DSN : fxtest_bb
Process ID : 13820 (Started)
Replication Agent Policy : manual
Host : BJINMS221.BJ.COM
RepListener Port : 60934 (AUTO)
Last write LSN : 0.844184
Last LSN forced to disk : 0.844184
Replication hold LSN : 0.839984
Replication Peers:
Name : FXTEST_AA
Host : BJINMS216.BJ.COM
Port : 59916 (AUTO) (Connected)
Replication State : STARTED
Communication Protocol : 23
TRANSMITTER thread(s):
For : FXTEST_AA
Start/Restart count : 1
Send LSN : 0.841808
Transactions sent : 0
Total packets sent : 29
Tick packets sent : 25
MIN sent packet size : 64
MAX sent packet size : 152
AVG sent packet size : 67
Last packet sent at : 16:02:54
Total Packets received: 29
MIN rcvd packet size : 64
MAX rcvd packet size : 120
AVG rcvd packet size : 112
Last packet rcvd'd at : 16:02:54
RECEIVER thread(s):
For : FXTEST_AA
Start/Restart count : 1
Transactions received : 0
Total packets sent : 30
Tick packets sent : 0
MIN sent packet size : 64
MAX sent packet size : 120
AVG sent packet size : 113
Last packet sent at : 16:02:56
Total Packets received: 30
MIN rcvd packet size : 64
MAX rcvd packet size : 152
AVG rcvd packet size : 67
Last packet rcvd'd at : 16:02:56
Step 5, 检查replication是否正常工作
1,检查 fxtest_aa 复制到 fxtest_bb
A机器:
Command> insert into reptable values(1,'Tom');
1 row inserted.
Command> commit;
B机器:
Command> select * from reptable;
< 1, Tom >
1 row found.
2,检查fxtest_bb 复制到 fxtest_aa
B机器:
Command> insert into reptable values(2,'Jerry');
1 row inserted.
Command> commit;
A机器:
Command> select * from reptable;
< 1, Tom >
< 2, Jerry >
2 rows found.
Step6, 修改replication, Datastore 属性,
设置为自动启动
A机器:
$ ttAdmin -repPolicy always fxtest_aa
RAM Residence Policy : inUse
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
$ ttAdmin -ramPolicy always fxtest_aa
RAM Residence Policy : always
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
B机器:
bjinms221.bj.com> ttAdmin -repPolicy always fxtest_bb
RAM Residence Policy : inUse
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
bjinms221.bj.com> ttAdmin -ramPolicy always fxtest_bb
RAM Residence Policy : always
Replication Agent Policy : always
Cache Agent Policy : manual
Cache Agent Manually Started : False
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81/viewspace-429796/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81/viewspace-429796/