Kibana-MySQL connection


(srinu konda) #1

Hi All,

I need help on kibana, I need to Connect MySQL Database from Kibana. So
please let me know I can achieve it, and me pseudo code if anyone can have
it.

Thanks & Regards,
Srinivas.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/13cb6155-12e2-4ec5-952c-7f1996527903%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Tomislav Poljak) #2

Hi Srinu,
Kibana is javascript search/visualisation front-end for elasticsearch
which is a distributed search engine which doesn't feature mysql
connection/integration out of the box. But, there is a plugin
https://github.com/jprante/elasticsearch-river-jdbc which you can use
to import data from mysql to elasticsearch and then use Kibana to
visualise it.

So steps would be:

  1. Deploy elasticsearch
  2. Install jdbc plugin with mysql driver in elasticsearch
  3. Create and submit jdbc river configuration (with mysql connection
    data and import query) which will import the data
  4. Deploy kibana and visualise data

Hope this helps,
Tomislav

2014-06-06 10:02 GMT+02:00 srinu konda konda.srinu89@gmail.com:

Hi All,

I need help on kibana, I need to Connect MySQL Database from Kibana. So
please let me know I can achieve it, and me pseudo code if anyone can have
it.

Thanks & Regards,
Srinivas.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/13cb6155-12e2-4ec5-952c-7f1996527903%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CALuCJxjL%2B0zCCHct0-BVn2Z%2BiaCHFLEGj4YD1NioG7Td%2Bz5FrQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


Is it possible to show mysql query result in Data Table Visualization?
(system) #3