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.mor...@oracle.com] > 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.tompk...@googlemail.com] > > 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.mor...@oracle.com>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.mor...@oracle.com @andrewmorgan www.clusterdb.com > > > > > > > -----Original Message----- > > > > From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] > > > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
