Re: MySQL Clean Install of INNODB cluster fails when adding 2nd Instance. 8.0.19.0
Posted by: damon pillinger
Date: June 08, 2020 11:13PM

Hi Jose,
can you thank the person responsible for the .20 update for me.

A complete install was done with no errors.
I set up a 5 node cluster within a few hours which was mostly installing/ cloning the windows blank system on Proxmox.

I set up the router and really thumped it to death all with expected excellent results.
I even crashed the system and had to
dba.rebootClusterFromCompleteOutage()
which would have worked out of the box if I had logged into the shell as "ic" rather than "root" but it was an easy fix to
Cluster.rejoinInstance(“ic@192.168.0.XXX:3306)

I could see no errors by the router to re-dirrect me to a down node.
I set up a second router and found this to be an excellent backup.

I am now going to start with multi-location which isn't quite successful yet but there are many videos to watch.

In short all problems resolved in version .20

many thanks
Damon

MySQL Windows Installer Cluster Expert

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.