MySQL Forums
Forum List  »  InnoDB clusters

Re: Cluster and AutoIncrement
Posted by: Frederic Descamps
Date: October 20, 2016 12:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2290
October 19, 2016 07:36AM
1088
October 19, 2016 02:48PM
866
October 19, 2016 11:48PM
Re: Cluster and AutoIncrement
787
October 20, 2016 12:39AM
691
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.