mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
d26851a575
This patch makes replication crash-safe with the new binlog implementation, even when --innodb-flush-log-at-trx-commit=0|2. The point is to not send any binlog events to the slave until they have become durable on master, thus avoiding that a slave may replicate a transaction that is lost during master recovery, diverging the slave from the master. Keep track of which point in the binlog has been durably synced to disk (meaning the corresponding LSN has been durably synced to disk in the InnoDB redo log). Each write to the binlog inserts an entry with offset and corresponding LSN in a FIFO. Dump threads will first read only up to the durable point in the binlog. A dump thread will then check the LSN fifo, and do an InnoDB redo log sync if anything is pending. Then the FIFO is emptied of any LSNs that have now become durable, and the durable point in the binlog is updated and reading the binlog can continue. Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
63 lines
1.5 KiB
Plaintext
63 lines
1.5 KiB
Plaintext
--source include/not_embedded.inc
|
|
--source include/not_valgrind.inc
|
|
--source include/have_debug.inc
|
|
--source include/have_binlog_format_mixed.inc
|
|
--source include/have_innodb_binlog.inc
|
|
|
|
--let $datadir= `SELECT @@datadir`
|
|
--source include/reset_master.inc
|
|
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES (1);
|
|
|
|
--let $no_checkpoint_flush= 1
|
|
--let no_checkpoint_kill= 1
|
|
--source ../../suite/innodb/include/no_checkpoint_start.inc
|
|
--let $file= query_get_value(SHOW MASTER STATUS, File, 1)
|
|
--let $pos= query_get_value(SHOW MASTER STATUS, Position, 1)
|
|
|
|
|
|
BEGIN;
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (3);
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES (4);
|
|
INSERT INTO t1 VALUES (5);
|
|
INSERT INTO t1 VALUES (6);
|
|
INSERT INTO t1 VALUES (7);
|
|
SELECT * FROM t1 ORDER BY a;
|
|
|
|
# Crash the server
|
|
--write_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
wait-recovery.test
|
|
EOF
|
|
|
|
SET SESSION debug_dbug="+d,crash_dispatch_command_before";
|
|
--error 2006,2013
|
|
SELECT 1;
|
|
--source include/wait_until_disconnected.inc
|
|
|
|
--source ../../suite/innodb/include/no_checkpoint_end.inc
|
|
|
|
# Overwrite the binlog file past the last checkpoint
|
|
--let BINLOG_FILE= $datadir/$file
|
|
--let OFFSET= $pos
|
|
--let LEN=5000
|
|
perl;
|
|
open F, '+<', $ENV{BINLOG_FILE} or die $!;
|
|
sysseek F, $ENV{OFFSET}, 0 or die $!;
|
|
my $x= chr(0) x $ENV{LEN};
|
|
syswrite F, $x, $ENV{LEN} or die $!;
|
|
EOF
|
|
|
|
--append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
restart
|
|
EOF
|
|
--enable_reconnect
|
|
--source include/wait_until_connected_again.inc
|
|
|
|
--let $binlog_file=
|
|
--let $binlog_start= 4
|
|
--source include/show_binlog_events.inc
|
|
DROP TABLE t1;
|