[syslog-ng]buffering during network outage between relays
Martin, Sylvain R. (LNG)
Sylvain.Martin@lexisnexis.com
Tue, 29 Jan 2002 16:12:27 -0500
We're logging the data to a central database from 2 relays. Is there a way
for syslog-ng to buffer the data while the database server is rebooting or
innaccessible?
Here's our current setup.
All machines forward the syslog msg to either a production or development
relay which runs syslog-ng and then
the messages are forwarded to a server running an oracle DB. You may wonder
why we have 2 relays... well we have
a few hundrer servers and workstations and we're just implementing the DB
aspect of it.
15 Millions rows for 6months growing by 100K rows/day.
on the DB server I have a custom written syslogd which buffers data in case
the DB is down but the problem resides with syslog-ng interrupting the
relay, for 60 seconds, of messages to the oracle DB server if the server
dies or reboots. Is there someway for syslog-ng to relay missed messages?
The only other way I can think of doing it is kinda messy... having
syslog-ng dump to a FIFO pipe where a perl script could buffer the data in
an array or file until the DB server comes alive again. We're using 1.4.14
--------------------
- Cloud of servers -
--------------------
/ \
/ \
-------- -------
relays - prod - - dev -
-------- -------
\ /
\ /
-------------
- oracle DB -
-------------
Sylvain Martin