ProxySQL has a mirroring feature that can act like a trigger on a separate thread: https://github.com/sysown/proxysql/blob/master/doc/mirroring.md#rewrite-mirro

ProxySQL has a mirroring feature that can act like a trigger on a separate thread: https://github.com/sysown/proxysql/blob/master/doc/mirroring.md#rewrite-mirror-query-only https://github.com/sysown/proxysql/blob/master/doc/mirroring... Add a cronjob to refresh results if you are worried about skews over time. Problem solved.