0

MySQL replication was set up using docker-compose mysql:8.0.20 as the current running DB master. All databases had a size of 50GB. After a few days, the slave was down for 6 hours and was unable to sync.

Tried to reset slave and add but getting the same error.

Can anyone help please!

Looking for solution answers from who is expert in MySQL replication.

6
  • Mysql produces always an error log, try to find it
    – nbk
    Mar 31 at 9:48
  • Unable to get logs, please suggest other way
    – V S devops
    Mar 31 at 9:57
  • stackoverflow.com/questions/39708213/…. Read this
    – nbk
    Mar 31 at 10:12
  • Tried even on the slave but still getting error STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE; Please see below details Please suggest Slave_IO_State: Waiting for master to send event Master_Host: master-docker-host-1 Master_User: slave_user Master_Port: 3306 Connect_Retry: 60 Slave_IO_Running: Yes Slave_SQL_Running: No Last_Errno: 1146 Last_Error: Error executing row event: 'Table 'Vysis.ic_results' doesn't exist'
    – V S devops
    Apr 2 at 10:14
  • please add new infomation always to your question
    – nbk
    Apr 2 at 10:47

0

Browse other questions tagged or ask your own question.