Our Magento 1.9 database is hosted on AWS RDS. For improving database performance, we created an Amazon Read Replica.
Unfortunately, the read replica runs out of sync. Error messages indicate, that replication tries to delete records from
... but these records don't exist.
Further investigation showed, that this table uses the MEMORY engine, and tables using the MEMORY engine cannot be replicated properly.
https://www.percona.com/blog/2010/10/15/replication-of-memory-heap-tables/ suggests to prevent these tables from being replicated by using the option replicate-ignore-table=db.memory_table . But this option seems to be unavailable in Amazon RDS.
Does anyone have a suggestion of how to get the read replica running in our environment?