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
