Re: Queries on innodb cluster

[Frederic Descamps]

Hi Imran,

Thank you for your interest in MySQL InnoDB Cluster.

Let me answer your questions:

1). What is the minimum server requirement for innodb cluster?

3 is the minimal to avoid split brain situation. Some info about split-brain and InnoDB Cluster: https://lefred.be/content/mysql-innodb-cluster-how-to-manage-a-split-brain-situation/ and https://lefred.be/content/mysql-innodb-cluster-avoid-split-brain-while-forcing-quorum/

2). MySQL router server is compulsory or required?

MySQL Router is the easiest and recommanded way, but it's not mandatory, you can replace it by any other middle ware able to monitor your cluster. Again some info on my blog:
- https://lefred.be/content/ha-with-mysql-group-replication-and-proxysql/
- https://lefred.be/content/mysql-group-replication-native-support-in-proxysql/
- https://lefred.be/content/mysql-8-0-2-is-out-some-change-is-required-to-still-use-proxysql-with-gr/
- https://lefred.be/content/proxysql-and-mysql-8-0-2-la-suite/

3). Which ports need to be open for innodb cluster?

It depends but you need at least mysql 3306 and the one for group communication 33061 (by default). You can find more info in the manual : https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html

4). On which IP address application will connect? on router server IP address?

Yes application will connect to the router. However the best place to install the router is on the application servers themselves to avoid a single point of failure. If you do so, the application connects locally.

5). How to database sync between all the MySQL cluster node?

Currently the first provisioning (so when adding a new node to a cluster), should be prepared by the DBA by restoring a backup for example.

Best regards,