MySQL Forums :: Replication :: Solving problems with mysql replica


Advanced Search

Solving problems with mysql replica
Date: April 26, 2012 06:32AM

HI everybody,

I have had some problems with MySQL's replica. I have two servers in master-master architecture, so, I have configured a master and a slave in both. When I have problems in the replica , in some cases, I have to do a lock of tables in master A, make a backup, take note about mysql-bin and position and then I have to restore backup on my master B. Last step is unlock tables.

I think that this is the normal way to restore replication when an error occurs, but if in both masters there are read/write operations, I have got a problem!

Are there any way to restore replication between masters but without stopping or blocking write operations? I know 'SET GLOBAL sql_slave_skip_counter=1' restarting slave, but I think that this is not good.

Any ideas about how can I solve problems in MySQL's replica? I need a good protocol to solve it.

Maybe, if both masters there are active and receive read/write operations, shoud I to configure another architecture? Obviously different, like as cluster or whatever.

I hope your advices.

Best regards,

Toni.

Options: ReplyQuote


Subject Views Written By Posted
Solving problems with mysql replica 2104 Antonio Manuel Fernández Pérez 04/26/2012 06:32AM
Re: Solving problems with mysql replica 1203 Rick James 04/27/2012 09:14AM
Re: Solving problems with mysql replica 832 Antonio Manuel Fernández Pérez 04/30/2012 02:33AM
Re: Solving problems with mysql replica 747 Rick James 04/30/2012 09:41PM
Re: Solving problems with mysql replica 743 Antonio Manuel Fernández Pérez 05/02/2012 05:19AM
Re: Solving problems with mysql replica 745 Rick James 05/03/2012 08:36AM
Re: Solving problems with mysql replica 812 Antonio Manuel Fernández Pérez 05/03/2012 09:09AM
Re: Solving problems with mysql replica 788 Rick James 05/04/2012 08:15AM
Re: Solving problems with mysql replica 793 Antonio Manuel Fernández Pérez 05/07/2012 12:57AM
Re: Solving problems with mysql replica 736 Rick James 05/07/2012 09:19PM
Re: Solving problems with mysql replica 934 Antonio Manuel Fernández Pérez 05/08/2012 01:40AM
Re: Solving problems with mysql replica 696 Rick James 05/08/2012 09:02PM
Re: Solving problems with mysql replica 886 Antonio Manuel Fernández Pérez 05/09/2012 02:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.