mirror of
https://github.com/MariaDB/server.git
synced 2025-11-01 11:26:11 +01:00
37ca3ea8c5MySQL created `rpl_injector` to assist in binlogging the NDB Cluster
storage engine. It describes itself as for notifying the MySQL server
of externally spawned rows.
However, we use Galera here at MariaDB, not MySQL NDB Cluster.
MDEV-34 removed the NDB storage engine from our fork,
which orphaned `rpl_injector`.
c096caee71 said that this is considered dead code and a subsequent patch
will remove the rest. That patch never came, so this commit shall be it.
84 lines
2.3 KiB
SQL
84 lines
2.3 KiB
SQL
#############################################################
|
|
# Author: Rafal
|
|
# Date: 2007-08-20
|
|
# based on rpl_multi_engine3.inc
|
|
#############################################################
|
|
|
|
connection slave;
|
|
STOP SLAVE;
|
|
RESET SLAVE;
|
|
|
|
connection master;
|
|
RESET MASTER;
|
|
|
|
connection slave;
|
|
START SLAVE;
|
|
|
|
--echo --- Populate t1 with data ---
|
|
connection master;
|
|
--disable_query_log
|
|
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1905-11-14");
|
|
INSERT INTO t1 VALUES(2,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1965-11-14");
|
|
INSERT INTO t1 VALUES(4,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1985-11-14");
|
|
INSERT INTO t1 VALUES(142,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1995-11-14");
|
|
INSERT INTO t1 VALUES(412,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"2005-11-14");
|
|
--enable_query_log
|
|
|
|
--echo --- Select from t1 on master ---
|
|
select *
|
|
from t1
|
|
order by id;
|
|
|
|
sync_slave_with_master;
|
|
--echo --- Select from t1 on slave ---
|
|
select *
|
|
from t1
|
|
order by id;
|
|
|
|
--echo --- Perform basic operation on master ---
|
|
--echo --- and ensure replicated correctly ---
|
|
connection master;
|
|
|
|
--echo --- Update t1 on master --
|
|
UPDATE t1 SET b1 = 0, bc='updated', t="2006-02-22"
|
|
WHERE id < 100
|
|
ORDER BY id;
|
|
|
|
--echo --- Check the update on master ---
|
|
SELECT *
|
|
FROM t1
|
|
WHERE id < 100
|
|
ORDER BY id;
|
|
|
|
sync_slave_with_master;
|
|
--echo --- Check Update on slave ---
|
|
SELECT *
|
|
FROM t1
|
|
WHERE id < 100
|
|
ORDER BY id;
|
|
|
|
connection master;
|
|
--echo --- Remove a record from t1 on master ---
|
|
DELETE FROM t1 WHERE id = 412;
|
|
|
|
--echo --- Show current count on master for t1 ---
|
|
SELECT COUNT(*) FROM t1;
|
|
|
|
sync_slave_with_master;
|
|
--echo --- Show current count on slave for t1 ---
|
|
SELECT COUNT(*) FROM t1;
|
|
|
|
connection master;
|
|
TRUNCATE TABLE t1;
|
|
sync_slave_with_master;
|
|
connection master;
|