Hi artist

The first pointer would naturally be mysql's documentation :)
But since you will be dealing with loads of data, I'll leave here pointers to some specifics on architecture solutions implemented by others.

MySQL and Web2, maybe some marketing stuff, but maybe some things to learn form the links.
Maximum velocity MySQL presentation.
Mod_Perl's team recommended reading
And I know there is a very interesting presentation by Tim Bunce, but I can't seem to find the link.

update: actually, Tim has several talks on CPAN