I need an architecture recommendation from a MySQL, JSP, Resin (or
other servlet engine) expert. I have an application that will need to
handle approximately 1000-3000 page views to a single JSP page in the
span of 10-20 seconds. This JSP page inserts 1 row in a MySQL table.
The JSP page is only about 10 lines of code: get connection from db
pool, create prepared statement, insert row, return connection. Can
anyone recommend how to set up the hardware and server software? Here
what I have to work with: 1 large 4 cpu Dell server with 4 GB and 5
Dell workstations. The O/S will have to be Redhat 7.2, and the
application server will be Caucho's Resin 2.1.4, and the MySQL version
is 3.23. Will MySQL run better on a multi CPU machine? Should I load
balance? Do I have the hardware for this? (Assume bandwidth is
sufficient). Thank you very much for your answers. |
