We are looking for a lightweight HA solution to run Grafana in a simple setup with SQLite. For HA, a Postgres/mysql cluster is recommended. But we are thinking to implement a solution in which every instance has its own local SQLite DB, with an additional solution synchronising those DBs. By doing so, we hope to decrease complexity in our environment and keep things simple.
Does someone setup a similar solution? Or are there opinions against this approach?
Thanks for your feedback!