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
<[email protected]> wrote:
----- Original Message -----
> From: "Rodrigo Ferreira" <[email protected]>
> 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
