Re: FN-FORUM: MySQL clustering

date posted 7th November 2007 14:32

It's a social networking site that's been in the news recently, and
has suddenly gained the budget and support it should have had to begin
with.

On 7 Nov 2007 15:01:44 -0000, Sam M - www. wiredeyes. com
[EMAIL REMOVED] wrote:
>
> Just wondering, what is such a massive critical resource, that it needs so much power and redundancy?
>
> Have you considered virtual servers?
>
> Regards
> Sam Morgan
> 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
> >
> >
> > 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
> >
> >
> --
> 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
>
>