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@gmail.com> 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



_______________________________________________