Re: [Maria-developers] GTID and failovers with multi-domain replication

2013-05-08 Thread Kristian Nielsen
Pavel Ivanov writes: > I love the idea with START SLAVE UNTIL. Looks very clean and > reasonable. And I don't like the idea of special treatment of this in > strict mode. Yeah. Let's go with START SLAVE UNTIL and keep the error when starting from non-existing GTID and no UNTIL. I hope to have a

Re: [Maria-developers] GTID and failovers with multi-domain replication

2013-05-08 Thread Pavel Ivanov
I love the idea with START SLAVE UNTIL. Looks very clean and reasonable. And I don't like the idea of special treatment of this in strict mode. > Not sure if it is a good idea to allow connect at a future GTID in strict > mode. It does seem to go a bit against the idea with "strict", on the other

Re: [Maria-developers] Documentation about GTID

2013-05-08 Thread Kristian Nielsen
Alex Yurchenko writes: > Since both are configured manually, and domain ID can simply default > to 0 in simple setups, I'd imagine that the possibility of having > server ID configured incorrectly (just missing to configure it) is way > more probable than having domain ID incorrect. Actually, bei

Re: [Maria-developers] MYSQL_TYPE_DECIMAL type

2013-05-08 Thread Hartmut Holzgraefe
On 08.05.2013 11:44, Sergei Golubchik wrote: > I've quickly checked the code and couldn't find a way to create a table > with the MYSQL_TYPE_DECIMAL column. There are even asserts in the code > that show it's impossible. > > So, I'm very interested to know how your customer managed to do it :) >

Re: [Maria-developers] MYSQL_TYPE_DECIMAL type

2013-05-08 Thread Zardosht Kasheff
I think they had a 5.0 table with the old type, upgraded their system to the new binaries, then did an alter table. Apparently, the alter table preserves the old type, and does not create a table with the new type On Wed, May 8, 2013 at 5:44 AM, Sergei Golubchik wrote: > Hi, Zardosht! > > On Apr

Re: [Maria-developers] Documentation about GTID

2013-05-08 Thread Kristian Nielsen
Roberto Spadim writes: > this could be put in manual just as an information of why use 64bits on > gtid, it is interesting Thanks for the suggestion, I added a note about this to the docs: https://kb.askmonty.org/en/global-transaction-id/#implementation - Kristian. __

Re: [Maria-developers] MYSQL_TYPE_DECIMAL type

2013-05-08 Thread Sergei Golubchik
Hi, Zardosht! On Apr 26, Zardosht Kasheff wrote: > Hello all, > > Under what circumstances can a table be created with > MYSQL_TYPE_DECIMAL as being one of the columns? I thought > MYSQL_TYPE_DECIMAL was deprecated pre 5.1. I thought all new tables > use MYSQL_TYPE_NEWDECIMAL. I've quickly check

Re: [Maria-developers] is this a bug?

2013-05-08 Thread Sergei Golubchik
Hi, Alexander! On May 06, Alexander Barkov wrote: >Hi Sergei, > > > On 05/01/2013 01:27 PM, Sergei Golubchik wrote: > > Hi, Alexander! > > > > Could you report this bug and fix it, please? > > The report is here: > https://mariadb.atlassian.net/browse/MDEV-4489 > > Please review a patch fi

Re: [Maria-developers] GTID and failovers with multi-domain replication

2013-05-08 Thread Kristian Nielsen
Pavel Ivanov writes: > assume we have server S1 that is master working with domain_id=0, > server S2 is master working with domain_id=1, servers S3 and S4 are > slaves and replicate from both of these masters, i.e. they have both > domains in their databases. Now let's say S1 has last GTID 0-1-10