Re: FN-FORUM: MySQL clustering

date posted 7th November 2007 14:28


Ben,

Firstly forget anything multi-cpu or multi-core - cluster can't use them.

You'll see 8 cores and only 1 in use (cluster engine is NOT threaded or
SMP aware/safe)
Of course you can run multiple ndbd's on the data nodes but it makes
things alot more difficult and its not officially supported (for good
reasons)

Also remember cluster is ALOT slower on ALOT of sql.
You'll need to heavily optimize ALL your tables to gain any benefits.

Much better to use replication.

Thanks


John

>
> 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.
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>