Solved

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

Posted on 2008-10-09
4
276 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

1. Introduction As many people are interested in Linux but not as many are interested or knowledgeable (enough) to install Linux on their system, here is a safe way to try out Linux on your existing (Windows) system. The idea is that you insta…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

757 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

19 Experts available now in Live!

Get 1:1 Help Now