|
Sometimes the slave_skip_errors has to be used as there are potential replication issues, such as when using circular or bidirectional replication, and in which case the customer first and foremost has to keep replication going and will have to resolve conflicts later. To manually resolve these conflicts is difficult though, as there is no way to note failed transactions, they are just silently ignored.
To fix this, a way to log errors is a way to solve this. This is might not be relevant for all failed replicated transaction so a system variable would be used, suggested to be called replica_log_errors. This would cause failed transactions with one of the given errors codes to be logged to a file in binlog format and with the file name and position of the relay log, to allow for cross referencing. The error would not be ignored, so replication would be halted, unless the listed error code is also listen in slave_skip_errors.
The setting is either "off", a list of error codes or "all", just like slave_skip_errors. The idea here is to allow SQL_SLAVE_SKIP_COUNTER to be used on errors, but said errors be logged.
|