...
Download and install InfluxDB 1.x from https://influxdata.com/downloads/#influxdb for your platform. InfluxDB 2.x is not currently supported.
- Start InfluxDB
Create a user and a database in InfluxDB using the Influx CLI and executing the commands below
Bloque de código language sql theme Confluence CREATE DATABASE worldserver CREATE USER grafana WITH PASSWORD 'grafana' GRANT READ ON worldserver TO grafana
Edit the default retention policy to ensure the InfluxDB database doesn't grow too much.
Bloque de código language sql theme Confluence USE worldserver SHOW RETENTION POLICIES
Refer to https://docs.influxdata.com/influxdb/v1.8/query_language/manage-database/ on how to manage retention policies.
Installing Grafana
- Download and install Grafana from http://docs.grafana.org/installation/
- Open the dashboard at http://localhost:3000
- Login with username admin and password admin (defaults can be changed in Grafana's .ini files)
- Go to
Data Sources
→+ Add Data Source
Name: Influx
Type: InfluxDB
Url: http://localhost:8086
Access: Server
Database: worldserver User: grafana Password: grafana - Go to
Dashboards
→Import
and import Click on the + sign in the menu on the left called "Create" and select "Dashboard", then import each .json file in TrinityCore's /contrib/grafana clicking on "Upload JSON file"
Configuring TrinityCore
- Edit the worldserver.conf file
- Set
Metric.Enable = 1
- Edit
Metric.ConnectionInfo
with connection details (e.g"127.0.0.1;8086;worldserver"
) - Start worldserver, the dashboard should now start receiving values
...
- I/O networking traffic:
- Packets sent
- Packets received
- Average ping
- Traffic in
- Traffic out
- World session update time
- Map update time
- Map loads/unloads
- MMap queries
- Database async queries queued count
- Server uptime (through world initialize and world shutdown events)
- Active connections
- Queued connections
...
Sección | |||
---|---|---|---|
InfluxDB is part of a bigger set of projects by InfluxData which integrate nicely with the DB: Columna |
|
...