What has to be considered if mysql should work on a big server with Novell SLES 10
Posted on 2008-10-09
today we are in a discussion what has to be considered to host a tomcat web application connected to a mysql server. That application will be open to public and we expect a huge number of accesses (at least in the 1st week). Since we got some experience with tomcat this should not be discussed here but MySQL is our weak spot: The application developer suggests as database server with Novell SLES 10 SP2 on a system with 4 xeon quad core CPUs with 16 GB RAM.
The data amount is 200 MB (10 columns, 2 million rows).
We have no real experience in MySQL on such a big platform, also we normally use debian in conjunction with rather small mysql servers for standard web applications.
So we need to know what has to be considered to setup such an environment, what has to be done to let mysql run on full scale. Worst thing that could happen would be a non responding web application because the database cannot handle the requests....