Massive Mysql Usage - Recommendations
Our site currently uses InvisionPowerBoard and have around 550+ users on at peak times in a 60 minute interval. The site and forums are integrated together and the server load buckles at times.We have already looked at using other software, but choose not to go that route because we have spent months working on the different codings using InvisionPowerBoard.
We have a 2.8 ghz server with hyperthreading and 1024 ram.
We are going to be expanding soon and using the same database we are planning on adding a different site of the same size.
So in essence, we will double the use of this one single mysql database if not more. What is recommended to handle such a load? What type of server upgrade or load balacing?
Thanks much.