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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...