MySQL Database as a back-end - Simple questions

[ptselios]

Hi
I need to have an HA setup so, we have a MySQL cluster setup already.
The questions are about the grafana.

1. Do we need to create the database or grafana will create the database for us?
2. Are there any specific privileges needed? A.k.a. what permissions are absolutely necessary to give to the mysql user? Documentation mentions exactly nothing.

[mefraimsson]

@ptselios

1. Do we need to create the database or grafana will create the database for us?

Yes

@ptselios

2. Are there any specific privileges needed? A.k.a. what permissions are absolutely necessary to give to the mysql user? Documentation mentions exactly nothing.

Permission to modify schema, i.e. create/drop tables, columns etc. Then insert/update/select

[ptselios]

So, we need to have the create database permission too.

[mefraimsson]

Sorry you’ll need to create the database - Grafana will not do that for you.

[libertyyoung]

Tip: You’ll also need to setup sessions, assuming in your HA setup you are load-balancing between more 2+ hosts

http://docs.grafana.org/installation/configuration/#session

[ptselios]

Of course I use the mysql