Solved

What has to be considered if mysql should work on a big server with Novell SLES 10

Posted on 2008-10-09
4
279 Views
Last Modified: 2013-12-05
Hello,

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....

Tolomir

0
Comment
Question by:Tolomir
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
mattaob earned 500 total points
ID: 22676786
This is a very expansive question - you should carefully load test your application if possilble to identify the read/write ratios.
Then look at the indexing as the data increases.

You can go nuts with mysql and build a massive cluster - of you can keep it simple with 1 server or a master/slave replicated system.

It's all down to application load - if you're in a high write enviornment myisam tables might become a problem because they employ table locking so you might benefit by taking a minor performance hit but increased concurrency using innodb tables.  There's always the NDB engine you could use.

The main thing that borks a mysql server is having to work with the disk - then if that disk is slow it makes things even worse.

2 million rows isn't really a lot of data.  But 10 rows  queries badly can cause a server to fail.  It's not really about the data but how you access it.
0
 
LVL 27

Author Comment

by:Tolomir
ID: 22676840
Thank you,

the tables are r/o during the day and are updated at night. (I think we can assume that the database needs to be available just during the daytime)

There will be just a single mysql server as far as I know there is no backup server planned.

Our problem is we get a complete unknown application and have to host it, so we try to identify the bottlenecks. Also we have no idea how many users will use that site concurrently, all we can image is busy during the day...

...and glad that you asked, that was an idea of our management not of our IT department...

Tolomir
0
 
LVL 27

Author Comment

by:Tolomir
ID: 22719969
ok got rid of the "problem".

Thank you.


0
 
LVL 27

Author Closing Comment

by:Tolomir
ID: 31504573
Convinced our management to leave us alone with it!

Thank you for your answer.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document is written for Red Hat Enterprise Linux AS release 4 and ORACLE 10g.  Earlier releases can be installed using this document as well however there are some additional steps for packages to be installed see Metalink. Disclaimer: I hav…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now