Cassandra to Kibana

[Karthik2411]

I am trying to constantly check the status of cassandra for every one hour and send all the information into kibana so that I can create a watcher that reports whenever I find a failure in the log. Would it be possible for logstash to send this information from cassandra to Kibana on a daily basis. If yes what are the steps I need to follow.Please reply.

[Vadims_Daleckis (Vadim)]

I'm not sure if that would solve your problem, but you could configure Elastic Packetbeat for Cassandra: https://www.elastic.co/guide/en/beats/packetbeat/master/configuration-cassandra.html

Here is a description of Packetbeat: https://www.elastic.co/guide/en/beats/packetbeat/master/packetbeat-overview.html

[Karthik2411]

Hello @Vadims_Daleckis,

Thanks for the reply. I wan't sure about the way I want to do this when I posted the question initially. Now I have decided that I want to use an existing logstash server after reading this article "https://www.elastic.co/blog/logstash-jdbc-input-plugin". I have written a JSON and now I am confused where exactly I need to put this JSON in order to fulfill the requirement. Please throw some light on this if you could. The following is the JSON:

file: simple - out.conf

input {
jdbc {
# cassandra jdbc connection string to our database, BTS
jdbc_connection_string => "jdbc:cql://localhost:173.39.231.46/BTS"
# The user we wish to execute our statement as
jdbc_user => "cassandra"
# The path to our downloaded jdbc driver
jdbc_driver_library => "/path/to/cql-3.2.1-1201.jdbc41.jar"
# The name of the driver class
for cqlsh
jdbc_driver_class => "org.apache.cassandra.cql.jdbc.CassandraDriver"
# our query
statement => "cqlsh --cqlversion 3.2.1 173.39.231.46-u pcia_rw -p hyT%sD3z1KAq25eY -k ks_amer_pda"
}
}
output {
stdout {
codec => json_lines
}
}