Welcome back to another video we in this video we will be taking a look at How to Load/Import Data from MySQL Server to Elasticsearch and then use Kibana to view the data.

Logstash Conf: https://gist.github.com/OsamaMahmood/c86140b0f8ea086e85224e3412f315bc

=========================================== Commands to create the schema:

create schema jobschema;

create table jobschema.jobdata( jobid integer, jobname varchar(45), executiontime integer, jobstatus varchar(45) );

insert into jobschema.jobdata values (1,"job1",10,"Completed"); insert into jobschema.jobdata values (2,"job2",15,"Failed"); insert into jobschema.jobdata values (3,"job3",15,"Failed"); insert into jobschema.jobdata values (4,"job4",15,"Failed"); insert into jobschema.jobdata values (5,"job5",30,"Failed"); insert into jobschema.jobdata values (6,"job6",10,"Failed"); insert into jobschema.jobdata values (7,"job7",10,"Completed");

Social networks: https://thelinuxos.com/ https://www.youtube.com/c/OsamaMahmood https://www.snapchat.com/add/osamamahmood00 https://facebook.com/thelinuxosblog https://twitter.com/MeiHacker https://www.instagram.com/osama_mahmood00/

Disclaimer: All information and software available on this site are for educational purposes only. Use these at your own discretion, the site owners cannot be held responsible for any damages caused. The views expressed on this site are our own and do not necessarily reflect those of our employers. If you don't know how to attack, you will not know how to defend it. ... https://www.youtube.com/watch?v=85B5hOm4a90