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 (mailto: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
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net (mailto:maria-developers@lists.launchpad.net) Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp