MySQL Forums
Forum List  »  Newbie

Re: Databases are not showing up on Replicated Server
Posted by: Lib Tech
Date: August 07, 2024 08:33PM

I was able to fix the issue. Just wanted to post the solution incase some else run to similar issue. I restored severs from snapshot. Two changes I made, first I included mysql_native_password tag to command while creating slave/master user, such as below:
CREATE USER 'replica'@'%' IDENTIFIED WITH mysql_native_password BY 'MyPassword';

The second change was setting sql_slave_skip_counter value to 1, when I got below error:
mysql> SET GLOBAL sql_slave_skip_counter = 1;

Error:
Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at source log mysql-bin.000001, end_log_pos 1239694. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.

Thank you all for helping!

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.