← Back to team overview

maria-developers team mailing list archive

Re: Documentation about GTID

 

Hi, 
Thanks for the quick answer.
However, neither of the suggested syntax works with the build currently released.

Moreover, since the commit comment mentions multiple masters, it would be nice to have some documentation that explains what to expect when using GTID and multiple masters.

Cheers

Giuseppe



On Wednesday, May 1, 2013 at 17:55 , Pavel Ivanov wrote:

> This was changed on the way
> (http://bazaar.launchpad.net/~maria-captains/maria/10.0-mdev26/revision/3554).
> Instead of "CHANGE MASTER TO master_gtid_pos=auto" you need to use
> "CHANGE MASTER TO master_use_gtid=1". If you want to actually set
> gtid_pos you need to set @@global.gtid_pos.
> 
> Pavel
> 
> On Wed, May 1, 2013 at 8:50 AM, Giuseppe Maxia <g.maxia@xxxxxxxxx (mailto:g.maxia@xxxxxxxxx)> wrote:
> > Hi!
> > I am testing MariaDB 10.0.2, and I am interested in GTID.
> > The only documentation I found is the worklog.
> > 
> > Without docs at hand, I tried something:
> > 
> > slave1 [localhost] {msandbox} ((none)) > CHANGE MASTER TO
> > master_gtid_pos='';
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> > that corresponds to your MariaDB server version for the right syntax to use
> > near 'master_gtid_pos=''' at line 1
> > slave1 [localhost] {msandbox} ((none)) > CHANGE MASTER TO
> > master_gtid_pos=auto;
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> > that corresponds to your MariaDB server version for the right syntax to use
> > near 'master_gtid_pos=auto' at line 1
> > 
> > 
> > This is supposed to work, according to a blog post and some worklogs, but it
> > doesn't.
> > 
> > 
> > As for GTID in practice, it seems to be active.
> > 
> > 
> > slave1 [localhost] {msandbox} ((none)) > show variables like '%gtid%';
> > +----------------+--------+
> > | Variable_name | Value |
> > +----------------+--------+
> > | gtid_domain_id | 0 |
> > | gtid_pos | 0-1-11 |
> > | gtid_seq_no | 0 |
> > +----------------+--------+
> > 3 rows in set (0.00 sec)
> > 
> > slave1 [localhost] {msandbox} ((none)) > use mysql
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> > 
> > Database changed
> > 
> > slave1 [localhost] {msandbox} (mysql) > select * from rpl_slave_state;
> > +-----------+--------+-----------+--------+
> > | domain_id | sub_id | server_id | seq_no |
> > +-----------+--------+-----------+--------+
> > | 0 | 12 | 1 | 11 |
> > +-----------+--------+-----------+--------+
> > 
> > 
> > However, when I run "show slave status", I get:
> > 
> > Using_Gtid: 0
> > 
> > Could you provide a pointer to the docs of the expected behavior at this
> > stage?
> > 
> > Thanks
> > 
> > Giuseppe
> > 
> > 
> > 
> > _______________________________________________
> > Mailing list: https://launchpad.net/~maria-developers
> > Post to : maria-developers@xxxxxxxxxxxxxxxxxxx (mailto:maria-developers@xxxxxxxxxxxxxxxxxxx)
> > Unsubscribe : https://launchpad.net/~maria-developers
> > More help : https://help.launchpad.net/ListHelp
> > 
> 
> 
> 



References