I am looking into building a new mySQL 5 database server and I would love to get some input from you guys to see if this is sufficient or if there might be a bottleneck somewhere.
The database server will be the backend for an application simultaneously being used by 1000-2000 users. We’re storing contact information and other basic text-based data. The tables will eventually get in the range of 1,000,000 rows and probably 30+ columns. The data in these tables is going to be related in many ways which means we’ll have all kinds of JOINs.
The hardware I am currently looking into is as follows:
2x Dual Core Intel Woodcrest 5130 Processors
4x 146 GB 10K SAS Harddrives in RAID1+0 (stripe and mirror)
4GB or 8GB RAM
The operating system is probably going to be Red Hat Enterprise 5 (I can get it without subscription cost).
Because of the nature of the application we’ll probably go with InnoDB as storage engine.
What do you think? Is that hardware sufficient or should we go with 8 instead of 4 cores, or more RAM?