Multi-Master Asynchronous Replication
Hi, Is that a way to make multi-master asynchronous replication with mysql ou external lib? I know galera cluster but it is synchronous. The problem is a set of eventually disconected nodes need to send all changes (when connected) to a master always connected node. Thanks! Rodrigo
Re: Multi-Master Asynchronous Replication
- Original Message - From: Rodrigo Ferreira rodrigof_si...@yahoo.com Subject: Multi-Master Asynchronous Replication Hi, Is that a way to make multi-master asynchronous replication with mysql ou external lib? I know galera cluster but it is synchronous. The problem is a set of eventually disconected nodes need to send all changes (when connected) to a master always connected node. Yes, async is the default setup with MySQL replication; multimaster is possible using a circular setup (or, with recent MariaDB, a slave can have multiple masters); but it's not officially supported, and it's tricky to get right because of concurrent updates etc. Careful with that :-) -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Multi-Master Asynchronous Replication
Thanks for your response. In this case, circular replication is not apropriate because there are about 10 to 15 nodes, and it is known that availability decreases on circular setup as the number of nodes increases. Another reason (related to availability) is that nodes are eventually disconected, and one node disconnected (suppose one whole day disconnected) can delay the whole replication. Any suggestion? Rodrigo On Monday, November 24, 2014 1:43 PM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: Rodrigo Ferreira rodrigof_si...@yahoo.com Subject: Multi-Master Asynchronous Replication Hi, Is that a way to make multi-master asynchronous replication with mysql ou external lib? I know galera cluster but it is synchronous. The problem is a set of eventually disconected nodes need to send all changes (when connected) to a master always connected node. Yes, async is the default setup with MySQL replication; multimaster is possible using a circular setup (or, with recent MariaDB, a slave can have multiple masters); but it's not officially supported, and it's tricky to get right because of concurrent updates etc. Careful with that :-) -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Re: Multi-Master Asynchronous Replication
Sorry, I will check this = with recent MariaDB, a slave can have multiple masters On Monday, November 24, 2014 2:26 PM, Rodrigo Ferreira rodrigof_si...@yahoo.com wrote: Thanks for your response. In this case, circular replication is not apropriate because there are about 10 to 15 nodes, and it is known that availability decreases on circular setup as the number of nodes increases. Another reason (related to availability) is that nodes are eventually disconected, and one node disconnected (suppose one whole day disconnected) can delay the whole replication. Any suggestion? Rodrigo On Monday, November 24, 2014 1:43 PM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: Rodrigo Ferreira rodrigof_si...@yahoo.com Subject: Multi-Master Asynchronous Replication Hi, Is that a way to make multi-master asynchronous replication with mysql ou external lib? I know galera cluster but it is synchronous. The problem is a set of eventually disconected nodes need to send all changes (when connected) to a master always connected node. Yes, async is the default setup with MySQL replication; multimaster is possible using a circular setup (or, with recent MariaDB, a slave can have multiple masters); but it's not officially supported, and it's tricky to get right because of concurrent updates etc. Careful with that :-) -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql