Help build the future of open source observability software Open positions

Check out the open source projects we support Downloads

Grot cannot remember your choice unless you click the consent notice at the bottom.

timeShift(GrafanaBuzz, 1w) Issue 41

timeShift(GrafanaBuzz, 1w) Issue 41

April 20, 2018 7 min

Welcome to TimeShift

The big news this week is the release of Grafana v5.1.0-beta1. This beta release adds a number of features and enhancements including MSSQL support, additional alerting notification channels, improved dashboard provisioning functionality and some important UX fixes – most notably, the recently reported page scrolling issue.

The Grafana Labs team will also hit the road for a few weeks starting with Percona Live in Santa Clara, CA, April 23-25 which we are speaking at and sponsoring, followed by KubeCon + CloudNativeCon Europe 2018 in Copenhagen, Denmark, May 2-4, which we are also speaking at and sponsoring. We hope we get a chance to say hi to you at one of these conferences. You can see all of our upcoming events here.


Latest Beta Release

Grafana 5.1.0-beta1 is available for download. Major enhancements include:

  • MSSQL: New Microsoft SQL Server data source #10093, #11298, thx @linuxchips
  • Prometheus: The heatmap panel now supports [Prometheus](/oss/prometheus/) histograms #10009
  • Postgres/MySQL: Ability to insert 0s or nulls for missing intervals #9487, thanks @svenklemm
  • Postgres/MySQL/MSSQL: Fix precision for the time column in table mode #11306
  • Graph: Align left and right Y-axes to one level #1271 & #2740 thx @ilgizar
  • Graph: Thresholds for Right Y axis #7107, thx @ilgizar
  • Graph: Support multiple series stacking in histogram mode #8151, thx @mtanda
  • Alerting: Pausing/un alerts now updates new_state_date #10942
  • Alerting: Support Pagerduty notification channel using Pagerduty V2 API #10531, thx @jbaublitz
  • Templating: Add comma templating format #10632, thx @mtanda
  • Prometheus: Show template variable candidate in query editor #9210, thx @mtanda
  • Prometheus: Support POST for query and query_range #9859, thx @mtanda
  • Alerting: Add support for retries on alert queries #5855, thx @Thib17
  • Table: Table plugin value mappings #7119, thx infernix
  • IE11: IE 11 compatibility #11165
  • Scrolling: Better scrolling experience #11053, #11252, #10836, #11185, #11168
  • Docker: Improved docker image (breaking changes regarding file ownership) grafana-docker #141, thx @Spindel, @ChristianKniep, @brancz and @jangaraj
  • Folders: A folder admin cannot add user/team permissions for folder/its dashboards #11173
  • Provisioning: Improved workflow for provisioned dashboards #10883

Check out the full release notes to see the features and fixes in the beta release. We also have updated documentation for the new version.

Download Grafana 5.1.0-beta1 Now


From the Blogosphere

How Grafana and the open source community came together: A nice rundown of our recent GrafanaCon from two attendees. In this post, they discuss conference highlights and share some of their favorite anecdotes during the event.

Network Monitoring with Prometheus and Cumulus Linux: Learn how to monitor Cumulus Linux switches, report metrics to Prometheus, and visualize them with Grafana. For reference on how to install and configure Prometheus and Grafana, read his previous post.

Visualizing IoT devices with Akka and Grafana. ScalaUA2018: In this video from a talk at ScalaUA2018, Willem discusses how to use Akka to collect metrics from multiple smart devices and visualize the data in Grafana. Speaking of monitoring smart devices, Erwin de Keijzer gave a great talk at GrafanaCon on monitoring the power consumption of his smart washing machine.

TTN Gateway + Monitoring with Resin.io: If you’re into the Internet of Things you may be familiar with The Things Network (TNN). This post walks you through how to monitor a TNN gateway with InfluxDB and Grafana.

Best SecOps Tools: 50 Must-Have Tools For Your SecOps Arsenal: Threat Stack put together a list of the top 50 most useful tools for SecOps teams, and Grafana was listed as number 1 in the dashboards category!



Grafana Plugins

Lots of plugin updates to share this week. If you’re using on-prem Grafana, update and install plugins with the grafana-cli tool, for Hosted Grafana, update with one-click.

NEW PLUGIN

Parity Report Panel - This new panel allows you to compare series, calculate the difference and set thresholds based on the difference. For example, if serie A returns 10 and serie B returns 15 then the difference is 50%. If you set the threshold to 20% then this would be visualized as an error. You can create your own advanced comparison functions using mathjs.

Install

NEW PLUGIN

Boom Table Panel - This new panel is a multistat panel for the Graphite data source. To learn more about this, check out the Boom Table site.

Install

UPDATED PLUGIN

NetCrunch App - This latest release adds support for template queries. This allows filtering of network nodes for specific Network Atlas View or Monitoring Pack.

Update

UPDATED PLUGIN

AppDynamics Datasource - The Premium plugin for AppDynamics received the following updates:

  • Adds Top X functionality
  • Fixes import dashboards with templates
  • Adds Server Visibility Metrics support
  • Adds Value/Min/Max/Sum options
  • Adds Time Offset functionality

Update

UPDATED PLUGIN

Organisations Panel - This panel can be added to a dashboard and used to switch to another organization in Grafana. It received an update to make it work with Grafana 5.0.

Update

UPDATED PLUGIN

Clickhouse Datasource - The very actively maintained Clickhouse Data Source plugin has been updated with some fixes including:

  • Fix broken AST when using nested SELECT without FROM statement
  • Strict statement matching
  • Rebuild queries from AST only if adhoc filters were applied

Update



Upcoming Events

In between code pushes we like to speak at, sponsor and attend all kinds of conferences and meetups. We also like to make sure we mention other Grafana-related events happening all over the world. If you’re putting on just such an event, let us know and we’ll list it here.

Percona Live 2018 | Santa Clara, CA - April 23-25, 2018:
Raj Dutt - metrictank: Building a New Time Series Engine for GrafanaCloud
Time series databases are sprouting up like mushrooms. At Grafana Labs, we built a new engine specifically for GrafanaCloud. Why would we do that? Learn about the design considerations, lessons learned, and tradeoffs we made in designing this engine that is compatible with both Graphite and Prometheus.

Register Now

KubeCon + CloudNativeCon Europe 2018 | Copenhagen, Denmark - May 2-4, 2018:
Tom Wilkie – Prometheus Monitoring Mixins: Using Jsonnet to Package Together Dashboards, Alerts and Exporters
In this talk we present a technique for using Jsonnet (a configuration language from Google) for packaging and deploying “Monitoring Mixins” - extensible and customizable combinations of dashboards, alert definitions and exporters. This technique allows developers of open source projects to publish best-practice monitoring configurations alongside their code, and for users to consume it, customize it and stay up to date. We will present example Mixins for Kubernetes and other services such as Consul and Cassandra.

Goutham Veeramanchaneni - The Engine behind Prometheus
This talk will introduce TSDB, its high-level usage and guarantees, and will show people how, with a little Go knowledge, they can introduce a solid time-series database into their stack.

Goutham Veeramanchaneni - TSDB: The Past, Present and the Future
TSDB is the storage engine that powers Prometheus 2.0 and brought most of the drastic improvements in speed and utilization across the board. But it is also a golang library that Prometheus imports and is a solid time-series database that anyone can use.
It is undergoing active development and this talk will take you through the journey, benchmarks, new features, ghastly bugs and moonshot ideas. This will also help the audience understand the library and hopefully get them to use and contribute to it.

We're also sponsoring KubeCon + CloudNativeCon as a Startup Sponsor. Swing by our booth to learn how to monitor Kubernetes with GrafanaCloud.

Register Now

Monitorama 2018 PDX | Portland, OR - June 4-6, 2018:
Join us again to hear talks from industry experts and community leaders discuss the newest approaches in monitoring and observability. Find out which tools and techniques are in use at some of the largest web architectures in the world.

Register Now

`

InfluxDays London 2018 | London, United Kingdom - June 14, 2018:
Join us as we sponsor two days of technical talks around Telegraf, InfluxDB, Chronograf, Kapacitor, Grafana and adjacent technologies.

Register Now

Tweet of the Week

We scour Twitter each week to find an interesting/beautiful dashboard or monitoring related tweet and show it off! #monitoringLove
		<p>I'd love to see this streaming in real time.</p>
	</div>
</div>

Grafana Labs is Hiring!

We are passionate about open source software and thrive on tackling complex challenges to build the future. We ship code from every corner of the globe and love working with the community. If this sounds exciting, you're in luck – WE'RE HIRING!

Check out our Open Positions



#### See You Next Week! Thanks for reading another issue of timeShift. What would you like to see here? Submit a comment on this issue below, or post something at our [community forum](https://community.grafana.com?utm_source=blog&utm_campaign=timeshift_41).

Follow us on Twitter, like us on Facebook, and join the Grafana Labs community.