Model Persistence, Database Issue

Get Help
1

Hello, I have a database that is a replica of another database for performance and security reasons, and it's from this replica that I make my calls to Metabase. I want to create a persistent model but according to the Metabase documentation, I saw that I need to give write permissions to my Metabase user to write the model schemas in my replica. According to my colleagues, it's not a good idea to write to a replica, so I'm stuck.

Have you ever dealt with this kind of case? Do you have any advice or solutions? It would be super useful for me!

Have a good day!!

2

I think you're looking for Split read and write operations in the DW · Issue #30213 · metabase/metabase · GitHub

3

Yep that's exactly my issue. But I see there is no way to do this in metabase yet ?

4

nope, use a pgbouncer

5

I'm using MariaDB for my database warehouse, I think there is no way to use pgbouncer with this and i can't move from MariaDB. Do you know if there is an other solution or am I stuck forever :cry: ?

6

https://proxysql.com/documentation/proxysql-read-write-split-howto/