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@xxxxxxxxxxxxxx]
Sent: Sat Nov 25 10:33:20 2006
To: linux clustering
Subject: Re: 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@xxxxxxxxxx
> 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@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
