I am considering moving my existing script which is downloaded to be a hosted script. One of the things it does is to keep track of some stats. My concern is with heavy hitters (100,000 pageviews/month on up), it might tax my mysql process.
I'm currently using a VPS, which would be just to start with. My question is...
How do I best plan ahead for an easy/smooth transition to another mysql server if load gets too high?
Thanks for any advice, it's appreciated.