MySQL Forums
Forum List  »  InnoDB clusters

Re: Queries on innodb cluster
Posted by: Frederic Descamps
Date: May 10, 2019 04:02AM

Hi,

For automated HA, you cannot have only 2 MySQL Servers. You can have a group of 2 but in case one node is missing (or have network issues) the remaining node will stop working until you explicitly manually tell him to take the lead.

The Shell is not a server, it's just like the mysql client. You can use it to operate your cluster. It can be installed anywhere, usually on the DBA's laptop is enough.

You don't need share storage at all.

If you setup a new cluster, you don't have anything to do, as soon as you will write data it will be replicated. Now if you plan to add a new server to the group after a long period, you probably don't have anymore all the binary logs from day 1, therefor, you will need to take a backup of one of the members and restore it on the new one before joining the group/cluster.

For the router, you can install it on both, you bootsrap them (they auto-configure themselves by connecting to the cluster) and then they will use the cluster's information to know what do do (meta-data).

You can find plenty of resource in the mysql documentation or on my blog [https://lefred.be] (articles slides and videos).

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
1615
May 09, 2019 07:31AM
340
May 10, 2019 03:46AM
Re: Queries on innodb cluster
401
May 10, 2019 04:02AM
319
May 10, 2019 04:24AM
337
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.