topic Re: Difference between splunk DB connect and Splunk MYSQL connector in Knowledge Management

Difference between splunk DB connect and Splunk MYSQL connector

rupali12 — Tue, 12 Feb 2013 06:12:48 GMT

What is the Difference between splunk DB connect and Splunk MYSQL connector?

Re: Difference between splunk DB connect and Splunk MYSQL connector

stefano_guidoba — Tue, 12 Feb 2013 08:10:54 GMT

Hi Rupali,

directly taken from Splunk MySQL Connector page: *The Splunk DB Connect app does everything this one does and more! *

Basically, as I'm currently using Splunk DB Connect, I can say that it's an easy interface to connect to every database. We've used it for MS SQLServer, MySQL, Oracle and, adding a jar from IBM, DB2, without any issues.
I suggest you should try and use it, instead of Splunk MySQL Connector.
Regards,

Stefano

Re: Difference between splunk DB connect and Splunk MYSQL connector

rupali12 — Tue, 12 Feb 2013 09:45:06 GMT

ok.Thanks for ur rply.

Re: Difference between splunk DB connect and Splunk MYSQL connector

jpass — Wed, 20 Feb 2013 19:54:38 GMT

I've used both over the past 7 or 8 months. I no longer need MySQL Connector.

The MYSQL Connector was useful for exploring databases & querying data. But it fell short of doing what I really wanted to do which was monitor & index events stored in databases. You can't create inputs with MySQL connector. For example, say you keep your logs in a database table that's updated constantly. You wouldn't be able to automatically monitor & index that data with MySQL Connect. Sure, you can explore your tables & query the data from Splunk with MySQL COnnector.

With Splunk DB Connector you can create inputs. It's not much different than pointing Splunk at a directory to index log files that reside there.

DB Connect also allows you to easily connect different kinds of databases. I think MySQL Connector mainly targets....you know...MySQL 🙂

Re: Difference between splunk DB connect and Splunk MYSQL connector

rupali12 — Thu, 21 Feb 2013 03:41:01 GMT

ok Thanks for ur rspns. 🙂