MySQL Forums
Forum List  »  InnoDB clusters

Re: Multiple Problems Setting Up MySQL Innodb Clustering
Posted by: Frederic Descamps
Date: April 30, 2017 07:35PM


Thank you for trying MySQL InnoDB Cluster.

Let me try to help you with your two issues:

#1. before starting the cluster on node1, please run SHOW MASTER STATUS; then do the same on the other nodes, you might already see transactions there that are note the same. This might be related to user and/or privileges that you created. If this is the case, the easiest thing to do if you have created the same user account with the same privileges on all your nodes is to run RESET MASTER; before starting the process.
Before joining a node you can also run cluster.checkInstanceState('root@mysqlX:3306') to verify the dataset.

#2. during the recovery process you can run SHOW SLAVE STATUS FOR CHANNEL 'group_replication_recovery'\G to see how gtids are applied and how fast. The mysql error log will also provide you information if there is an error that blocks the process.


Options: ReplyQuote

Written By
Re: Multiple Problems Setting Up MySQL Innodb Clustering
April 30, 2017 07:35PM

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.