Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_2myisam.test

raw
1 #############################################################
2 # Author: JBM
3 # Date: 2006-02-24
4 # Purpose: Trying to test ability to replicate from cluster
5 # to innodb, or myisam, or replicate from innodb/myisam to
6 # cluster slave. Due to limitations I have created wrappers
7 # to be able to use the same code for all these different
8 # test and to have control over the tests.
9 ##############################################################
10 -- source include/have_ndb.inc
11 -- source suite/ndb_rpl/ndb_master-slave.inc
12
13 # workaround for Bug #34006 binlog race for temporary ndb table
14 # - disable using temporary ndb tables
15 -- connection master
16 set ndb_table_temporary=0;
17
18 -- connection slave
19 set @@global.replica_exec_mode= 'IDEMPOTENT';
20
21 # Silence warning about MyISAM not supporting HASH index algorithm
22 # when creating mysql.ndb_apply_status
23 --disable_warnings ER_UNSUPPORTED_INDEX_ALGORITHM ONCE
24 CREATE TABLE mysql.ndb_apply_status
25 ( server_id INT UNSIGNED NOT NULL,
26 epoch BIGINT UNSIGNED NOT NULL,
27 log_name VARBINARY(255) NOT NULL,
28 start_pos BIGINT UNSIGNED NOT NULL,
29 end_pos BIGINT UNSIGNED NOT NULL,
30 PRIMARY KEY USING HASH (server_id)) ENGINE=MYISAM
31 CHARACTER SET latin1;
32
33 -- connection master
34 set new=on;
35 set default_storage_engine=ndbcluster;
36
37 --source suite/ndb_rpl/t/ndb_rpl_2multi_eng.inc
38
39 --connection slave
40 set @@global.replica_exec_mode= 'STRICT';
41 drop table mysql.ndb_apply_status;
42 --source include/rpl_end.inc