List:General Discussion« Previous MessageNext Message »
From:Rick James Date:April 30 2013 11:04pm
Subject:RE: MySQL Cluster or MySQL Cloud
View as plain text  
See also Percona XtraDB Cluster.

Will you nodes be in the same physical location?  If so, what about floods, earthquakes,
etc?

"Clouds are ephemeral; data wants to persist"

> -----Original Message-----
> From: Andrew Morgan [mailto:andrew.morgan@stripped]
> Sent: Tuesday, April 30, 2013 12:36 AM
> To: Neil Tompkins
> Cc: [MySQL]
> Subject: RE: MySQL Cluster or MySQL Cloud
> 
> Hi Neil,
> 
>  If you use MySQL Cluster then you have synchronous replication between
> the 2 data nodes which means that if one should fail you're guaranteed
> that the other contains the effects of every committed transaction and
> that the change has already been applied and so there is no delay while
> relay logs are applied before the automatic failover kicks in - which
> is why it can take less than a second.
> 
>  You also have a good scale-out story with MySQL Cluster as you can
> just continue to add more nodes (256 in total, 48 of which can be data
> nodes) withou having to worry about partitioning, failover etc.
> 
> Regards, Andrew.
> 
> > -----Original Message-----
> > From: Neil Tompkins [mailto:neil.tompkins@stripped]
> > Sent: 29 April 2013 14:50
> > To: Andrew Morgan
> > Cc: [MySQL]
> > Subject: Re: MySQL Cluster or MySQL Cloud
> >
> > Hi Andrew,
> >
> > Thanks for your response and the useful white paper.  I've read the
> > document in great detail.  I'm looking for the best up time possible
> > for my application and am still struggling to see the major
> > differences with MySQL cluster compared to MySQL in the Cloud on
> > multiple servers; apart from MySQL Cluster being much better solution
> > for automatic failover including IP failover.
> >
> > Regards, Neil
> >
> >
> > On Mon, Apr 29, 2013 at 8:47 AM, Andrew Morgan
> > <andrew.morgan@stripped>wrote:
> >
> > > Hi Neil,
> > >
> > >  I hate just sending people off to white papers but you might get
> > > some good insights by taking a look at the "MySQL Guide to High
> > > Availability Solutions" paper -
> > > http://www.mysql.com/why-mysql/white-papers/mysql-guide-to-high-
> > availa
> > > bility-solutions/
> > >
> > > Regards, Andrew.
> > >
> > > Andrew Morgan - MySQL High Availability Product Management
> > > andrew.morgan@stripped @andrewmorgan www.clusterdb.com
> > >
> > > > -----Original Message-----
> > > > From: Neil Tompkins [mailto:neil.tompkins@stripped]
> > > > Sent: 27 April 2013 23:28
> > > > To: [MySQL]
> > > > Subject: Fwd: MySQL Cluster or MySQL Cloud
> > > >
> > > > > If deploying MySQL in the Cloud with two MySQL servers with
> > > > > master to
> > > > master replication i have a good failover solution.
> > > > >
> > > > > Whats the different in terms of availability if we opted for
> > > > > MySQL
> > > Cluster
> > > > instead ?
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:    http://lists.mysql.com/mysql
> > > >
> > >
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
Fwd: MySQL Cluster or MySQL CloudNeil Tompkins27 Apr
  • RE: MySQL Cluster or MySQL CloudAndrew Morgan29 Apr
    • Re: MySQL Cluster or MySQL CloudNeil Tompkins29 Apr
      • RE: MySQL Cluster or MySQL CloudAndrew Morgan30 Apr
        • RE: MySQL Cluster or MySQL CloudRick James30 Apr