Blogs

RedMonk

Skip to content

Guess I’ll Be Outsourcing My Logging


1and1’s Policies for MySQL DB’s

Originally uploaded by sogrady.

So as mentioned yesterday, given our recent and dramatic spike in traffic, I’ve been looking for some more flexible stats packages to better digest just what the hell is going on with our site. In the course of my meanderings, I ran across several mentions of a newly released package called Mint.

While in some respects it appears to be pretty indistinguishable from other stats packages, it has two features that are pretty sweet as far as I’m concerned: the ability to serve up various results via RSS, and more importantly, a pluggable architecture that allows for the extension of functionality through add-on modules, called Peppers.

Pretty much on the basis of those two features alone I was sold (I expect the referrer spam filtering, which Statcounter provides but 1and1’s tools do not), and I created a new MySQL database on our 1and1 box and ran through the very simple compatability app Mint offers, with the results coming back all systems go.

Just before I went to purchase Mint, though, I ran across this warning on 1and1’s MySQL administration page that I’d never really noticed before:

“Please note that the MySQL database may not under any circumstances be used for log evaluation operations, ad clicks, chat systems, banner rotations, or similar applications putting extreme loads on the database.”

Javascript loads for each page view, with our new traffic levels? Seems like that might be a bit of an “extreme load.” Which is disappointing, because that leaves Statcounter as my only real option, given that any logging application is seemingly against the rules. I like Statcounter, but for the traffic we’re now seeing, it’s simply not economical. If I had more availability, this might be where I switch us off 1and1’s infrastructure over to something more developer friendly like Textdrive, but as things are that’ll have to wait. Meantime, you might give Mint a look if you have free reign on your box.

Categories: Product Announcements.

  • http://www.unto.net/unto/ DeWitt Clinton

    Stephen,

    If you consider changing hosts, I've been very happy with John Companies. I decided to go with them in part because of the comments in this post:
    http://www.unto.net/unto/meta/please-stand-by/

    (You recommended 1and1 here, too.)

    They gave me straight answers to my questions and the price/performance is excellent.
    Cheers,

    -DeWitt

  • http://baus.net/ christopher baus

    I would seriously consider reading http://status.textdrive.com/ before selecting them as your host.

  • http://www.redmonk.com/sogrady stephen o'grady

    DeWitt: thx for the tip. if/when i get a chance to look at migrating, i'll definitely give them a look. if they're working for you, i'm sure they're good enough for us.

    christopher: interesting. i do subscribe to some of the Textdrive blogs, and thus had assumed that some o fthe uptime challenges would have been fixed by the recent datacenter relocation, but perhaps not. thx for the tip.

  • sdf

    how about one of 1&1's root servers? you can punish your own mysql servers as much as you like…
    and those servers don't cost much anymore.