MySQL Forums
Forum List  »  InnoDB clusters

Re: Queries on innodb cluster
Posted by: Frederic Descamps
Date: May 09, 2019 12:52PM

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,

Options: ReplyQuote


Subject
Views
Written By
Posted
1750
May 09, 2019 07:31AM
Re: Queries on innodb cluster
460
May 09, 2019 12:52PM
411
May 10, 2019 03:46AM
383
May 10, 2019 04:24AM
403
May 10, 2019 04:03PM


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.