Re: Queries on innodb cluster
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,
Subject
Views
Written By
Posted
1729
May 09, 2019 07:31AM
Re: Queries on innodb cluster
468
May 10, 2019 04:02AM
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.