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...