Fli
04-05-2013, 11:12 PM
You website is too big for Your current server?
There you may find usefull these options:
- let optimise your website scripting, mysql orders, and other site aspects (http://www.webpagetest.org/)
- buy "larger" server
- use LiteSpeed Enterprise (http://www.litespeedtech.com/web-server-performance-comparison-litespeed-2.1-vs.html) instead of apache (around 2 times better performance)
- use several SSD drives, one drive OS, one drive cache/bin/logs, one drive web files
- move Your mysql database to a new server bought specially for mysql (preferrably in same datacenter)
- move static files to separate server (or use Content Delivery Network), move httpd(apache) to second server and mysql to third server
Here is more about fourth step - splitting the site between two servers. First old server manages data, second newly bought server is database server. How we connect old sever to a new one?
mysql> CREATE USER 'MY_USERNAME'@'localhost' IDENTIFIED BY 'MY_PASSWORD'
mysql> GRANT ALL PRIVILEGES ON 'MY_DATABASE'.* TO 'MY_USERNAME'@'12.34.56.78' IDENTIFIED BY 'MY_PASSWORD';
We can simply edit localhost value in our website configuration file where we have mysql database login credentials. This can be changed to an IP address of new server.
Here is the guide how to allow incoming request on new mysql server:
http://cp.powerchaos.com/knowledgebase.php?action=displayarticle&id=19
There you may find usefull these options:
- let optimise your website scripting, mysql orders, and other site aspects (http://www.webpagetest.org/)
- buy "larger" server
- use LiteSpeed Enterprise (http://www.litespeedtech.com/web-server-performance-comparison-litespeed-2.1-vs.html) instead of apache (around 2 times better performance)
- use several SSD drives, one drive OS, one drive cache/bin/logs, one drive web files
- move Your mysql database to a new server bought specially for mysql (preferrably in same datacenter)
- move static files to separate server (or use Content Delivery Network), move httpd(apache) to second server and mysql to third server
Here is more about fourth step - splitting the site between two servers. First old server manages data, second newly bought server is database server. How we connect old sever to a new one?
mysql> CREATE USER 'MY_USERNAME'@'localhost' IDENTIFIED BY 'MY_PASSWORD'
mysql> GRANT ALL PRIVILEGES ON 'MY_DATABASE'.* TO 'MY_USERNAME'@'12.34.56.78' IDENTIFIED BY 'MY_PASSWORD';
We can simply edit localhost value in our website configuration file where we have mysql database login credentials. This can be changed to an IP address of new server.
Here is the guide how to allow incoming request on new mysql server:
http://cp.powerchaos.com/knowledgebase.php?action=displayarticle&id=19