/[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.2 by dpavlin, Sun Nov 2 13:19:24 2003 UTC revision 1.3 by dpavlin, Sun Nov 2 21:07:17 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 || exit 1  $dir/bin/MultiMasterInit -d -v -v master slave || exit 1
16    
17  psql -c "create table t1 (i int, t text, d timestamp default 'now');" master  psql -e -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 -e -c "create table t1 (i int, t text, d timestamp default 'now');" slave
19    
20  $dir/bin/MasterAddTable -d master t1 d || exit 1  
21  $dir/bin/MasterAddTable -d --masterserver=1 slave t1 d || exit 1  $dir/bin/MasterAddTable -d -v master t1 d || exit 1
22    $dir/bin/MasterAddTable -d -v --masterserver=1 slave t1 d || exit 1
23  $dir/bin/SlaveAddTable master t1 d || exit 1  $dir/bin/SlaveAddTable master t1 d || exit 1
24  $dir/bin/SlaveAddTable slave t1 d || exit 1  $dir/bin/SlaveAddTable slave t1 d || exit 1
25    
26  psql -c "insert into t1 values (1, 'one insert master');" master  psql -e -c "insert into t1 values (1, 'one insert master');" master
27  psql -c "insert into t1 values (2, 'two insert master');" master  psql -e -c "insert into t1 values (2, 'two insert master');" master
28  psql -c "insert into t1 values (101, '101 insert on slave');" slave  psql -e -c "insert into t1 values (101, '101 insert on slave');" slave
29    
30    if [ "$1" = "stop" ] ; then
31            exit
32    fi
33    
34    $dir/bin/Replicate -d -v --multimaster slave master || exit 1
35    #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
36    echo "slave -> master over"
37    
38  $dir/bin/Replicate -d master slave || exit 1  $dir/bin/Replicate -d -v --multimaster master slave || exit 1
39  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1  #$dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
40  echo "master -> slave over"  echo "master -> slave over"
41    
42  $dir/bin/Replicate -d --multiplemaster slave master || exit 1  $dir/bin/Replicate -d -v --multimaster slave master || exit 1
43  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1  #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
44  echo "slave -> master over"  echo "slave -> master over"
45    
46  psql -c "insert into t1 values (3, 'three insert on master');" master  psql -e -c "insert into t1 values (3, 'three insert on master');" master
47  psql -c "insert into t1 values (4, 'four insert on slave');" master  psql -e -c "insert into t1 values (4, 'four insert on slave');" master
48  psql -c "delete from t1 where i=1;" master  psql -e -c "delete from t1 where i=1;" master
49  psql -c "update t1 set t='two, updated on master' where i=2;" master  psql -e -c "update t1 set t='two, updated on master' where i=2;" master
50    
51  # conflicts  # conflicts
52  psql -c "delete from t1 where i=1;" slave  #psql -e -c "delete from t1 where i=1;" slave
53  psql -c "update t1 set t='two, updated on slave' where i=2;" slave  #psql -e -c "update t1 set t='two, updated on slave' where i=2;" slave
54    
55  $dir/bin/Replicate -d --multiplemaster master slave || exit 1  $dir/bin/Replicate -d -v --multimaster master slave || exit 1
56  $dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1  #$dir/bin/MasterSync master `$dir/bin/GetSyncID --noverbose slave` || exit 1
57  echo "master -> slave over"  echo "master -> slave over"
58    
59  $dir/bin/Replicate -d --multiplemaster slave master || exit 1  $dir/bin/Replicate -d -v --multimaster slave master || exit 1
60  $dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1  #$dir/bin/MasterSync --slaveserver=1 slave `$dir/bin/GetSyncID --noverbose master` || exit 1
61  echo "slave -> master over"  echo "slave -> master over"
62    
63    $dir/bin/Replicate -d -v --multimaster master slave || exit 1
64    $dir/bin/Replicate -d -v --multimaster slave master || exit 1
65    
66  exit  exit
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.26