WL#3725: ndb_apply_status extension for generic replication
Affects: Server-5.1
—
Status: Complete
ndb_apply_status is today only used in cluster -> cluster replication this WL extends the usage to "any engine" -> cluster replication Note added by Trudy Pelzer, 2007-03-12: This is a 5.1 task, needed to fix tagged BUG#26783 "replication status unknown after cluster or mysqld failure"; per Calvin.
----------- master (innodb table)
master> show binlog events;
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info
|
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------------------+
| master-bin.000001 | 4 | Format_desc | 1 | 102 | Server ver:
5.1.16-beta-valgrind-max-debug-log, Binlog ver: 4 |
| master-bin.000001 | 102 | Query | 1 | 90 | use `test`;
insert into t1 values (1,1) |
| master-bin.000001 | 192 | Xid | 1 | 219 | COMMIT /*
xid=6 */ |
------------slave (ndb table)
slave> select * from mysql.ndb_apply_status;
+-----------+-------+-------------------+-----------+---------+
| server_id | epoch | log_name | start_pos | end_pos |
+-----------+-------+-------------------+-----------+---------+
| 1 | 0 | master-bin.000001 | 102 | 90 |
+-----------+-------+-------------------+-----------+---------+
-------------master
master> show binlog events;
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info
|
+-------------------+-----+-------------+-----------+-------------+---------------------------------------------------------------+
| master-bin.000001 | 4 | Format_desc | 1 | 102 | Server ver:
5.1.16-beta-valgrind-max-debug-log, Binlog ver: 4 |
| master-bin.000001 | 102 | Query | 1 | 90 | use `test`;
insert into t1 values (1,1) |
| master-bin.000001 | 192 | Xid | 1 | 219 | COMMIT /*
xid=6 */ |
| master-bin.000001 | 219 | Query | 1 | 287 | use `test`;
BEGIN |
| master-bin.000001 | 287 | Query | 1 | 90 | use `test`;
insert into t1 values (2,1) |
| master-bin.000001 | 377 | Query | 1 | 180 | use `test`;
insert into t1 values (3,1) |
| master-bin.000001 | 467 | Xid | 1 | 494 | COMMIT /*
xid=45 */ |
----------- slave
slave> select * from mysql.ndb_apply_status;
+-----------+-------+-------------------+-----------+---------+
| server_id | epoch | log_name | start_pos | end_pos |
+-----------+-------+-------------------+-----------+---------+
| 1 | 0 | master-bin.000001 | 219 | 494 |
+-----------+-------+-------------------+-----------+---------+
No LLD needed, see BUG#26783 and HLS for details. -- Trudy Pelzer, 2007-06-18
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.