LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-31-2016, 05:41 AM   #1
shipon_97
Member
 
Registered: Oct 2005
Location: Bangladesh
Posts: 484

Rep: Reputation: 30
configure rsyslog with oracle database


Dear Friends ,

I wanna configure a centralize rsyslog server where the log message stores onto oracle database .

Is it possible to do it ?

Need your kind assistance please .....
 
Old 05-31-2016, 07:45 AM   #2
jpollard
Senior Member
 
Registered: Dec 2012
Location: Washington DC area
Distribution: Fedora, CentOS, Slackware
Posts: 4,599

Rep: Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241
The simple answer is "Yes, it can be done".

But that doesn't mean it is necessarily easy to do.

Part of the problem is that messages can come in FAST... and the data has to be read and stored at least as fast as it comes in. This introduces a problem with the database - which doesn't do well with bursts of high traffic input.

I would suggest first start trying process records from rsyslog written to disk, then add them to the database. This allows you to use the disk file as LARGE cache of input that will catch the data. If you use a method similar to "tail -f", you will be able to read and process the data as fast as you can (and even catch up to rsyslog production) without loosing the data.

When this works, you can even add the ability to periodically direct rsyslog to start a new file, the data base process can then finish the current one, start processing the new one. And the old file could be either archived (at first), and then deleted, thus making the used disk space available for for messages.

If you can ALWAYS keep up with the data (even to the point of implementing your own caching file if necessary) you can modify the rsyslog configuration to pass the data to your process instead of writing it to disk...

Last edited by jpollard; 05-31-2016 at 07:46 AM.
 
Old 05-31-2016, 07:52 AM   #3
shipon_97
Member
 
Registered: Oct 2005
Location: Bangladesh
Posts: 484

Original Poster
Rep: Reputation: 30
Thx Pollard for your reply .

Your suggestion is very helpful for me . But it will more helpful if you give any document or any suggested link so that I can follow your guideline for implementing the rsyslog server .
 
Old 05-31-2016, 10:01 AM   #4
jpollard
Senior Member
 
Registered: Dec 2012
Location: Washington DC area
Distribution: Fedora, CentOS, Slackware
Posts: 4,599

Rep: Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241
Quote:
Originally Posted by shipon_97 View Post
Thx Pollard for your reply .

Your suggestion is very helpful for me . But it will more helpful if you give any document or any suggested link so that I can follow your guideline for implementing the rsyslog server .
Google is your friend:

http://www.rsyslog.com/doc/v8-stable...ion/index.html
http://wiki.rsyslog.com/index.php/Configuration_Samples

and finally:
http://wiki.rsyslog.com/index.php/Rs..._or_mongodb%29
 
1 members found this post helpful.
Old 06-02-2016, 02:15 PM   #5
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,916

Rep: Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689
Quote:
Originally Posted by shipon_97 View Post
Thx Pollard for your reply .

Your suggestion is very helpful for me . But it will more helpful if you give any document or any suggested link so that I can follow your guideline for implementing the rsyslog server .
You have been here ELEVEN YEARS now....you should know the LQ Rules about not using text-speak. You should also be aware of the "Question Guidelines"...asking people to look things up for you, and send you links is fairly rude. You need to show SOME effort of your own.
 
Old 06-02-2016, 03:25 PM   #6
jpollard
Senior Member
 
Registered: Dec 2012
Location: Washington DC area
Distribution: Fedora, CentOS, Slackware
Posts: 4,599

Rep: Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241
Not to mention that last link is EXACTLY what you asked for...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to configure in redhat os level cluster for Oracle database manishrmusale Linux - Server 2 04-07-2013 05:00 AM
need to configure autostart of oracle database and oracle soa suite on linux bootup sumit.tambekar Linux - Newbie 2 01-24-2011 08:35 PM
Configure failover for rsyslog kenneho Linux - Server 1 01-28-2009 08:39 AM
LXer: Oracle(R) Database Standard Edition One and Oracle Enterprise Linux on HP Set New World Record for Price Performance with TPC-C Benchmark LXer Syndicated Linux News 0 06-12-2007 06:01 PM


All times are GMT -5. The time now is 10:39 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration