Xtrabackup doesn't log master co-ordinates while backup up MariaDB 10
Bug #1404484 reported by
kedar
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.2 |
Won't Fix
|
Medium
|
Unassigned | |||
2.3 |
Fix Released
|
Medium
|
Sergei Glushchenko | |||
2.4 |
Fix Released
|
Medium
|
Sergei Glushchenko |
Bug Description
Innobackupex provided with --slave-info doesn't log master's binlog co-ordinates instead it log's slave's binlog position.
Xtrabackup is being used with Holland backup framework.
Option --slave-info is provided.
Backup logs the GTID correctly though the binlog co-ordinates of master are not logged.
Xtrabackup 2.2.4
Mariadb10
tags: | added: i65672 |
To post a comment you must log in.
Verified with MariaDB 10 and Xtrabackup 2.2.7.
root@desktop: /home/nilnandan /backup/ 2014-12- 31_14-45- 42# cat xtrabackup_ slave_info /home/nilnandan /backup/ 2014-12- 31_14-45- 42#
CHANGE MASTER TO master_use_gtid = slave_pos
root@desktop:
With PS 5.6.21 and Xtrabackup 2.2.7, we can see like this.
root@desktop: /home/nilnandan /backup/ 2014-12- 31_15-07- 20# cat xtrabackup_ slave_info '2c827228- 90cf-11e4- b877-00224db1c5 03:1-2' ; AUTO_POSITION= 1 /home/nilnandan /backup/ 2014-12- 31_15-07- 20#
SET GLOBAL gtid_purged=
CHANGE MASTER TO MASTER_
root@desktop:
Actually, in MariaDB, we need master binlog file and position to get GTID, also from backup, we can get the GTID.
i.e
nilnandan@ desktop: ~$ sudo innobackupex --user=root --password=msandbox --socket= /tmp/mysql_ sandbox24026. sock --defaults- file=/home/ nilnandan/ sandboxes/ rsandbox_ mariadb- 10_0_15/ node1/my. sandbox. cnf --slave-info /home/nilnandan /backup/
...
innobackupex: Backup created in directory '/home/ nilnandan/ backup/ 2014-12- 31_14-45- 42' desktop: ~$
innobackupex: MySQL binlog position: filename 'mysql-bin.000001', position 312, GTID of the last change '0-1-12'
innobackupex: MySQL slave binlog position: master host '127.0.0.1', gtid_slave_pos 0-1-12
141231 14:45:45 innobackupex: Connection to database server closed
141231 14:45:45 innobackupex: completed OK!
nilnandan@
So the slave_info should be,
SET GLOBAL gtid_slave_pos = '0-1-12'; use_gtid= slave_pos;
CHANGE MASTER TO master_
Find more information here. https:/ /mariadb. com/blog/ enabling- gtids-server- replication- mariadb- 100