I use amazon rds and have a cross region replica. While I was doing some schema changes my read replica gave me this error and replication stopped.
Message : Read Replica Replication Error – SQLError: 1146, reason:
Error Table phppoint_koreannoona.phppos_items doesn’t exist on query.
Default database: DB_NAME;. Query: ALTER TABLE phppos_items DROP
What would cause this? The table is in the master. My migration DID remove that field but entire table was missing in slave.
I had to rebuild slave.