############################################################# # Author: JBM # Date: 2006-02-24 # Purpose: Trying to test ability to replicate from cluster # to innodb, or myisam, or replicate from innodb/myisam to # cluster slave. Due to limitations I have created wrappers # to be able to use the same code for all these different # test and to have control over the tests. ############################################################## -- source include/have_ndb.inc # Since the master generates row-based events, the slave must be in # ROW or MIXED mode to accept the events. -- source include/have_binlog_format_mixed_or_row.inc -- source include/master-slave.inc -- connection slave # Remove any old ndb_apply_status from slaves datadir let $datadir= `SELECT @@datadir`; --error 0,1 remove_file $datadir/mysql/ndb_apply_status.frm; --error 0,1 remove_file $datadir/mysql/ndb_apply_status.ndb; set @@global.slave_exec_mode= 'IDEMPOTENT'; CREATE TABLE mysql.ndb_apply_status ( server_id INT UNSIGNED NOT NULL, epoch BIGINT UNSIGNED NOT NULL, log_name VARCHAR(255) BINARY NOT NULL, start_pos BIGINT UNSIGNED NOT NULL, end_pos BIGINT UNSIGNED NOT NULL, PRIMARY KEY USING HASH (server_id)) ENGINE=MYISAM; --source extra/rpl_tests/rpl_ndb_2multi_eng.test set @@global.slave_exec_mode= DEFAULT; --connection slave drop table mysql.ndb_apply_status;