Book Image

Mastering Kibana 6.x

Book Image

Mastering Kibana 6.x

Overview of this book

Kibana is one of the popular tools among data enthusiasts for slicing and dicing large datasets and uncovering Business Intelligence (BI) with the help of its rich and powerful visualizations. To begin with, Mastering Kibana 6.x quickly introduces you to the features of Kibana 6.x, before teaching you how to create smart dashboards in no time. You will explore metric analytics and graph exploration, followed by understanding how to quickly customize Kibana dashboards. In addition to this, you will learn advanced analytics such as maps, hits, and list analytics. All this will help you enhance your skills in running and comparing multiple queries and filters, influencing your data visualization skills at scale. With Kibana’s Timelion feature, you can analyze time series data with histograms and stats analytics. By the end of this book, you will have created a speedy machine learning job using X-Pack capabilities.
Table of Contents (21 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Index

Configuring Logstash for database input


I am taking the example of a blog website that is built using a MySQL database. Basically, we are going to configure Logstash using JDBC input plugin to connect with a MySQL database. After connecting to the MySQL database, we will run the query to fetch the records from the database and will push that record into the Elasticsearch index.

Basically, a blog website is running using the data from the MySQL database and I don't want to change anything in my application, but I still want to get the insight of the blog data. This is an ideal situation where Elastic Stack can do the magic, as we just need to connect to the MySQL database and run a query to get the data; once the data is in, we can create a query that can be scheduled to get the new and updated records. Once this architecture is in place, we can test it by inserting a new record into the database and ensuring that record is also inserted into Elasticsearch.

Once we are getting the data from...