Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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
?
312 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 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article will show you step-by-step instructions to build your own NTP CentOS server.  The network diagram shows the best practice to setup the NTP server farm for redundancy.  This article also serves as your NTP server documentation.
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…

580 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