[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: [Linux-cluster] Using mysql cluster with GFS on RHEL 4



That is correct, with MyISAM tables, you can have active/active on GFS storage.

The MySQL Cluster DB is a weird beast, IMHO.

I read their book on it, and it made me laugh out loud when it said, as an admitted limitation, you could not issue commands that modified the schema such as ALTER TABLE ADD COLUMN and ALTER TABLE CREATE INDEX while the database was online.

:-)

--
-- Tom Mornini, CTO
-- Engine Yard, Ruby on Rails Hosting
-- Reliability, Ease of Use, Scalability
-- (866) 518-YARD (9273)

On Nov 26, 2006, at 11:19 AM, Michael Will wrote:

So with myisam tables I can do active/active on the same database with shared data? Or is it the inram database that is shared-nothing?

 -----Original Message-----
From:   Tom Mornini [mailto:tmornini engineyard com]
Sent:   Sat Nov 25 10:33:20 2006
To:     linux clustering
Subject: Re: [Linux-cluster] Using mysql cluster with GFS on RHEL 4

It only works with MyISAM tables.

The advantage over master/slave is that you can
read and write to both of them, have have identical
results between the two, allowing complete load
balancing.

On Nov 25, 2006, at 7:11 AM, sara sodagar wrote:

> Hi
> According to
> http://sources.redhat.com/cluster/faq.html#gfs_mysql
> to use GFS , we can only have one mysql active.
>
> What are the advantages of useing this technique over
> master/salve in mysql?
>
> Regards.
> Sara
>
>
>
> ______________________________________________________________________
> ______________
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail beta.
> http://new.mail.yahoo.com
>
> --
> Linux-cluster mailing list
> Linux-cluster redhat com
> https://www.redhat.com/mailman/listinfo/linux-cluster

--
-- Tom Mornini, CTO
-- Engine Yard, Ruby on Rails Hosting
-- Reliability, Ease of Use, Scalability
-- (866) 518-YARD (9273)


--
Linux-cluster mailing list
Linux-cluster redhat com
https://www.redhat.com/mailman/listinfo/linux-cluster

--
Linux-cluster mailing list
Linux-cluster redhat com
https://www.redhat.com/mailman/listinfo/linux-cluster



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]