Hello
I have been using grafana for many years now, and I would like to switch from a development mode (grafana + mysqllite) to a more efficient mode (postgres/mysql and REDIS for the cache).
I found in the configuration (/etc/grafana/grafana.ini) several section meeting my needs:
#################################### Database ############# #######################
[database]
# You can configure the database connection by specifying type, host, name, user and password
# as separate properties or as on string using the url properties.
# Either "mysql", "postgres" or "sqlite3", it's your choice
;type=sqlite3
;host=127.0.0.1:3306
;name = grafana
;user = root
# If the password contains # or ; you have to wrap it with triple quotes. Eg """#password;"""
;password=
#################################### Cache server ############ #################
[remote_cache]
# Either "redis", "memcached" or "database" default is "database"
;type=database
# cache connectionstring options
# database: will use Grafana primary database.
# redis: config like redis server e.g. `addr=127.0.0.1:6379,pool_size=100,db=0,ssl=false`. Only addr is required. ssl may be 'true', 'false', or 'insecure'.
# memcache: 127.0.0.1:11211
;connstr =
# prefix prepended to all the keys in the remote cache
; prefix =
# This enables encryption of values stored in the remote cache
;encryption=
I am using docker for my stack is there a way to setup an external database and redis with docker environment variables?
How is the migration from sqlite to mysql or postgres ?
What should I prefer to postgres or mysql ?
How is the addition of REDIS going?