Best MYSQL Server For High Traffic - GoFuckYourself.com

247mg · 02-25-2011, 04:12 AM

friends, i am looking to have best and power mysql server for my nats program which can handle high traffic with no issues.

Any recommendations! shoot with some good configuration

camgirlshide · 02-25-2011, 05:47 AM

I like HP servers myself. It takes a lot to slow down mysql when configured correctly.

247mg · 02-25-2011, 12:21 PM

Configuration?

Juicy D. Links · 02-25-2011, 01:14 PM

Use SSD drives in your DB server if this is a option..

Cyandin · 02-25-2011, 02:55 PM

Quote:

Originally Posted by dpapa

friends, i am looking to have best and power mysql server for my nats program which can handle high traffic with no issues.

Any recommendations! shoot with some good configuration

Dual Intel Quadcore Xeon e5640's
32GB DDR3-1333 ECC RAM
8x80GB Intel 80GB SSD in Raid-10 (yielding a mind numbingly fast 320GB storage volume)

From there, you can implement memcached, or even use a chunk of the servers memory for a ramdisk. There are lots of good options on the software side.

A server like this will be a sickeningly fast, DB shredding machine.

camperjohn64 · 02-25-2011, 03:47 PM

Quote:

Originally Posted by Cyandin

Dual Intel Quadcore Xeon e5640's
32GB DDR3-1333 ECC RAM
8x80GB Intel 80GB SSD in Raid-10 (yielding a mind numbingly fast 320GB storage volume)

From there, you can implement memcached, or even use a chunk of the servers memory for a ramdisk. There are lots of good options on the software side.

A server like this will be a sickeningly fast, DB shredding machine.

I have a setup similar to this with Dual Quadcore 5640's, and have a hard time getting it to blink no matter how much I throw at it. 2 Thumbs up for the Dual Quadcore 5640's

Cyandin · 02-25-2011, 04:02 PM

Quote:

Originally Posted by camperjohn64

I have a setup similar to this with Dual Quadcore 5640's, and have a hard time getting it to blink no matter how much I throw at it. 2 Thumbs up for the Dual Quadcore 5640's

Yessir! If you can make this system cry, then you are probably in need of one of these.

IBM Blue Gene-P Supercomputer

borked · 02-25-2011, 04:07 PM

Quote:

Originally Posted by Cyandin

(yielding a mind numbingly fast 320GB storage volume)

320 GB storage for a db server?

I think the quad core + 32GB RAM though goes a long way to help to the speed, not the storage

camperjohn64 · 02-25-2011, 04:14 PM

Quote:

Originally Posted by Cyandin

Yessir! If you can make this system cry, then you are probably in need of one of these.

IBM Blue Gene-P Supercomputer

My last server was bogging down with traffic and I looked at upgrading packages, then decided to just shell out the cash for to own the server and no longer lease.

Then my traffic dropped like a rock :-)

Cyandin · 02-25-2011, 04:32 PM

Quote:

Originally Posted by borked

320 GB storage for a db server?

I think the quad core + 32GB RAM though goes a long way to help to the speed, not the storage

The Raid-10 out of SSD's portion of what I said is the important part, as far as db serving is concerned. True, most of the 320GB will not be used. Duh.

Also, using the right sized stripe in that array is very important too - something most people forget.

HomerSimpson · 02-25-2011, 08:38 PM

if you want it fast you need high end server the best you can buy
and some geeks to set things up... without them hardware is useless

Alky · 02-25-2011, 10:07 PM

Quote:

Originally Posted by Cyandin

Dual Intel Quadcore Xeon e5640's
32GB DDR3-1333 ECC RAM
8x80GB Intel 80GB SSD in Raid-10 (yielding a mind numbingly fast 320GB storage volume)

From there, you can implement memcached, or even use a chunk of the servers memory for a ramdisk. There are lots of good options on the software side.

A server like this will be a sickeningly fast, DB shredding machine.

we have two of something similar but a little downgraded... E5520's, 32GB Memory (8x4GB), 1066MHz, 5 146GB 15K's om each.

they handle our databases quite nicely

02-25-2011, 04:12 AM	#1
247mg Yellowplum / 247mg Industry Role: Join Date: Feb 2008 Location: Nicosia, CY Posts: 2,162	Best MYSQL Server For High Traffic friends, i am looking to have best and power mysql server for my nats program which can handle high traffic with no issues. Any recommendations! shoot with some good configuration __________________ 247mg.com - Indian Affiliate Program - Over 50+ Sites To Promote - Monetize Your INDIAN Traffic Today!

02-25-2011, 05:47 AM	#2
camgirlshide Confirmed User Join Date: Jan 2005 Posts: 1,558	I like HP servers myself. It takes a lot to slow down mysql when configured correctly. __________________ Useful adult webmaster links - Alphabetical list of solo models with webcam Stats on my best converting affiliate programs - camgirlshide webmaster blog complete list of affiliate programs I use.

02-25-2011, 12:21 PM	#3
247mg Yellowplum / 247mg Industry Role: Join Date: Feb 2008 Location: Nicosia, CY Posts: 2,162	Configuration? __________________ 247mg.com - Indian Affiliate Program - Over 50+ Sites To Promote - Monetize Your INDIAN Traffic Today!

02-25-2011, 08:38 PM	#11
HomerSimpson Too lazy to set a custom title Industry Role: Join Date: Sep 2005 Location: Springfield Posts: 13,826	if you want it fast you need high end server the best you can buy and some geeks to set things up... without them hardware is useless __________________ Make a bank with Chaturbate - the best selling webcam program Ads that can't be block with AdBlockers !!! /// Best paying popup program (Bitcoin payouts) !!! PHP, MySql, Smarty, CodeIgniter, Laravel, WordPress, NATS... fixing stuff, server migrations & optimizations... My ICQ: 27429884 \| Email:

02-25-2011, 01:14 PM	#4
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	Use SSD drives in your DB server if this is a option..