[MDEV-17369] Document how to reset gtid_current_pos Created: 2018-10-04 Updated: 2020-08-25 Resolved: 2018-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation - Support, Replication |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Kenneth Dyer (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | binlog, documentation, gtid | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
The documentation doesn't currently say how to reset gtid_current_pos: https://mariadb.com/kb/en/library/gtid/#gtid_current_pos gtid_current_pos is made up by combining GTIDs from two different variables: gtid_binlog_pos and gtid_slave_pos. So to reset gtid_current_pos, you need to reset both of those. 1.) gtid_binlog_pos can be reset with "RESET MASTER": https://mariadb.com/kb/en/library/reset-master/ https://mariadb.com/kb/en/library/gtid/#gtid_binlog_pos 2.) gtid_slave_pos can be reset by executing:
https://mariadb.com/kb/en/library/gtid/#gtid_slave_pos |
| Comments |
| Comment by Geoff Montee (Inactive) [ 2018-10-04 ] |
|
I added some notes on this: https://mariadb.com/kb/en/library/gtid/#gtid_slave_pos |