Quote:
Originally Posted by TACNet
For scaleablitiy, I'd be careful about writing your data directly to your MySql tables
We had the same issue when putting together our affiliate tracking scripts. It only takes one bot to start hammering your pages and it will down your DB server
We found a far better approach is to write everything to a log file first and then setup a cron script to process that log file every 15 minutes or whatever. That way you can filter out duplicates, bot scripts etc etc
Hope that helps
|
why aren't you replicating to mirror servers? front-end users shouldn't be hitting your primary db server.
i use flat file data for almost everything. i only use mysql if a table gets huge.
traffic stats definitely don't deserve mysql lol
#