maria-developers team mailing list archive

[Pavel Ivanov <pivanof@xxxxxxxxxx>]

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> 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
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>