Getting Data In

mysql service monitor

Jaina
New Member

Hi,

I need to monitor all the changes of a mysql server including data, tables, indexings and every thing. how can i do that?

Regards Amartya

Tags (1)
0 Karma

Jaina
New Member

Hi,

Thanks a lot for your reply.

Regards Amartya

0 Karma

southeringtonp
Motivator

Splunk doesn't really do database change monitoring directly, but there are a few ways to approach it.

Listed in order of preference:

  • Configure MySQL to log all queries, then have Splunk index the log file, and monitor for DDL commands (`CREATE`, `UPDATE`, `ALTER`, etc.).

  • Use a third-party database monitoring product that generates output in a text-based format that can be indexed by Splunk.

  • Roll your own using scripted inputs. Either generate snapshots from the database containing the information you want to monitor and use `diff`, or watch for the changes yourself. This option will likely be painful.


If you are going to go with the first option, these may help get you started:

     http://www.howtogeek.com/howto/database/monitor-all-sql-queries-in-mysql/

     http://www.electrictoolbox.com/logging-queries-with-mysql/

     http://dev.mysql.com/doc/refman/5.1/en/query-log.html

Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...