File: check_replication.sb

package info (click to toggle)
mysql-sandbox 3.2.05-1.1
  • links: PTS
  • area: main
  • in suites: forky, sid, trixie
  • size: 916 kB
  • sloc: perl: 9,878; sh: 191; makefile: 8
file content (27 lines) | stat: -rw-r--r-- 700 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
#
# Example of how to check 
# replication with a user defined test file
#

shell:
command     = make_replication_sandbox --verbose --replication_directory=rsandbox_XXXX $TEST_VERSION 
expected    = replication directory installed
msg         = replication started

sql:
path        = $SANDBOX_HOME/rsandbox_XXXX/master
query       = create table test.t1 (i int); show tables from test
expected    = t1
msg         = table created on master

sql:
path        = $SANDBOX_HOME/rsandbox_XXXX/node1
query       = show tables from test
expected    = t1
msg         = table replicated on slave1

shell:
command     = $SANDBOX_HOME/rsandbox_XXXX/stop_all
expected    = OK
msg         = replication stopped