We recently had an issue with our replication failing due to a truncate statement replicating to the slave RDS instance, despite the database the truncate statement is in is ignored in replication using replicate-ignore-db. I have looked for an answer as to why and what we could to to prevent this but I haven’t been able to find anything. Any help/advice would be greatly appreciated.
We currently use AWS RDS using MySQL version 8.0.35.