We have two server setup :
Master : 10.64.11.142
Slave: 10.64.11.56
We have created a table on Master:
CREATE TABLE billing_details
.app_records
(
msisdn
VARCHAR(45) NOT NULL,
sc
VARCHAR(45) NULL,
date_time
VARCHAR(45) NULL,
PRIMARY KEY (msisdn
));
After that replication has stopped on slave and got below logs :
2019-07-01 13:06:24 10636 exist[ERROR] Slave SQL: Error executing row event: ‘Table ‘billing_details.app_records’ doesn’t exist’, Error_code: 1146
2019-07-01 13:06:24 10636 [Warning] Slave: Table ‘billing_details.app_records’ doesn’t exist Error_code: 1146
2019-07-01 13:06:24 10636 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”. We stopped at lexistog ‘mysql-bin.000263’ position 506655964
Also some times we found records are missing in the slave server while replication.
Please help.
Best regards,
Sujit