Amazon Aurora more than one primary instance

I'm trying to gather some information about a new Amazon Aurora product, and I was wondering if this product can have more than one primary instance for the same database? Is it also possible to have more than one exchange?

Do you mean a model with several masters? Yes

+4
source share
1 answer

Amazon Aurora is not really intended to support a multi-wizard model at this time, since it does not offer the auto_increment_offset and auto_increment_increment configuration options needed for true active / active multi-machine replication. Since each Aurora cluster can replicate to and from another Aurora cluster, it is “theoretically” possible to manually configure an active / passive cluster with several masters. It is possible to configure active / active if you can use primary keys that can be guaranteed unique across the cluster (i.e. forget about automatic increment).

Active/Active multi-master - , . , MySQL " " , , .

, , , (), . , /, ( [cough] Amazon Aurora).

+4

All Articles