I am looking to upgrade a server for a web app. Currently the application is running very sluggish. We've made some adjustments to mysql (that's another issue in itself) and made some adjustments so that heaviest quires get run on a copy of the database on another server was have as a backup, however this will not last that much longer and we are looking to upgrade.
Currently the servers CPUs are (4) Intel(R) XEON(TM) CPU 2.00GHz, with 1 gig of ram.
The database is 442.5 MiB, with about 1,743,808 records.
There are two parts of the program, the one, side a, inserts and updates most of the data. Side b, reads the data and does some minor updates.
Currently our biggest day for side a are 800 users (of 40,000 users all year) imputing the system. And our Side b is currently unknown, however we have a total of 1000 clients.
The system is most likely going to cap out at 5000 side b clients, with about a year 300,000 side a users.
The current database is 5 years old, so we can most likely expect the database to grow pretty rapidly, possibly double each year (which we can most likely archive older records if it comes to that).
So with that being said, should we get a server for each side of the app, side a being the master, side b being the slave, any updates made on side b are router to side a.
So the question is should i get 2 of these or 1.
2 x Intel Nehalem Xeon E5520 2.26Ghz (8 Cores)
12GB DDRIII Memory
500GB SATAII HDD
100Mbps Port Speed
And Naturally I would need to have a redundant backup so it could potentially be 4 of them.