To improve performance, we optimize our complex tabular web dashboard that loads many data (multiple columns and rows). Many cells in the table are editable so that data can be modified. Our main data store is MySQL and we also replicate the data in ElasticSearch. Optimization involves retrieving ElasticSearch data instead of MySQL when loading the page (but continues writing data on both MySQL and ElasticSearch).
This is a critical race situation in which a cell is updated (both in MySQL and ElasticSearch) and the page is quickly reloaded after the cell is updated. We would like to ensure data consistency so that ElasticSearch does not load old data in case the page reloading occurs before ElasticSearch is updated by the front-end server (React / Redux).
Common architectural models / services to solve this problem? Most dashboards, I see that the data extracted from ElasticSearch are read-only dashboards, hence the problem.