Due to some uptime issues, I will need to migrate my site from my current host to another. My site is hosted on a VPS which receives lac's of mysql queries everyday. But, in future my site is definitely gonna expand, so the mysql queries. My simple question is that, can a single dedicated web server handle the mysql queries if it goes to Millions everyday ? I don't want any downtime and the performance should be optimum.
-
-
As per your records, currently you are getting lakhs of MySQL queries everyday. Let's assume that you might get 2 millions of MySQL queries a day in future. Let's calculate, break the 2 millions into per hour (ie. 8,33,333), now break it into per minute (ie. 13,888 ) and finally break it into per second (ie. 231 queries/sec).
So, If the requests coming to the server are simple then you will need a server that can handle about 250 queries per second. Our quad core dedicated server is capable of handling such loads and offers 100% uptime guarantee. Even if in future your site's MySQL queries goes above 2 Millions you can upgrade the plan to the Dual Quad Core or Dual - Hexa Core servers to receive desired performance. -
Yes, of course, the mysql database queries coming to the server will be simple queries. Also, what kind of security is provided for ensuring no data loss ?Comment
-
To enhance data security, you can opt for RAID enabled dedicated servers, if not then get yourself a Backup package that would ensure security of your website data.Comment
MattBarthorp
Comment