Re: [Maria-discuss] testing Galera

2013-02-12 Thread Kristian Nielsen
Jan Kirchhoff writes: > Kristian, > I didn't know of that function, good to hear that. > > But I was after some kind of slave_skip_counter-like function to make > galera skip an event in case of problems. I'm fine with a cluster member > stopping (or going read-only or something like that) becaus

Re: [Maria-discuss] testing Galera

2013-02-12 Thread Jan Kirchhoff
Kristian, I didn't know of that function, good to hear that. But I was after some kind of slave_skip_counter-like function to make galera skip an event in case of problems. I'm fine with a cluster member stopping (or going read-only or something like that) because some update couldn't be applied,

Re: [Maria-discuss] Problem in replication with NOW('2012-03-07 17:32:03')

2013-02-12 Thread Jan Kirchhoff
Am 12.02.2013 01:26, schrieb Elena Stepanova: > Hi Jan, > > On 2/12/2013 3:46 AM, Jan Kirchhoff wrote: >> Elena, >> I can't switch to statement based replication that easy. > > Even only for the connection(s) that produce the bad statements, if they > can be easily isolated and modified? > (to ro

Re: [Maria-discuss] testing Galera

2013-02-12 Thread Kristian Nielsen
Jan Kirchhoff writes: > Is there something like slave_skip_counter, aka "I Know what I do, skip > that update"? I think I have to take a new snapshot to get the second Yes, MariaDB has this: https://kb.askmonty.org/en/selectively-skipping-replication-of-binlog-events/ If you set skip_repl