I have setup Grafana HA and it works pretty well.
Now want Mysql HA too hence I installed mysql on both grafana nodes to use local DB and setup MySQL replication in both direction (2 way mysql replication)
It works well in start for sometime and later started getting issue on mysql replication as below
Last_SQL_Error: Could not execute Write_rows event on table grafana.annotation; Duplicate entry ‘2143’ for key ‘PRIMARY’, Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log mysql-bin.000004, end_log_pos 34111120
Does Grafana not support that?