MySQL InnoDB Cluster – Missing Options in MySQL 8.0

Is SELinux disabled on the instance you're trying to add to the cluster? And the error log you're checking is of the instance you're trying to add?

Also, please use the dba.checkInstanceConfiguration() command to verify if your instances are ready to be used in InnoDB cluster.

Note that you can also use InnoDB cluster without disabling SELinux: https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html

To change the value of group_replication_local_address, as mentioned in the link above, use the following option on dba.createCluster() / addInstance():

- localAddress

To consult the available options of the AdminAPI commands you can use the online-helper:

mysql-js> \? createCluster

Cheers,

Miguel

Are you using different accounts to administer the cluster? i.e. did you use an account to create the cluster and are you using a different one to add the instance to it? Or is it the same account with a different password?

If that's the case, then that's the reason you're hitting this issue. The account used to administer the cluster must have the same credentials on all cluster members.

The recommendation is to create a clusterAdmin account, using dba.configureInstance(). More info in the docs.

The current error message is misleading and confusing. This will be improved soon and the documentation will also be improved to outline this requirement.

Cheers, Miguel