Which server would you recommend for MySQL

cooljai · 01-03-2009, 12:57 AM

Friends,

I've to install and configure MySQL for a very large website on Amazon Elastic Computing Cloud (EC2). I've two choices for server machine:

1. Extra Large Instance having 15 GB of memory, 8 EC2 Compute Units (1.0-1.2 Ghz each), 1690 GB of instance storage, 64-bit platform

2. High-CPU Extra Large Instance 7 GB of memory, 20 EC2 Compute Units (1.0-1.2 Ghz each), 1690 GB of instance storage, 64-bit platform

So, what you would prefer from more CPU power or more RAM for a very busy MySQL DB Server ?

Regards,

sokar24 · 01-03-2009, 07:23 AM

If I look at the prices: Extra Large $0.88 per hour
Iam wondering how much cash you are making with your website, it will be around 600 bucks/month. You can rent a few monster dedicated server boxes for that price... I asume you want it to be up 24/7?

chrism01 · 01-05-2009, 12:58 AM

If the data is largely static ie you're serving up data, rather than a transaction processing system, then more RAM, because more 'answers' are cached in RAM instead of being disk-bound, a notorious bottleneck for DBs.
This is still true if the system is a dedicated DB server and any (most) data processing is on another system.

cooljai · 01-05-2009, 01:45 AM

Thanks chrism01!

I'm going to setup Master-Slave, where Master will be used only for writing (insertion/updation) and Slave for reading (multiple servers will read it to generate heavy reports). Both will be dedicated DB servers.

Therefore, what I can assume here is that I should go for more cpu for first server (as writing is greatly involved) and select more RAM for second one (where caching will help significantly).

Am I seems correct ?

regards,

chrism01 · 01-05-2009, 06:26 PM

If you can ensure that design (ie Master = insert/update/delete, slave = select) then sounds good to me.
It also means you can trim/customise the OS to DB specific params eg http://dev.mysql.com/doc/refman/5.0/en/disk-issues.html

Good luck

PS remember to ensure the NICs/cables have enough bandwidth