FN-FORUM: MySQL clustering

date posted 7th November 2007 13:14

Hello,

I'm trying to put forward a proposal to the Powers-That-Think-They-Are
to upgrade our single, non-replicated and unbacked up MySQL server to
a replicated cluster, but I can't quite work out what we'd actually
need. If I am reading the documentation correctly, the it states that
you need a mangement node, an SQL node and at least two data nodes.
Does anyone know if I've latched on to the wrong end of the stick
here? I gather that the ideal situation is 1 x MGM, 1 x SQL and 4 x
NDB, but I don't think we can afford this at the moment. Could we run
the system with one server running the management and SQL nodes and
two/three NDB nodes? This cuts the number of servers we need and
makes it much more likely to be signed off.

Are the following actually usable proposals? All would be replicated.

Server 1: 2xQuad core processors, 4Gb RAM, 146Gb RAID-1 -- Management
and SQL node
Server 2: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node
Server 3: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node

Server 1: 2xQuad core processors, 4Gb RAM, 146Gb RAID-1 -- Management
and SQL node
Server 2: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for OS and
500Gb RAID-5 for data -- Data node
Server 3: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node
Server 4: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node

Server 1: 2xQuad core processors, 4Gb RAM, 146Gb RAID-1 -- Management node
Server 2: 2xQuad core processors, 4Gb RAM, 146Gb RAID-1 -- SQL node
Server 3: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node
Server 4: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node
Server 5: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node
Server 6: 2xQuad core processors, 16Gb RAM, 146Gb RAID-1 for software
and 500Gb RAID-5 for data -- Data node

Also, is it possible (not desirable, obviously) to replicate the data
on a cluster down to a standard stand-alone MySQL server?

Thanks in advance,

Ben.