/[rserv]/misc/regress-mm.sh
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /misc/regress-mm.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by dpavlin, Fri Oct 31 01:01:09 2003 UTC revision 1.2 by dpavlin, Sun Nov 2 13:19:24 2003 UTC
# Line 12  dropdb slave Line 12  dropdb slave
12  createdb master || exit 1;  createdb master || exit 1;
13  createdb slave || exit 1;  createdb slave || exit 1;
14    
15  $dir/bin/MultiMasterInit -d -v master slave  $dir/bin/MultiMasterInit -d -v master slave || exit 1
16    
17  psql -c "create table t1 (i int, t text, d timestamp default 'now');" master  psql -c "create table t1 (i int, t text, d timestamp default 'now');" master
18  psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave  psql -c "create table t1 (i int, t text, d timestamp default 'now');" slave
19    
20  $dir/bin/MasterAddTable -d master t1 d  $dir/bin/MasterAddTable -d master t1 d || exit 1
21  $dir/bin/MasterAddTable -d --masterserver=1 slave t1 d  $dir/bin/MasterAddTable -d --masterserver=1 slave t1 d || exit 1
22  $dir/bin/SlaveAddTable master t1 d  $dir/bin/SlaveAddTable master t1 d || exit 1
23  $dir/bin/SlaveAddTable slave t1 d  $dir/bin/SlaveAddTable slave t1 d || exit 1
24    
25  psql -c "insert into t1 values (1, 'one insert master');" master  psql -c "insert into t1 values (1, 'one insert master');" master
26  psql -c "insert into t1 values (2, 'two insert master');" master  psql -c "insert into t1 values (2, 'two insert master');" master
27  psql -c "insert into t1 values (101, '101 insert on slave');" slave  psql -c "insert into t1 values (101, '101 insert on slave');" slave
28    
29  $dir/bin/Replicate -d master slave  $dir/bin/Replicate -d master slave || exit 1
30  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
31  echo "master -> slave over"  echo "master -> slave over"
32    
33  $dir/bin/Replicate -d --multiplemaster slave master  $dir/bin/Replicate -d --multiplemaster slave master || exit 1
34  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master`  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
35  echo "slave -> master over"  echo "slave -> master over"
36    
37  psql -c "insert into t1 values (3, 'three insert on master');" master  psql -c "insert into t1 values (3, 'three insert on master');" master
# Line 43  psql -c "update t1 set t='two, updated o Line 43  psql -c "update t1 set t='two, updated o
43  psql -c "delete from t1 where i=1;" slave  psql -c "delete from t1 where i=1;" slave
44  psql -c "update t1 set t='two, updated on slave' where i=2;" slave  psql -c "update t1 set t='two, updated on slave' where i=2;" slave
45    
46  $dir/bin/Replicate -d --multiplemaster master slave  $dir/bin/Replicate -d --multiplemaster master slave || exit 1
47  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave`  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
48  echo "master -> slave over"  echo "master -> slave over"
49    
50  $dir/bin/Replicate -d --multiplemaster slave master  $dir/bin/Replicate -d --multiplemaster slave master || exit 1
51  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master`  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
52  echo "slave -> master over"  echo "slave -> master over"
53    
54  exit  exit
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.26