Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
You need to find out first what makes the load get too high so that you are able to plan ahead.
If its IO bound then you need faster disks. If its memory bound then you need to add more memory or find ways to reduce its usage.
The best way to find out what the problem is, is to track your system during a peak time. Get a graphing application and look for:
Also keep track of your SHOW STATUS info and see what are the differences. Try to notice patterns, find the bottlenecks and predict scalability issues.
For example, if you system is currently doing 100,000 transactions per minute and your bottlenecks are at 75% capacity, then if your TPM increase it to 140,000 your system might crash/stall/lagg/die-a-horrible-death.
