Book Image

Learning Elastic Stack 7.0 - Second Edition

By : Pranav Shukla, Sharath Kumar M N
Book Image

Learning Elastic Stack 7.0 - Second Edition

By: Pranav Shukla, Sharath Kumar M N

Overview of this book

The Elastic Stack is a powerful combination of tools that help in performing distributed search, analytics, logging, and visualization of data. Elastic Stack 7.0 encompasses new features and capabilities that will enable you to find unique insights into analytics using these techniques. This book will give you a fundamental understanding of what the stack is all about, and guide you in using it efficiently to build powerful real-time data processing applications. The first few sections of the book will help you understand how to set up the stack by installing tools and exploring their basic configurations. You’ll then get up to speed with using Elasticsearch for distributed search and analytics, Logstash for logging, and Kibana for data visualization. As you work through the book, you will discover the technique of creating custom plugins using Kibana and Beats. This is followed by coverage of the Elastic X-Pack, a useful extension for effective security and monitoring. You’ll also find helpful tips on how to use Elastic Cloud and deploy Elastic Stack in production environments. By the end of this book, you’ll be well-versed with fundamental Elastic Stack functionalities and the role of each component in the stack to solve different data processing problems.
Table of Contents (17 chapters)
Free Chapter
Section 1: Introduction to Elastic Stack and Elasticsearch
Section 2: Analytics and Visualizing Data
Section 3: Elastic Stack Extensions
Section 4: Production and Server Infrastructure

Setting up the metadata database

We need to have a database that has metadata about the sensors. This database will hold the tables that we discussed in the Introduction to the application section.

We are storing the data in a relational database MySQL, but you can use any other relational database equally well. Since we are using MySQL, we will be using the MySQL JDBC driver to connect to the database. Please ensure that you have the following things set up on your system:

  1. MySQL database community version 5.5, 5.6, or 5.7. You can use an existing database if you already have it on your system.
  2. Install the downloaded MySQL database and log in with the root user. Execute the script available
  3. Log in to the newly created sensor_metadata database and verify that the three...