Gecko [ www.jdcpatala.org ]

Name	Size	Permission
disabled.def	919 B	-rw-r--r--
ndb_apply_status.frm	8.51 KB	-rw-r--r--
ndb_conflict_info.inc	3.79 KB	-rw-r--r--
ndb_conflict_info_epoch2.inc	3.2 KB	-rw-r--r--
ndb_conflict_info_epoch2_init....	1.33 KB	-rw-r--r--
ndb_conflict_info_init.inc	1.23 KB	-rw-r--r--
ndb_connect_to_primary.inc	160 B	-rw-r--r--
ndb_connect_to_secondary.inc	161 B	-rw-r--r--
ndb_dist_priv_check.inc	1.13 KB	-rw-r--r--
ndb_dist_priv_common.inc	6.89 KB	-rw-r--r--
ndb_dist_priv_default-master.o...	54 B	-rw-r--r--
ndb_dist_priv_default.test	975 B	-rw-r--r--
ndb_dist_priv_ndb-master.opt	54 B	-rw-r--r--
ndb_dist_priv_ndb.test	1.84 KB	-rw-r--r--
ndb_rpl_2innodb-master.opt	32 B	-rw-r--r--
ndb_rpl_2innodb-slave.opt	47 B	-rw-r--r--
ndb_rpl_2innodb.test	1.63 KB	-rw-r--r--
ndb_rpl_2multi_basic.inc	3.75 KB	-rw-r--r--
ndb_rpl_2multi_eng.inc	10.33 KB	-rw-r--r--
ndb_rpl_2myisam-master.opt	25 B	-rw-r--r--
ndb_rpl_2myisam-slave.opt	47 B	-rw-r--r--
ndb_rpl_2myisam.test	1.8 KB	-rw-r--r--
ndb_rpl_2ndb-slave.opt	58 B	-rw-r--r--
ndb_rpl_2ndb.test	858 B	-rw-r--r--
ndb_rpl_2other-slave.opt	45 B	-rw-r--r--
ndb_rpl_2other.test	2.18 KB	-rw-r--r--
ndb_rpl_add_column.test	3.81 KB	-rw-r--r--
ndb_rpl_apply_status-master.op...	28 B	-rw-r--r--
ndb_rpl_apply_status.test	1.5 KB	-rw-r--r--
ndb_rpl_auto_inc.test	4.18 KB	-rw-r--r--
ndb_rpl_bank.test	6.68 KB	-rw-r--r--
ndb_rpl_basic.test	11.65 KB	-rw-r--r--
ndb_rpl_batch.test	4.07 KB	-rw-r--r--
ndb_rpl_batch_handling.test	2.32 KB	-rw-r--r--
ndb_rpl_binlog_format_errors.t...	3.32 KB	-rw-r--r--
ndb_rpl_binlog_row_image_minim...	81 B	-rw-r--r--
ndb_rpl_binlog_row_image_minim...	293 B	-rw-r--r--
ndb_rpl_bitfield.test	8.11 KB	-rw-r--r--
ndb_rpl_blob.test	4.12 KB	-rw-r--r--
ndb_rpl_break_3_chain.cnf	1.59 KB	-rw-r--r--
ndb_rpl_break_3_chain.test	3.67 KB	-rw-r--r--
ndb_rpl_bug22045.test	2.4 KB	-rw-r--r--
ndb_rpl_bug_13440282.test	1.37 KB	-rw-r--r--
ndb_rpl_check_for_mixed.test	1014 B	-rw-r--r--
ndb_rpl_checksum.test	7.74 KB	-rw-r--r--
ndb_rpl_circular.test	4.42 KB	-rw-r--r--
ndb_rpl_circular_2ch.cnf	948 B	-rw-r--r--
ndb_rpl_circular_2ch.test	4.41 KB	-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...	183 B	-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...	11.9 KB	-rw-r--r--
ndb_rpl_circular_simplex.test	2.43 KB	-rw-r--r--
ndb_rpl_conflict_1.inc	5.15 KB	-rw-r--r--
ndb_rpl_conflict_basic.test	19.85 KB	-rw-r--r--
ndb_rpl_conflict_epoch.cnf	561 B	-rw-r--r--
ndb_rpl_conflict_epoch.inc	9.81 KB	-rw-r--r--
ndb_rpl_conflict_epoch.test	52 B	-rw-r--r--
ndb_rpl_conflict_epoch2.cnf	67 B	-rw-r--r--
ndb_rpl_conflict_epoch2.test	2.43 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_extra....	37 B	-rw-r--r--
ndb_rpl_conflict_epoch2_extra....	31.45 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_trans....	754 B	-rw-r--r--
ndb_rpl_conflict_epoch2_trans....	1.66 KB	-rw-r--r--
ndb_rpl_conflict_epoch_1.inc	18.75 KB	-rw-r--r--
ndb_rpl_conflict_epoch_ext.cnf	561 B	-rw-r--r--
ndb_rpl_conflict_epoch_ext.tes...	86 B	-rw-r--r--
ndb_rpl_conflict_epoch_extende...	868 B	-rw-r--r--
ndb_rpl_conflict_epoch_extende...	10.95 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans.c...	868 B	-rw-r--r--
ndb_rpl_conflict_epoch_trans.i...	27.77 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans.t...	58 B	-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...	868 B	-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...	92 B	-rw-r--r--
ndb_rpl_conflict_max-master.op...	28 B	-rw-r--r--
ndb_rpl_conflict_max.test	5.09 KB	-rw-r--r--
ndb_rpl_conflict_max_delete_wi...	28 B	-rw-r--r--
ndb_rpl_conflict_max_delete_wi...	4.92 KB	-rw-r--r--
ndb_rpl_conflict_old-master.op...	28 B	-rw-r--r--
ndb_rpl_conflict_old.test	5.11 KB	-rw-r--r--
ndb_rpl_conflict_read_tracking...	889 B	-rw-r--r--
ndb_rpl_conflict_read_tracking...	19.62 KB	-rw-r--r--
ndb_rpl_ctype_ucs2_def-master....	70 B	-rw-r--r--
ndb_rpl_ctype_ucs2_def.test	1.33 KB	-rw-r--r--
ndb_rpl_dd_advance.test	10.44 KB	-rw-r--r--
ndb_rpl_dd_basic.test	1.58 KB	-rw-r--r--
ndb_rpl_dd_partitions-master.o...	11 B	-rw-r--r--
ndb_rpl_dd_partitions-slave.op...	11 B	-rw-r--r--
ndb_rpl_dd_partitions.test	8.73 KB	-rw-r--r--
ndb_rpl_ddl_open_trans.test	360 B	-rw-r--r--
ndb_rpl_dist_priv.test	8.33 KB	-rw-r--r--
ndb_rpl_do_db-slave.opt	26 B	-rw-r--r--
ndb_rpl_do_db.test	1.73 KB	-rw-r--r--
ndb_rpl_do_table-slave.opt	29 B	-rw-r--r--
ndb_rpl_do_table.test	1.41 KB	-rw-r--r--
ndb_rpl_empty_epoch.test	1.12 KB	-rw-r--r--
ndb_rpl_gap_event-master.opt	24 B	-rw-r--r--
ndb_rpl_gap_event.test	2.26 KB	-rw-r--r--
ndb_rpl_get_binlog_events.inc	1.09 KB	-rw-r--r--
ndb_rpl_get_server_error_log.i...	553 B	-rw-r--r--
ndb_rpl_idempotent.test	5.72 KB	-rw-r--r--
ndb_rpl_ignore_db-master.opt	25 B	-rw-r--r--
ndb_rpl_ignore_db.test	1.27 KB	-rw-r--r--
ndb_rpl_init_rep_status.test	2.71 KB	-rw-r--r--
ndb_rpl_innodb2ndb-slave.opt	42 B	-rw-r--r--
ndb_rpl_innodb2ndb.test	714 B	-rw-r--r--
ndb_rpl_innodb_trans-slave.opt	25 B	-rw-r--r--
ndb_rpl_innodb_trans.test	1.54 KB	-rw-r--r--
ndb_rpl_last_conflict_epoch_va...	36 B	-rw-r--r--
ndb_rpl_last_conflict_epoch_va...	3.92 KB	-rw-r--r--
ndb_rpl_load.test	2.55 KB	-rw-r--r--
ndb_rpl_logging.test	3.96 KB	-rw-r--r--
ndb_rpl_mix_eng_trans.test	8.84 KB	-rw-r--r--
ndb_rpl_mix_innodb-master.opt	32 B	-rw-r--r--
ndb_rpl_mix_innodb.test	533 B	-rw-r--r--
ndb_rpl_mixed_tables-master.op...	13 B	-rw-r--r--
ndb_rpl_mixed_tables-slave.opt	61 B	-rw-r--r--
ndb_rpl_mixed_tables.test	8.35 KB	-rw-r--r--
ndb_rpl_multi.test	2.93 KB	-rw-r--r--
ndb_rpl_multi_binlog_update.cn...	1.83 KB	-rw-r--r--
ndb_rpl_multi_binlog_update.in...	6.78 KB	-rw-r--r--
ndb_rpl_multi_engine2.inc	2.56 KB	-rw-r--r--
ndb_rpl_multi_update2-slave.op...	42 B	-rw-r--r--
ndb_rpl_myisam2ndb-slave.opt	42 B	-rw-r--r--
ndb_rpl_myisam2ndb.test	890 B	-rw-r--r--
ndb_rpl_ndbapi-examples.test	996 B	-rw-r--r--
ndb_rpl_rep_error.test	14.2 KB	-rw-r--r--
ndb_rpl_rep_ignore-slave.opt	63 B	-rw-r--r--
ndb_rpl_rep_ignore.test	1.78 KB	-rw-r--r--
ndb_rpl_skip_gap_event-slave.o...	24 B	-rw-r--r--
ndb_rpl_skip_gap_event.test	2.39 KB	-rw-r--r--
ndb_rpl_slave_binlog_index.tes...	2.82 KB	-rw-r--r--
ndb_rpl_slave_conflict_role_va...	4.94 KB	-rw-r--r--
ndb_rpl_slave_lsu.cnf	57 B	-rw-r--r--
ndb_rpl_slave_lsu.test	5.87 KB	-rw-r--r--
ndb_rpl_slave_lsu_anyval.cnf	176 B	-rw-r--r--
ndb_rpl_slave_lsu_anyval.test	2.46 KB	-rw-r--r--
ndb_rpl_slave_replay.test	14.63 KB	-rw-r--r--
ndb_rpl_slave_restart.test	3.3 KB	-rw-r--r--
ndb_rpl_stm_innodb-master.opt	32 B	-rw-r--r--
ndb_rpl_stm_innodb.test	622 B	-rw-r--r--
ndb_rpl_sync.test	3.19 KB	-rw-r--r--
ndb_rpl_ui.test	2.29 KB	-rw-r--r--
ndb_rpl_ui2.test	957 B	-rw-r--r--
ndb_rpl_ui3.test	1.5 KB	-rw-r--r--
ndb_rpl_xxx_innodb.inc	6.25 KB	-rw-r--r--
ndb_slave_exec_info_init.inc	704 B	-rw-r--r--
ndb_sync_primary_to_secondary....	215 B	-rw-r--r--
ndb_sync_secondary_to_primary....	215 B	-rw-r--r--
ndb_trans_conflict_info.inc	1.71 KB	-rw-r--r--
ndb_trans_conflict_info_init.i...	1.5 KB	-rw-r--r--
ndb_trans_conflict_info_stable...	2.28 KB	-rw-r--r--
ndb_wait_for_zero_commit_ack_m...	569 B	-rw-r--r--
rpl_truncate_7ndb.test	1.78 KB	-rw-r--r--
rpl_truncate_7ndb_2.test	593 B	-rw-r--r--
select_ndb_apply_status.inc	505 B	-rw-r--r--
show_binlog_using_logname.inc	968 B	-rw-r--r--
show_mysqld_warnings.inc	780 B	-rw-r--r--
show_slave_max_replicated_epoc...	380 B	-rw-r--r--
wait_schema_logging.inc	2.33 KB	-rw-r--r--

Code Editor : ndb_rpl_mixed_tables.test

# ==== Purpose ====
#
# Test replication of transactions on tables which have different
# engines on master and slave.  This tests all combinations of innodb,
# myisam, and ndb.
#
# ==== Method ====
#
# Set up six tables, each being innodb, myisam, or innodb on master,
# and another of innodb, myisam, or innodb on slave.  For each table,
# do the following:
#
#  - committed and rollback'ed transactions, with autocommit on and
#    off
#  - non-transactions with autocommit on
#  - non-transactions with autocommit off, where the master table is
#    myisam.
#
# Note: we are running the slave with
# --replicate-ignore-table=mysql.ndb_apply_status .  See BUG#34557 for
# explanation.
#
# ==== Related bugs ====
#
# BUG#26395: if crash during autocommit update to transactional table on master, slave fails
# BUG#29288: myisam transactions replicated to a transactional slave leaves slave unstable
# BUG#34557: Row-based replication from ndb to non-ndb gives error on slave
# BUG#34600: Rolled-back punch transactions not replicated correctly
#
# ==== Todo ====
#
# We should eventually try transactions touching two tables which are
# of different engines on the same server (so that we try, e.g. punch
# transactions; cf BUG#34600).  However, that will make the test much
# bigger (9 master-slave engine combinations [myisam->myisam,
# myisam->ndb, etc].  To try all combinations of one or more such
# tables means 2^9-1=511 transactions.  We need to multiplied by 5
# since we want to test committed/rollback'ed transactions
# with/without AUTOCOMMIT, as well as non-transactions with
# autocommit).  We'd have to write a script to produce the test case.

--echo ==== Initialization ====

--source include/have_ndb.inc
--source include/have_innodb.inc
--source suite/ndb_rpl/ndb_master-slave.inc

--echo ---- setup master ----

CREATE TABLE myisam_innodb (a INT) ENGINE=MYISAM;
CREATE TABLE innodb_myisam (a INT) ENGINE=INNODB;
CREATE TABLE myisam_ndb    (a INT) ENGINE=MYISAM;
CREATE TABLE ndb_myisam    (a INT) ENGINE=NDB;
CREATE TABLE innodb_ndb    (a INT) ENGINE=INNODB;
CREATE TABLE ndb_innodb    (a INT) ENGINE=NDB;

SHOW CREATE TABLE myisam_innodb;
SHOW CREATE TABLE innodb_myisam;
SHOW CREATE TABLE myisam_ndb;
SHOW CREATE TABLE ndb_myisam;
SHOW CREATE TABLE innodb_ndb;
SHOW CREATE TABLE ndb_innodb;

--echo ---- setup slave with different engines ----

sync_slave_with_master;

DROP TABLE myisam_innodb, innodb_myisam;
DROP TABLE myisam_ndb, ndb_myisam;
DROP TABLE innodb_ndb, ndb_innodb;

CREATE TABLE myisam_innodb (a INT) ENGINE=INNODB;
CREATE TABLE innodb_myisam (a INT) ENGINE=MYISAM;
CREATE TABLE myisam_ndb    (a INT) ENGINE=NDB;
CREATE TABLE ndb_myisam    (a INT) ENGINE=MYISAM;
CREATE TABLE innodb_ndb    (a INT) ENGINE=NDB;
CREATE TABLE ndb_innodb    (a INT) ENGINE=INNODB;

SHOW CREATE TABLE myisam_innodb;
SHOW CREATE TABLE innodb_myisam;
SHOW CREATE TABLE myisam_ndb;
SHOW CREATE TABLE ndb_myisam;
SHOW CREATE TABLE innodb_ndb;
SHOW CREATE TABLE ndb_innodb;

connection master;

--echo ==== AUTOCOMMIT=0, transactions ====

--echo ---- COMMIT ----

SET AUTOCOMMIT = 0;

BEGIN;
INSERT INTO myisam_innodb VALUES (1);
INSERT INTO myisam_innodb VALUES (2);
COMMIT;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_myisam VALUES (3);
INSERT INTO innodb_myisam VALUES (4);
COMMIT;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO myisam_ndb VALUES (5);
INSERT INTO myisam_ndb VALUES (6);
COMMIT;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO ndb_myisam VALUES (7);
INSERT INTO ndb_myisam VALUES (8);
COMMIT;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO ndb_innodb VALUES (9);
INSERT INTO ndb_innodb VALUES (10);
COMMIT;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_ndb VALUES (11);
INSERT INTO innodb_ndb VALUES (12);
COMMIT;
sync_slave_with_master;
connection master;

--echo ---- ROLLBACK ----

BEGIN;
INSERT INTO myisam_innodb VALUES (13);
INSERT INTO myisam_innodb VALUES (14);
ROLLBACK;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_myisam VALUES (15);
INSERT INTO innodb_myisam VALUES (16);
ROLLBACK;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO myisam_ndb VALUES (17);
INSERT INTO myisam_ndb VALUES (18);
ROLLBACK;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO ndb_myisam VALUES (19);
INSERT INTO ndb_myisam VALUES (20);
ROLLBACK;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO ndb_innodb VALUES (21);
INSERT INTO ndb_innodb VALUES (22);
ROLLBACK;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_ndb VALUES (23);
INSERT INTO innodb_ndb VALUES (24);
ROLLBACK;
sync_slave_with_master;
connection master;

--echo ==== AUTOCOMMIT=1, transactions ====

--echo ---- COMMIT ----

SET AUTOCOMMIT = 1;

BEGIN;
INSERT INTO myisam_innodb VALUES (25);
INSERT INTO myisam_innodb VALUES (26);
COMMIT;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_myisam VALUES (27);
INSERT INTO innodb_myisam VALUES (28);
COMMIT;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO myisam_ndb VALUES (29);
INSERT INTO myisam_ndb VALUES (30);
COMMIT;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO ndb_myisam VALUES (31);
INSERT INTO ndb_myisam VALUES (32);
COMMIT;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO ndb_innodb VALUES (33);
INSERT INTO ndb_innodb VALUES (34);
COMMIT;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_ndb VALUES (35);
INSERT INTO innodb_ndb VALUES (36);
COMMIT;
sync_slave_with_master;
connection master;

--echo ---- ROLLBACK ----

BEGIN;
INSERT INTO myisam_innodb VALUES (37);
INSERT INTO myisam_innodb VALUES (38);
ROLLBACK;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_myisam VALUES (39);
INSERT INTO innodb_myisam VALUES (40);
ROLLBACK;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO myisam_ndb VALUES (41);
INSERT INTO myisam_ndb VALUES (42);
ROLLBACK;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO ndb_myisam VALUES (43);
INSERT INTO ndb_myisam VALUES (44);
ROLLBACK;
sync_slave_with_master;
connection master;

BEGIN;
INSERT INTO ndb_innodb VALUES (45);
INSERT INTO ndb_innodb VALUES (46);
ROLLBACK;
sync_slave_with_master;
connection master;
BEGIN;
INSERT INTO innodb_ndb VALUES (47);
INSERT INTO innodb_ndb VALUES (48);
ROLLBACK;
sync_slave_with_master;
connection master;

--echo ==== AUTOCOMMIT=1, single statements ====

INSERT INTO myisam_innodb VALUES (49);
INSERT INTO myisam_innodb VALUES (50);
sync_slave_with_master;
connection master;
INSERT INTO innodb_myisam VALUES (51);
INSERT INTO innodb_myisam VALUES (52);
sync_slave_with_master;
connection master;

INSERT INTO myisam_ndb VALUES (53);
INSERT INTO myisam_ndb VALUES (54);
sync_slave_with_master;
connection master;
INSERT INTO ndb_myisam VALUES (55);
INSERT INTO ndb_myisam VALUES (56);
sync_slave_with_master;
connection master;

INSERT INTO ndb_innodb VALUES (57);
INSERT INTO ndb_innodb VALUES (58);
sync_slave_with_master;
connection master;
INSERT INTO innodb_ndb VALUES (59);
INSERT INTO innodb_ndb VALUES (60);
sync_slave_with_master;
connection master;

--echo ==== AUTOCOMMIT=0, single statements, myisam on master ====

SET AUTOCOMMIT = 0;

# This tests BUG#29288.
INSERT INTO myisam_innodb VALUES (61);
INSERT INTO myisam_innodb VALUES (62);
sync_slave_with_master;
connection master;

INSERT INTO myisam_ndb VALUES (63);
INSERT INTO myisam_ndb VALUES (64);
sync_slave_with_master;
connection master;

--echo ==== Show results ====

SELECT * FROM myisam_innodb ORDER BY a;
SELECT * FROM innodb_myisam ORDER BY a;
SELECT * FROM myisam_ndb    ORDER BY a;
SELECT * FROM ndb_myisam    ORDER BY a;
SELECT * FROM innodb_ndb    ORDER BY a;
SELECT * FROM ndb_innodb    ORDER BY a;

let $diff_tables= master:myisam_innodb, slave:myisam_innodb;
source include/diff_tables.inc;

let $diff_tables= master:innodb_myisam, slave:innodb_myisam;
source include/diff_tables.inc;

let $diff_tables= master:myisam_ndb, slave:myisam_ndb;
source include/diff_tables.inc;

let $diff_tables= master:ndb_myisam, slave:ndb_myisam;
source include/diff_tables.inc;

let $diff_tables= master:innodb_ndb, slave:innodb_ndb;
source include/diff_tables.inc;

let $diff_tables= master:ndb_innodb, slave:ndb_innodb;
source include/diff_tables.inc;

--echo ==== Clean up ====

drop table myisam_innodb, innodb_myisam;
drop table myisam_ndb, ndb_myisam;
drop table innodb_ndb, ndb_innodb;
sync_slave_with_master;
--source include/rpl_end.inc

${this.title}

Code Editor : ndb_rpl_mixed_tables.test