mysql farm

Question

MySQL

If we talk about spherical mysql in a vacuum, then which option is abstractly better: three quad-core Core2Quad servers with 6 GB of memory each (with master-slave replication) or one eight-core Xeon with 12 GB of memory? Or like this: three 8 GB or one 24 GB? System priority is mostly read.

Answer 1

From a high availability point of view, multiple servers are clearly better. And if from the point of view of serviceability and various costs (space in the server room, power consumption, etc.), then it is much better to have one server. And there are many such different points of view.
You name the main aspect that interests you.

Answer 2

With a competent approach, the bottleneck will be reading from hdd. Tobish, the more hdd the better - hence the better more servers. And even more servers - real multithreading.

Answer 3

As far as I know, mysql still doesn't care about the number of cores -> three quad-core Core2Quads will be better than one octa-core.

Answer 4

Related video: vimeo.com/20439614

Answer 5

One with Opteron 6xxx with 12 cores and 32 GB of memory, SAS disks. The price will be approximately the same as Intel 8-core.

Answer 6

In vacuum - xeon. But with NU, media, their configuration, OS, FS, network, etc. are more important.

Answer 7

Buy more memory, a few tens of GB is lope?
Let's say a mother with 16 memory slots will have 128 GB of memory to the maximum. Flying must be tough.