innobackupex does not record binlog file and pos when GTID is enabled
Bug #1449834 reported by
Jervin R
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
2.2 |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
2.3 |
Fix Released
|
Medium
|
Sergei Glushchenko |
Bug Description
percona-
percona-
When GTID is enabled, innobackupex output does not include binlog fiel and pos anymore. Although it makes sense to use GTID only on xtrabackup_
3120c3120
< # if ($mariadb_gtid || !$mysql_gtid) {
---
> if ($mariadb_gtid || !$mysql_gtid) {
3123c3123
< # }
---
> }
Changed in percona-xtrabackup: | |
status: | New → Triaged |
importance: | Undecided → Medium |
To post a comment you must log in.
This change was intentional as part of the fix for bug 1391041.
Bug 1391041: innobackupex should skip GTID output is GTID_MODE is OFF
For MySQL:
1. If GTID_MODE is ON print only GTID of the last change
2. If GTID_MODE is OFF print filename and position
For MariaDB always print filename, position and GTID.
From MySQL manual:
When GTIDs are in use, the slave has no need for any nonlocal data, such as the name of a file on the master and a position within that file. All necessary information for synchronizing with the master is obtained directly from the replication data stream. From the perspective of the database administrator or developer, GTIDs entirely take the place of the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between master and slave. This means that, when you are using GTIDs for replication, you do not need (or want) to include MASTER_LOG_FILE or MASTER_LOG_POS options in the CHANGE MASTER TO statement used to direct a slave to replicate from a given master; in place of these options, it is necessary only to enable the MASTER_ AUTO_POSITION option introduced in MySQL 5.6.5.
Could you please describe your use case when you need both binlog coordinates and GTID?