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.
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
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
# cassandra jdbc connection string to our database, BTS
jdbc_connection_string => "jdbc:cql://localhost:22.214.171.124/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
jdbc_driver_class => "org.apache.cassandra.cql.jdbc.CassandraDriver"
# our query
statement => "cqlsh --cqlversion 3.2.1 126.96.36.199-u pcia_rw -p hyT%sD3z1KAq25eY -k ks_amer_pda"
codec => json_lines
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.