Solved

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

Posted on 2008-10-09
4
292 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Suggested Solutions

Title # Comments Views Activity
mysql between clause 2 41
mysql update statement 3 33
What is linux 4.8.22? Is it the same as ubuntu 16.10 ?? 2 75
how to access a remote mysql database with xampp 3 42
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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