[MDEV-8946] Add replication crash-safety for non-GTID slave. Created: 2015-10-15  Updated: 2017-09-14

Status: Open
Project: MariaDB Server
Component/s: Replication
Fix Version/s: None

Type: Task Priority: Major
Reporter: Jean-François Gagné Assignee: Unassigned
Resolution: Unresolved Votes: 7
Labels: None


 Description   

The way to achieve replication crash safety in MariaDB 10.0 is to enable GTID slave negotiation, but this is not always possible and comes with drawbacks:

  1. 1. It is not possible to enable GTID slave negotiation when the master is not MariaDB 10.
  2. 2. GTID slave negotiation put extra burden on the master.
  3. 3. GTID slave negotiation does not yet works with MaxScale Binlog Servers.
  4. 4. GTID slave negotiation overloads the master NIC on restarting IO_THREAD on lagging slave (MDEV-8945).

Having replication crash-safety in file/position replication with MariaDB would be useful. This does not look very hard to implement and is implemented in MySQL 5.6. See this post for more information and pitfalls in the MySQL implementation:
http://blog.booking.com/better_crash_safe_replication_for_mysql.html

Thanks,

JFG



 Comments   
Comment by Olu Efunwoye [ 2017-09-14 ]

Is there any update to this issue for MariaDB v10.0?

Generated at Thu Feb 08 07:30:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.