I want to develop a web application for emetrics. The application will
analyse the traffic on a customer's site by inserting a small piece of
code on client's site.
I want to choose the right technology for this. Is MySQl right choice
for say 1000 sites each with 5000/day traffic. What should be the
database structure considerations and hosting consideration including
but not limited to data size point of view.Any other point I should
consider before starting the development.If, I could not clarify it
properly, please refer to deepmetrix.com that offers somewhat similar
solution.
Thanks

I'll tackle the question of what server first. MySQL is a wonderful
piece of software, and I cannot speak enoug praise of it. However,
1000 sites with 5000 hits a day amounts to some 5 million updates and
queries a day or more which works out to be 3472 per minute. If you
are serious about providing reliable service for customers, I would
highly recommend something more like Oracle, which has an enormous
amount of support that you can call upon if something goes wrong.
Oracle is also very well supported on a variety of platforms. If price
is a major factor, you could develop a database interface, or use a
currently existing one, and start out with MySQL with an eye to move
to Oracle at some point in the future when the amount of sql queries
gets to a very large number.

Now as for the question of database structure, that depends largely on
what exactly is required to keep track of, what types of queries are
to be run on the database and so on. About all I can think of on the
very general side is I would probably have each site in its own table,
and simply JOIN queries across tables if I need multiple tables.

Hope this helps you out some.

Aaron