From: Andrew Morgan Date: February 20 2012 1:29pm Subject: RE: geographic replication List-Archive: http://lists.mysql.com/cluster/8257 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Hi Klaus, MySQL Cluster Geographic replication is based on MySQL asynchronous replic= ation. As well as handling the complexities of the MySQL Cluster distribute= d architecture, when using it between 2 MySQL Cluster deployments it also h= andles: 1) Active/Active (sometimes called multi-master) replication 2) Conflict detection/resolution for active/active (if you change the same= piece of data in each Cluster at about the same time, Cluster geographic replication = will flag and/or resolve it You can (and many, many people do) run MySQL replication between 2 MySQL S= ervers for InnoDB tables, you just need to be more careful to avoid data co= nflicts. You can take a look at http://www.mysql.com/why-mysql/white-papers= /mysql_wp_ha_strategy_guide.php for an overview and links to more resources= for the various MySQL High Availability options. Regards, Andrew. -----Original Message----- From: mysql.com@stripped [mailto:mysql.com@stripped]=20 Sent: 20 February 2012 11:53 To: cluster@stripped Subject: geographic replication Hello list readers, after reading serveral documentations about replication and MySQL Cluster 7= .2 I have a question.=20 The document "MySQL_Guide_to_NoSQL_v2.pdf" says on pages 13-14:=20 Geographic Replication also enables data to be replicated in real-time to o= ther MySQL storage engines. A typical use-case is to replicate tables from = MySQL Cluster to the InnoDB storage engine in order to generate complex rep= orts from near real-time data, with full performance isolation from the liv= e data store. Does this mean that all data nodes have to use NDB and only an export to In= noDB is possible or is it also possible to use InnoDB instead of NDB? In my use case I have two databases located in different cities and both ha= ve to be master. I make massive use of foreign keys so InnoDB is realy impo= rtant.=20 Is the geographic replication provided by MySQL-Cluster 7.2 a solution or d= o you know an alternative? Regards Klaus -- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster