序
默認(rèn)grafana使用sqlite3進(jìn)行相關(guān)配置存儲(chǔ)，使用本地文件進(jìn)行session存儲(chǔ)，不太方便進(jìn)行分布式擴(kuò)展，這里改為mysql。
修改配置文件
[database]
; Either "mysql", "postgres" or "sqlite3", it's your choice
type = mysql
host = 192.168.99.100:3306
name = grafana
user = root
password = root
[session]
provider = mysql
provider_config = root:root@tcp(192.168.99.100:3306)/grafana
cookie_name = grafana_session
cookie_secure = false
session_life_time = 86400
配置mysql
docker run --name grafana-mysql -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 -d mysql:5.6.35
CREATE DATABASE IF NOT EXISTS grafana default charset utf8 COLLATE utf8_general_ci;
CREATE TABLE `session` (
`key` CHAR(16) NOT NULL,
`data` BLOB,
`expiry` INT(11) UNSIGNED NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
運(yùn)行
查看表結(jié)構(gòu)：
mysql> use grafana;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
+--------------------+
| Tables_in_grafana |
+--------------------+
| alert |
| alert_notification |
| annotation |
| api_key |
| dashboard |
| dashboard_snapshot |
| dashboard_tag |
| data_source |
| migration_log |
| org |
| org_user |
| playlist |
| playlist_item |
| plugin_setting |
| preferences |
| quota |
| session |
| star |
| temp_user |
| user |
+--------------------+
20 rows in set (0.01 sec)
代表切換成功。
