Looking for a short term solution to improve website performance with additional server
- by Tanim Mirza
I am working with a small team to run an internal website running with PHP 5.3.9, MySQL 5.0.77. All the files and database are hosted on a dedicated Linux machine with the following configuration:
Intel Xeon E5450 8 CPU cores @3.00GHz,
2992.498 MHz,
Cache 6148 KB,
Cent OS – Red Hat Enterprise Linux Server release 5.4
We started small and then the database got bigger and now the website performance degraded significantly. We often get server space overrun, mysql overloaded with too many calls, etc. We don't have much experience dealing with these issues. We recently got another server that we were thinking to use to improve performance. Since it has better configuration, some of us wanted to completely move everything to the new machine. But I am trying to find out how we can utilize both machine for optimized performance. I found options such as MySQL clustering, Load balancer, etc. I was wondering if I could get any suggestion for this situation "How to utilize two machines in short term for best performance", that would be great. By short term we are looking for something that we can deploy in a month or so.
Thanks in advance for your time.