I hope someone has some ideas on how to resolve the following issue I'm facing.
Here's the setup:
- 8.0.mysql_aurora.3.06.0 cluster with a writer and a reader instance(db.r7g.large)
- PHP web application using a database on the cluster(~2GB) using the DB reader endpoint
- another PHP application which refreshes some of the tables with a total of ~5mil rows via the DB writer endpoint, using:
INSERT INTO :tmpTableName VALUES (value1, value2, value3, ...);
RENAME TABLE :tableName TO :oldTableName, :tmpTableName TO :tableName;
DROP TABLE :oldTableName;
Unfortunately after the refresh PHP app finishes, we get the following error on the DB reader:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.table' doesn't exist.
while the table is fully functional on the DB writer.
The error disappears after DB reader reboot.
Any help will be greatly appreciated!