We run a site that now gets around 60,000 page views a day. This number has been steadily growing, but now the load on the server (Linux Red Hat 6.2) gets really high, and MySQL Crashes every couple of days, sometimes 3-4 times a day.
I know a lot of this will be due to inefficient code. We were basically adding bits and pieces as we went, as we had to get the functionality up quickly, and what we wanted from the site evolved over time.
We are now at the point, we are going to redo the site, section by section, on a new server. I need to know if MySQL is the way to go for the future. We expect our page views to almost double in the next few months, I just need to know if MySQL can handle that sort of load? If not, are there any other recommendations?
I know a lot of this will be due to inefficient code. We were basically adding bits and pieces as we went, as we had to get the functionality up quickly, and what we wanted from the site evolved over time.
We are now at the point, we are going to redo the site, section by section, on a new server. I need to know if MySQL is the way to go for the future. We expect our page views to almost double in the next few months, I just need to know if MySQL can handle that sort of load? If not, are there any other recommendations?