MySQL Forums
Forum List  »  Replication

Re: Problems with Replication
Posted by: Ted Wennmark
Date: April 25, 2019 10:31AM

Hello Per,

What is output from mysq> show slave status\G ?

You want to make sure that both SQL and IO tread is running:
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

And that there are no errors:
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:

Also please try to stay away from complex master-master setups if you do not really need this...

I am working as a solution architect in the MySQL team in Nordic countries, feel free to contact me directly via ted.wennmark@oracle.com to discuss this use-case.

Kind Regards,
Ted

Options: ReplyQuote


Subject
Views
Written By
Posted
1044
April 25, 2019 02:06AM
Re: Problems with Replication
372
April 25, 2019 10:31AM
352
April 26, 2019 01:17AM
359
April 28, 2019 10:37PM


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.