Re: Queries on innodb cluster

[Frederic Descamps]

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,