RE: FN-FORUM: MySQL clustering

date posted 7th November 2007 14:11

Just wondering, what is such a massive critical resource, that it needs =
so much power and redundancy?=20

Have you considered virtual servers?

Regards=20
Sam Morgan=20
WiredEyes Media / ServWise Advanced Hosting

tel (Uk): +44 (0)20 7100 2178
tel (Italy): +39 070 773 6543
web : www.wiredeyes.com / www.servwise.com
----
umop ap!sdn w,! aw dlaH
----
----------------------------------------------------------------
Great Hosting Sale, 50% off all ServWise
hosting plans, use coupon code : HALFPRICE
----------------------------------------------------------------

> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Ben
> Nolan
> Sent: Wednesday, November 07, 2007 3:05 PM
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: MySQL clustering
>=20
>=20
> Hello,
>=20
> 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.
>=20
> Are the following actually usable proposals? All would be replicated.
>=20
> 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
>=20
> 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
>=20
> 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
>=20
> Also, is it possible (not desirable, obviously) to replicate the data
> on a cluster down to a standard stand-alone MySQL server?
>=20
> Thanks in advance,
>=20
> Ben.
>=20
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>=20
> To advertise here: http://www.freelancers.net/advertising.html
>=20
>