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

[Tom Mornini]

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 at 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 at 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 at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster