Re: FN-FORUM: MySQL clustering

date posted 7th November 2007 14:48


By optimizing I mean for cluster - its a totally different way of thinking
to normal sql.

In normal sql your better of having multiple tables, in cluster its the
opposite.

you'l not be impressed with the performance, we have a major client that
handles ALOT of traffic all driven by MySQL and cluster couldn't cope with
it.

With normal mySQL you can load-balance and multi-master replicate, email
me [EMAIL REMOVED] if you want any advice on this.

Thanks

John

>
> 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
>>
>>
> --
> 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
>
>