Re: VirtualHost bandwidth management
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Thomas,
That is interesting, but I'm not the biggest fan of storing the logs in
a database. I like my logs clear text for ease of use. I know I could
write them both in the logs and in the db, but this seams overkill.
I do use mod_io and modified the logformat to show upstream and
downstream bandwidth usage for each request. The hard part is to
efficiently use this data for bandwidth control.
I can't get my head around how specialized shared hosting companies
enforce this. There has to be a way? Maybe there's a shaping appliance
or whatever, but I'd like to know what is is :) Preferably open source..
- --
Best regards, Met vriendelijke groet, Cordialement,
Steven Jacobs
UniWeb bvba
Thomas Goirand wrote:
> Steven Jacobs wrote:
>> Hi All,
>>
>> I'm looking for a way to measure data volume and bandwidth usage for
>> Apache virtualhosts. It would also be nice if we could throttle the
>> available bandwidth based on data volume usage.
>>
>> I would prefer the data to be available in a database so our developers
>> can provide customers with a webpage showing how much data volume has
>> been used.
>>
>> I tried many Apache modules for this purpose. Mod_cband used to work
>> fine, but it did not appear to work with MySQL databases. Since the
>> latest release of Debian, the Apache2 module mod_cband is no longer
>> available and the Etch version can be installed but does not seem to
>> work. Other modules do not provide the functionality I'm looking for.
>> Mod_bw makes it possible to limit bandwidth, but that's about it.
>>
>> Another thing I tried is to parse awstats data and put it in a database.
>> This would work, but how should I throttle the bandwidth dynamically?
>>
>> Also, we are planning to move all our vhosts to an LVS web cluster. A
>> few questions that arise are: what about statistics if many servers
>> serve the same pages? Which server should do the bandwidth measurement?
>
> Hi,
>
> Just use libapache2-mod-log-sql-mysql that I maintain, it will:
>
> - centralize all of your Apache logs in MySQL
> - maintain a monthly statistic MySQL table
>
> It is said to work with libdbi (that I also maintain), but I never
> tried, as I don't use it.
>
> All this is for bandwidth ACCOUNTING. Now if you need to do bandwidth
> throttling, then there are many other apache modules for this. The issue
> might be to connect the 2 together.
>
> Please let me know your findings, and if we don't find anything, then I
> think we might need to start to work on it (together?)! :)
>
> Thomas
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkoeUqQACgkQZ/DX0LN+5XVn2QCeLk6MZPYdLnXtmIhoqXUUvKSP
5jsAoIzCiNUmcHrH8u6RYgnaNkqXqy9V
=ylN6
-----END PGP SIGNATURE-----
Reply to: