The Ultimate Guide to High Availability with MariaDB

Comments - No GTID in xtrabackup_binlog_info

4 years, 5 months ago Simon Gareste
Re: No GTID in xtrabackup_binlog_info [Answer]

I think I finally may have found why: in https://mariadb.com/kb/en/library/setting-up-replication/ it says that it is recommended to use GTIDs, and that they were introduced in 10.0. GIven that my cluster was upgraded version by version, I never saw that and never did the update:

CHANGE MASTER TO MASTER_USE_GTID = slave_pos;

Also it seems that you can start the slave with 

CHANGE MASTER TO
  MASTER_HOST='master.domain.com',
  MASTER_USER='replication_user',
  MASTER_PASSWORD='bigs3cret',
  MASTER_PORT=3306,
MASTER_LOG_FILE='mariadb-bin.000096',
  MASTER_LOG_POS=568;

which is on the same page, but I coulnd't find anywhere else. So I guess this is solved.

Simon

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.