Re: Cluster and AutoIncrement
Hi Stefan,
Again, this depends of course how you set it up. It's possible to not have any offset but then you should use only one active writer (the default). I recommend you to use it like that especially because multiple-active-masters is not suitable for all workloads. If you want to provide a generic HA solution, then ProxySQL or MySQL Router --> MySQL InnoDB Cluster (with one primary master)
Also please note, that in the "cluster" area, MySQL provides 2 options:
MySQL Cluster (7.5) which is based on NDB and MySQL InnoDB Cluster which is not yet GA, you find it in labs.mysql.com but should be GA soon. MySQL InnoDB Cluster is based on Group Replication.
Cheers,
lefred
Subject
Views
Written By
Posted
2450
October 19, 2016 07:36AM
1178
October 19, 2016 02:48PM
951
October 19, 2016 11:48PM
Re: Cluster and AutoIncrement
857
October 20, 2016 12:39AM
749
October 20, 2016 10:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.