[MDEV-4478] Implement GTID "strict mode" Created: 2013-05-04 Updated: 2013-07-21 Resolved: 2013-05-28 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.2 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Pavel Ivanov | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Current GTID implementation allows situations when slave is not configured read-only and accepts any transactions from clients. These transactions get inserted in the middle of replication stream and then don't go anywhere. So essentially they generate data drift without any error messages and without easy methods of detection. To make production environments more bullet-proof there should be a flag turning on the "strict mode" for GTID replication in which slave accepts from master and binlog allows to commit only transactions with strictly increasing seq_no for each domain. |
| Comments |
| Comment by Pavel Ivanov [ 2013-05-09 ] |
|
After some thinking on this I realized that we would like to see the following here: 1) MariaDB requires sequence numbers in each domain to strictly grow. Any repeating number or number less than before should stop replication.
These changes will match our current MySQL tree and if you don't have strong objections we would really like to see these changes upstream. |
| Comment by Kristian Nielsen [ 2013-05-28 ] |
|
Pushed to 10.0-base, and documented in the Knowledgebase. |