[Maria-discuss] New Question: mysqld fills /tmp with file /tmp/#sql_26be_0.MAD

2016-04-22 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB Documentation" by aferrett. Please answer it at http://mariadb.com/kb/en/mysqld-fills-tmp-with-file-tmpsql_26be_0mad/ as the person asking the question may not be subscribed to the mailing list. We have MariaDB C

Re: [Maria-discuss] GTID replication and SST method

2016-04-22 Thread Andrew Garner
I don't think that this problem relates to wsrep_gtid_mode. That just forces a particular gtid_domain_id for Galera transactions if I understand right but I suspect it doesn't solve this case. xtrabackup-v2 attempts to blow away all the existing binary logs on the joiner during SST and attempts t

[Maria-discuss] MariaDB 5.5.49 and updated connectors now available

2016-04-22 Thread Daniel Bartholomew
The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.49, MariaDB Connector/J 1.4.2, and MariaDB Connector/ODBC 2.0.10. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - -

Re: [Maria-discuss] GTID replication and SST method

2016-04-22 Thread Guillaume Lefranc
Craig, yes, you are correct. Please refer to our KB for more info: https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_gtid_mode On Fri, Apr 22, 2016 at 2:51 PM Craig Bailey wrote: > Hi Guillaume, > > > > Thanks for the swift response, you are correct with the version I am

Re: [Maria-discuss] GTID replication and SST method

2016-04-22 Thread Craig Bailey
Hi Guillaume, Thanks for the swift response, you are correct with the version I am using (10.0.23). If I switch to 10.1.x are you saying (assuming I follow your instructions) that the GTID will be kept in sync across my whole cluster, such that at any point I could issue a CHANGE MASTER on my

Re: [Maria-discuss] GTID replication and SST method

2016-04-22 Thread Guillaume Lefranc
Hi Craig, I assume that you use MariaDB Galera Cluster 10.0, in which case GTID's aren't kept in sync across the cluster. I would recommend upgrading to MariaDB Galera Cluster 10.1 and set the two following variables: wsrep_gtid_mode=1 wsrep_gtid_domain_id=N # set this value to a domain_id which

[Maria-discuss] GTID replication and SST method

2016-04-22 Thread Craig Bailey
Hi, I am attempting to get remote replication working from my MariaDB Galera Cluster in the following way: * MariaDB Galera Cluster replicates to a remote MariaDB DR node via standard master slave method using MariaDB GTID o Pick a master node from the cluster o Take a backup with