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