469,338 Members | 8,638 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,338 developers. It's quick & easy.

How to size a MySQL server

Hi everyone,

I've got a question about how to size the server hardware for a MySQL
system that I've got to buy and build. We're going to be putting a
database on MySQL that will contain upwards of 20 million rows of data.
This data will be used by Java applications running under Tomcat to
provide web pages, Java data objects and probably most importantly SOAP
web services. The total number of concurrent users of this data is not
know, but could be thousands / hour. The database will be essentially
read only, no transactions or updates by users. The whole thing will be
running on a RedHat Enterprise Linux AS server. What I'd like to know
is what kind of machine should I be buying; CPU speed wise, memory size
wise and disk size? My initial impression is that the requirements I've
outlined above could be handled readily by even a modest machine, but I
wanted to ask for feedback in case my impression is wrong.

Thanks in advance,
Doug Farrell

Jun 15 '06 #1
2 1975
wr******@charter.net wrote:
I've got a question about how to size the server hardware for a MySQL
system that I've got to buy and build. We're going to be putting a
database on MySQL that will contain upwards of 20 million rows of data.
This data will be used by Java applications running under Tomcat to
provide web pages, Java data objects and probably most importantly SOAP
web services. The total number of concurrent users of this data is not
know, but could be thousands / hour. The database will be essentially
read only, no transactions or updates by users. The whole thing will be
running on a RedHat Enterprise Linux AS server. What I'd like to know
is what kind of machine should I be buying; CPU speed wise, memory size
wise and disk size? My initial impression is that the requirements I've
outlined above could be handled readily by even a modest machine, but I
wanted to ask for feedback in case my impression is wrong.


Thousands of queries/hour to a 20-million-rows-table cannot be handled
by one (normal) machine. I think you should definitely setup more than
1 machine and keep the buffering machines up-to-date from one master.

I would also suggest the use of crontabs to make as much HTML as
possible, in order to save CPU when it's not strictly necessary to
query the database.

--
Bart

Jun 15 '06 #2

Bart Van der Donck wrote:
wr******@charter.net wrote:
I've got a question about how to size the server hardware for a MySQL
system that I've got to buy and build. We're going to be putting a
database on MySQL that will contain upwards of 20 million rows of data.
This data will be used by Java applications running under Tomcat to
provide web pages, Java data objects and probably most importantly SOAP
web services. The total number of concurrent users of this data is not
know, but could be thousands / hour. The database will be essentially
read only, no transactions or updates by users. The whole thing will be
running on a RedHat Enterprise Linux AS server. What I'd like to know
is what kind of machine should I be buying; CPU speed wise, memory size
wise and disk size? My initial impression is that the requirements I've
outlined above could be handled readily by even a modest machine, but I
wanted to ask for feedback in case my impression is wrong.

Thousands of queries/hour to a 20-million-rows-table cannot be handled
by one (normal) machine. I think you should definitely setup more than
1 machine and keep the buffering machines up-to-date from one master.

I would also suggest the use of crontabs to make as much HTML as
possible, in order to save CPU when it's not strictly necessary to
query the database.

--
Bart
Bart,

What's your basis for feeling one server would be overloaded by the
requests I've outlined? I'm not questioning you as much as wanting to
know your experience with this.

Thanks for your reply,
Doug

Jul 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by nm | last post: by
reply views Thread by Asif Iqbal | last post: by
reply views Thread by mikey | last post: by
2 posts views Thread by Nathan Given | last post: by
2 posts views Thread by steve | last post: by
6 posts views Thread by Tom | last post: by
6 posts views Thread by sa_wahab | last post: by
2 posts views Thread by trihanhcie | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.