I've been working on a enterprise application with a user base of 1000. There are about 20-30 users at any given time using the tool and at peak times around a 100 users.
Current configuration: LAMP Stack MySQL 5.5.29, PHP 5.3.20 - CodeIgniter Framework, Front-end Action script with Flex Framework Intel Xeon 32 Cores @ 2.9 GHz 161 GB of RAM 2 TB Hard drive Linux Fedora 16 OS
I have just recently received a requirement that we will be granting access to different departments which will add about 5000 more users.
I've been mostly a front-end developer with the last two years doing back-end development as well. However, I do not have enough experiencing in load balancing, what hardware configuration can support what etc.
Currently, I am building the application from the ground up trying to optimize areas with bottlenecks and also add certain features so we don't experience issues with the new additions.
First, are there any phpmyadmin type dashboards that can be installed on linux that will give me a nice GUI showing CPU load, memory usage, harddrive read/writes etc. ?
Second, are there any suggestions from people with experience in this area on what I can do to optimize the server?
Third, is my server configuration enough to support that many users? Application will be using 75% select statements with joins to display reports and 25% of the time writing/updating to the database.
Thanks in advance for your help.