diff options
author | unknown <tomas@poseidon.ndb.mysql.com> | 2006-04-12 15:56:29 +0200 |
---|---|---|
committer | unknown <tomas@poseidon.ndb.mysql.com> | 2006-04-12 15:56:29 +0200 |
commit | af78db58351cf849c31c56da097577bff102f674 (patch) | |
tree | 34e305c5e42008803074bcc71f3360daa0e5f599 | |
parent | 2a07ed96102c2ae8686e4454921ddbb247bcbfa3 (diff) | |
download | mariadb-git-af78db58351cf849c31c56da097577bff102f674.tar.gz |
new files
mysql-test/include/master-slave-end.inc:
New BitKeeper file ``mysql-test/include/master-slave-end.inc''
mysql-test/include/ndb_setup_slave.inc:
New BitKeeper file ``mysql-test/include/ndb_setup_slave.inc''
-rw-r--r-- | mysql-test/include/master-slave-end.inc | 6 | ||||
-rw-r--r-- | mysql-test/include/ndb_setup_slave.inc | 27 |
2 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/include/master-slave-end.inc b/mysql-test/include/master-slave-end.inc new file mode 100644 index 00000000000..74e4c7b608a --- /dev/null +++ b/mysql-test/include/master-slave-end.inc @@ -0,0 +1,6 @@ +--connection master +--sync_slave_with_master +--connection slave +--disable_query_log +STOP SLAVE; +--enable_query_log diff --git a/mysql-test/include/ndb_setup_slave.inc b/mysql-test/include/ndb_setup_slave.inc new file mode 100644 index 00000000000..b1efeded90b --- /dev/null +++ b/mysql-test/include/ndb_setup_slave.inc @@ -0,0 +1,27 @@ +# +# now setup replication to continue from last epoch +# 1. get apply_status epoch from slave +# 2. get corresponding _next_ binlog postition from master +# 3. change master on slave + +# 1. +--connection slave +--replace_column 1 <the_epoch> +SELECT @the_epoch:=MAX(epoch) FROM cluster.apply_status; +--let $the_epoch= `select @the_epoch` + +# 2. +--connection master +--replace_result $the_epoch <the_epoch> +--replace_column 1 <the_pos> +eval SELECT @the_pos:=Position,@the_file:=SUBSTRING_INDEX(FILE, '/', -1) + FROM cluster.binlog_index WHERE epoch > $the_epoch ORDER BY epoch ASC LIMIT 1; +--let $the_pos= `SELECT @the_pos` +--let $the_file= `SELECT @the_file` + +# 3. +--connection slave +--replace_result $the_pos <the_pos> +eval CHANGE MASTER TO + master_log_file = '$the_file', + master_log_pos = $the_pos ; |