SYSTEM INFORMATION | |
---|---|
OS type and version | Ubuntu 20.04 |
Webmin version | 2.001 |
Virtualmin version | 7.2-1 |
Related packages | SUGGESTED |
Hi there, I have a problem with MYSQL replication.
I use Webmin/Virtualmin with Ubuntu OS
The MASTER_LOG_POS is changed very fast and I can’t set up replication.
CHANGE MASTER TO
MASTER_HOST=‘IP’,
MASTER_USER=‘rep’,
MASTER_PASSWORD=‘Password’,
MASTER_LOG_FILE=‘mysql-bin.000004’,
MASTER_LOG_POS=3345884;
I success in setup once, and replication was working until the position changed again.
Then I get an error:Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction ‘ANONYMOUS’ at master log mysql-bin.000004, end_log_pos 3346397. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.
Could you please help me with this? Thanks