Database logging

Hello,

after looking searching the forum i came to the conclusion that logging directly to database through log4j is not recommended.

Wouldn’t it be better if we just created a simple Java module and log everything to a db with the ondisconnect() function ?(or something similar)

or send them to a queue (like rabbitmq or Amazon SQS) to be processed by an other task ?

You are correct that logging to mysql is not really recommended. We have several mechanisms for post log processing (can see our article for SawMill).

You can certainly write your own logger by using the variety of event handlers we do have.

Andy E

hello,

i am actually interested about getting real time bandwidth data so i can limit application connection based on traffic.

You think i can do that with a parser ?

Or i could just get connection bandwidth data from the ondisconnect() of each client and then trigger a block of the application ?

I did some testing on this (based on older forum posts) on version 3.6.4 and later on 4.0.x and indeed its not recommended. i got time outs and database connection issues pretty often, it doesnt reconnect. 2nd thing if you have quite some traffic on your server it will pile up quite some logs in your mysql database. You have to filter out quite some things in the log4jproperties. i quit the straight logging.

@Andy, what about support for Logstash. or do you only recommend Sawmill?

Hi,

With regards to log file parsing and analysis, we have the following article on how to integrate Wowza with Sawmill

We can also integrate with Google Analytics, which provides a very comprehensive stats reporting platform. You would need to install our ModuleAnalytics module and have a valid Google account. This article explains how to set this up,

Other log parsers that work with Wowza include:

CasterStats

WMSPanel

Chainsaw

sorry for the late response( i didnt get a notice about a reply). I will do some testing on the google analytics. im quite curious about how that works. Thx for the link

Hi,

@Andy, what about support for Logstash. or do you only recommend Sawmill?

With regards to log file parsing and analysis, we have the following article on how to integrate Wowza with Sawmill

We can also integrate with Google Analytics, which provides a very comprehensive stats reporting platform. You would need to install our ModuleAnalytics module and have a valid Google account. This article explains how to set this up,

Other log parsers that work with Wowza include:

CasterStats

WMSPanel

Chainsaw

Hi,

There is some information logged that could be used to show data usage but it’s not something that could be called “realtime” due to the nature of logging. The Users Guide lists each of the log fields that you could use to calculate those types of values. You could also investigate using the REST API to query these statistics.

If looking for a module method then this article has an example for HTTP and RTP streams. You could also look at IMediaStreamActionNotify2 and get IOPerformanceCounter stats when a client stops playing a stream at the onStop event.

Paul