Grafana
What you'll learn
- Explore the Graph, Singlestat, Gauge, Bar Gauge, Table, Text, Heatmap and Logs Panels
- Install and configure a MySQL Datasource, Dashboard and Collector
- Install and configure a Zabbix Server Datasource, Dashboards
- Install and configure InfluxDB with Telegraf
- Use Dashboard Variables to create Dynamic Dashboards with Automatic Visualisation Placement
- Install an SNMP Agent and Configure Telegraf SNMP Input
- Install Loki Data Source that queries a Loki Service that is ingesting data from a Promtail Service.
- Graph Time Series aswell as Non Time Series SQL Data
- Create custom MySQL Time Series Queries
- Install Grafana from Packages
- Add a Nginx Reverse Proxy for Grafana
- Create a domain name and install an SSL certificate for the Grafana Server
- Explore the Dashboards Panels Options
- Install a SMTP server and setup an Email Notification Channel
- Setup Alerts for when SNMP devices go offline or return no data
- Setup a SMS Alerting Channel using AWS SNS
- Setup a Telegram Bot Alerting Channel
- Use Annotation Queries to Link Logs Panels and Graph Panels
- Install Prometheus with Several Node Exporters and A Dashboard
- Setup Different Value Groups/Tags for Zabbix and InfluxDB Datasources
- Create a Disk Read/Write Rates Dashboard with the Zabbix Data Source
- Setup an Elasticsearch server with Filebeat and Metricbeat services.
Requirements
- Basic Linux Experience
- Basic MySQL Familiarity
- All commands entered during the lectures are provided in the corresponding resources
Description
Welcome to my course on Grafana
Grafana is an analytics platform for all of your metrics. Grafana allows you to query, visualize, alert on and understand your metrics no matter where they are stored. Create, explore, and share dashboards with your team and foster a data driven culture. Trusted and loved by the community.
This is a Learn by example course, where I demonstrate all the concepts discussed so that you can see them working, and you can try them out for yourself as well.
With this course, comes accompanying documentation that you can access for free. You will then be able to match what you see in the videos and copy/paste directly from my documentation and see the same result.
In this course we will,
Install Grafana from Packages
Create a domain name, install an SSL certificate and change the default port
Explore the Graph, Singlestat, Gauge, Bar Gauge, Table, Text, Heatmap and Logs Panels
Create many different types of Data Sources from MySQL, Zabbix, InfluxDB, Prometheus and Loki
We will configure their various collection processes such as MySQL Event Scheduler, Telegraf, Node Exporters, SNMP agents and Promtail
We will look at graphing Time Series data versus Non Time Series data
We will also install dashboards for each of the Data Sources, experimenting with community created dashboards plus experimenting with our own
We will monitor SNMP Devices using Telegraf Agent and InfluxDB Data Sources
We will create Annotation Queries and link the Log and Graphs panels together
We will look at Dynamic Dashboard Variables, Dynamic Tables, Dynamic Singlestats and Dynamic Graphs
We will look at creating Value Groups/Tags and how to use them with different kinds of data sources
We will set up an alerting channel, understand the different alerting options, configure an example of it to detect offline SNMP devices and demonstrate receiving email alerts via our local SMTP server
We will then create a dashboard for a 24 port Cisco Switch using methods applicable to both the Zabbix and the InfluxDB Data Sources
At the end of the course, you will have your own dedicated working Grafana Server, which will be in the cloud, with SSL, a domain name, with many example Data Sources and collectors configured, that you can call your own, ready for you to take it to the next level.
Once again, this is a Learn by example course, with all the example commands available for you to copy and paste. I demonstrate them working, and you will be able to do that to.
You are now ready to continue.
Thanks for taking part in my course, and i'll see you there.
Who this course is for:
- Network, Systems and Database Administrators
- Infrastructure Monitoring Specialists
- IT Platform Specialists
- DevOps Technicians
- Enthusiasts wanting a better understanding and better visibility of their networks in the home or office
- Someone who is curious and wants a good understanding of what Grafana does and what it's good at.
Course content
- Preview03:06
- 08:09Install Grafana
- 03:44Point Domain Name
- 03:54Reverse Proxy Grafana with Nginx
- 03:34Add SSL
- 03:02Create out First Data Source
- 02:02Panel Rows
- 03:52Panel Presentation Options
- 14:09Graph Panel : Visualisation Options
- 03:56Graph Panel : Fields & Overrides
- 04:41Graph Panel : Transformations
- 00:47Course Update Notice
- 03:36Stat Panel
- 02:05Gauge Panel
- 02:44Bar Gauge Panel
- 04:22Table Panel
- 05:32Create a MySQL Data Source
- Preview12:51
- Preview09:43
- 04:49Graphing Non Time Series SQL Data in Grafana
- 00:31Logs Panel
- 08:28Install Loki Binary and Start as a Service
- 07:26Install Promtail Binary and Start as a Service
- 04:56Install Loki Data Source and Explore
- 22:07LogQL
- 08:04Install a Second Promtail Service
- 04:00Annotation Queries Linking the Log and Graph Panels
- Preview13:05
- Preview04:50
- 03:59Install Prometheus Dashboard
- 10:44Setup Grafana Metrics Prometheus Dashboard
- 05:41Install Second Prometheus Node Exporter
- 07:14Install InfluxDB Server and Data Source
- 06:25Install Telegraf Agent and Configure for InfluxDB
- 04:52Install A Dashboard For Default InfluxDB/Telegraf Metrics
- 11:48Install SNMP Agent and Configure Telegraf SNMP Input
- 05:43Add Multiple SNMP Devices to Telegraf Config
- 01:18Import SNMP Dashboard that uses InfluxDB and Telegraf
- 08:28Create and Configure a Zabbix Data Source
- 06:10Import Zabbix Dashboards
- 05:39Create Advanced Custom Zabbix Dashboard
- 12:27Elasticsearch Data Source and Database
- 10:13Setup Elasticsearch Filebeat
- 13:02Setup Elasticseach Metricbeat
- 08:01Setup an Advanced Elasticsearch Dashboard
- 06:58Dashboard Variables
- 04:32Dynamic Table from Variables
- 02:32Dynamic Singlestats from Variables
- 03:49Dynamic Graphs from Variables
- 04:11Create an Email Alert Notification Channel
- 07:06Create Alerts for SNMP No Data
- 08:29Create a Custom Webhook Alert Notification Channel for SMS using AWS SNS
- 04:19Create Telegram Bot Alert Channel
- 05:52Value Groups/Tags with the Zabbix Data Source
- 12:18Value Groups/Tags with the InfluxDB/Telegraf Data Source
- 06:09Create a Cisco Switch Dashboard from the Zabbix Data Source
- 05:31Create a Cisco Switch Dashboard from the InfluxDB/Telegraf Data Source
- 09:10Disk Read/Write Rates Dashboard with the Zabbix Data Source
Instructor
Hello, I'm Sean.
For over 20 years I have been an IT engineer building and managing real time, low latency, high availability, asynchronous, multi threaded, remotely managed, fully automated, monitored solutions in the education, aeronautical, banking, drone, gaming and telecommunications industries.
I have also created and written hundreds of Open Source GitHub Repositories, Medium Articles and YouTube video tutorials.