Re: FN-FORUM: MySQL clustering

date posted 7th November 2007 14:39

Hmm...

OK, well, the site is already partially optimised as I've spent the
last week rewriting large chunks of it so that it'll run on two web
servers pummelling a single database server with has no fallback.

I'm not a MySQL administration expert, so forgive me if this a dumb
question, but can you replicate and have the two servers
load-balancing?

Eg: two primary servers and two secondary servers, all replicated and
load balanced? Or is this just plain stupid and a waste of
resources/impossible?

Does replication work on the standard build of MySQL, or do we need to
shell out for licenses? The cheaper the solution is the more likely
it is to get picked, and I'm not going to do the users an injustice by
proposing something that isn't good enough or too expensive and loses
us the budget for developers, hence all the questions.

On 7 Nov 2007 15:18:53 -0000, [EMAIL REMOVED] [EMAIL REMOVED] wrote:
>
>
> 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
> >
> >
> --
> 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
>
>