Getting Data In

Is it possible to use Splunk forwarder to send data from mysql ?

dragosluca
Engager

Is it possible to use Splunk forwarder to send data from MYSQL ?

Tags (3)
0 Karma
1 Solution

sowings
Splunk Employee
Splunk Employee

If you can write a script to get data from mysql, you can get it into Splunk.

The usual way might be to use a shell script calling the mysql interpreter with your desired SELECT statement, returning the rows to STDOUT. Splunk would then index the data being output by the script. Inspecting the database directly from a Splunk script might be just a bit trickier, as I don't know whether a database connector for mysql is included in the Splunk Python library.

View solution in original post

0 Karma

dmaislin_splunk
Splunk Employee
Splunk Employee

This is my favorite app: http://splunk-base.splunk.com/apps/50803/dbx-sql-database-extension. No forwarder required and simple to use. You can do lookups, browse databases, update Splunk indexes from a database, and update the database from Splunk. You should definitely check it out!

gkanapathy
Splunk Employee
Splunk Employee

As of right now (Oct 3 2012) this app is not downloadable. however, a less rich app (that requires a bit more work) is http://splunk-base.splunk.com/apps/27105/jdbc-scripted-input

0 Karma

alacercogitatus
SplunkTrust
SplunkTrust

It is possible to use a Splunk Forwarder to send data from mysql, but it involves a scripted input. Input configurations are found here: http://docs.splunk.com/Documentation/Splunk/latest/Admin/Inputsconf. I would call a perl or python script and use that to pull in the data.
Example: http://www.tutorialspoint.com/python/python_database_access.htm

0 Karma

sowings
Splunk Employee
Splunk Employee

If you can write a script to get data from mysql, you can get it into Splunk.

The usual way might be to use a shell script calling the mysql interpreter with your desired SELECT statement, returning the rows to STDOUT. Splunk would then index the data being output by the script. Inspecting the database directly from a Splunk script might be just a bit trickier, as I don't know whether a database connector for mysql is included in the Splunk Python library.

0 Karma

gkanapathy
Splunk Employee
Splunk Employee
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Observability Simplified: Combining User Experience, Application Performance & ...

Tech Talk Observability Simplified: Combining User Experience, Application Performance & Network ...

Event Series May & June: From Network Visibility to Service Intelligence

Unifying the Network: Moving from Alert Noise to Service Intelligence with Splunk ITSI In today’s hybrid ...