I have a forum with about 5 million posts and the mysql database is getting bigger each day, about 30GB in size. I am hosting the php source of the forum, a lot of images about 1 image per post and the mysql database in the same server.
I contacted the company that makes the forum and they said I would need to changes my server and instead of having a powerful server like the one that I have
CPU: Xeon 16 Cores @ 2.00 GHz
into something like 3 servers with 12GB ram and quad core.
one for source php files
one for database
one for static like images
even though these servers would be just 36 GB total ram and 12 cpu cores
would I really lower the server load and improve page loading time with apache?