MySQL Bugs: #76666: Suggest to add a new options for binlog_error

Bug #76666	Suggest to add a new options for binlog_error_action.
Submitted:	12 Apr 2015 10:52
Reporter:	Fangxin Flou (OCA)	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S4 (Feature request)
Version:	5.6/5.7	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	binlog

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Current we have two options for binlog_error_action variables.

ABROT_SERVER

or 

INGORE_ERROR

It's much better than before, but I think we could add a new optimal value to this variable.

ROLLBACK_WITH_ERROR_MESSAGE

If we cannot write the binlog, we could rollback the whole transactions (report the XA transaction as error), so the master database can provide read access withour the risk of borken the data replication between master and slave.

Thanks.

How to repeat:
N/A

Suggested fix:
The code is not so complex I think, but I haven't write any code for this feature.