Results 1 to 7 of 7

Thread: Database logging

  1. #1

    Default 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 ?

  2. #2
    Join Date
    Jan 2016
    Posts
    74

    Default

    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

  3. #3

    Default

    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?

  4. #4

    Default

    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
    Last edited by Paul_S; 04-07-2016 at 11:25 AM.

  5. #5

    Default

    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 ?

  6. #6

    Default

    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

  7. #7

    Default

    Quote Originally Posted by Paul_S View Post
    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

Similar Threads

  1. Logging player counts to database
    By wtoolbox in forum Showcase
    Replies: 2
    Last Post: 06-07-2014, 01:55 PM
  2. Logging to a MySQL Database only some events
    By Luca066 in forum General Forum
    Replies: 7
    Last Post: 10-27-2011, 07:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •