Innodb Cluster FAQs

Innodb Cluster FAQs

1. When you invoke shell.connect('clusterusr@node1:3306') it does not ask password from second time . Why is it so ? Where does Innodb cluster save its passwords ?

2. Can we use 2 nodes in Innodb cluster instead of 3 nodes ?

3. Router Vs ProxySQL - What is the difference ?

4. How to change primary node ?

5. Which ports need to be open for Innodb cluster ?

6. How do you check the status of Innodb cluster - How to know the primary node ?

To find out which server is currently the primary when deployed in single-primary mode, use the MEMBER_ROLE column in the performance_schema.replication_group_members table. For example:

mysql> SELECT MEMBER_HOST, MEMBER_ROLE FROM performance_schema.replication_group_members; +-------------------------+-------------+ | MEMBER_HOST | MEMBER_ROLE | +-------------------------+-------------+ | remote1.example.com | PRIMARY | | remote2.example.com | SECONDARY | | remote3.example.com | SECONDARY | +-------------------------+-------------+

7. How to stop/start Innodb cluster for maintenance ?

8. How to identify the node with