R: how use sql_slave_skip_counter to restore slave replication

2006-01-10 Thread AESYS S.p.A. [Enzo Arlati]
I already tried the option --slave-skip-errors, but i didn't work as expected. When this option is enabled, the slave didn't report the error message, but the slave is stopped due the error. The target I need to reech is to get two server A e B, each of them have its own db server and a set of

Re: R: how use sql_slave_skip_counter to restore slave replication

2006-01-10 Thread Gleb Paharenko
Hello. I already tried the option --slave-skip-errors, but i didn't work as expected. When this option is enabled, the slave didn't report the error message, but the slave is stopped due the error. May be server dies due an error message which was not included in the

R: how use sql_slave_skip_counter to restore slave replication

2005-12-30 Thread AESYS S.p.A. [Enzo Arlati]
So it should be possible to automate a skip of errors setting by code , at run-time, sql_slave_skip_counter = 1, each time I check the slave status and I found an error, and then I restart the slave Thanks, I should try this way. One think it is astonished: I can agree that there should bu some

Re: R: how use sql_slave_skip_counter to restore slave replication

2005-12-30 Thread Gleb Paharenko
Hello. One think it is astonished: I can agree that there should bu some conflict, but why i have remove the same row, with the same key value several times about 5-6 times ).Do you have some knowledge of problem like that ? It is difficult to say something, because the whole picture of