I am using metabase to connect to a relational postgres db.
Caching feature is pretty important to my usecase, to keep loading times bearable for end users.
Another constraint I'd like to achieve is directing all traffic coming from metabase to a read replica, to avoid eating up CPU of the main database server.
However, I can see that caching needs write access on the source database, and connecting to a read replica doesn't allow writes in most cloud providers. (I am using gcp cloud sql).
Is there a possibility to work around this?
It would be great if metabase can accept two ips for each source, one for read queries, and the other for writes.