We are looking to setup grafana for high availability. I read through the document related to it here:
In existing setup we have 3 grafana-server machines connecting to 3 machine master-slave mysql cluster.
We are planning to have a HA MySql cluster setup with multiple master nodes distributed across couple of different geographical locations. There will be more grafana server machines and all of them will talk to MySql cluster via a load balancer.
My question is: do we need to have any change in grafana schema to enable it to work with multi master mysql setup? Are there any limitations (for e.g. grafana to be aware of a column that is created as primary key or such) in terms of using multi master mysql setup?
Thanks for your help and suggestions.