Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2008-10-09
4
Medium Priority
?
311 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 2000 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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

604 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