Re: 2. MySQL Clean Install of INNODB fails when trying to join cluster.
OK lots of things missing from the installer beside opening port 33061 in the firewall.
here are my notes which I hope will allow you to get a cluster running easily.
Please follow these steps as they have taken days to work out.
To add new new instance
FIRST check computer name
search for PC name - reboot - if you don't or forget or have already done it, then search and replace the OLD PC name in the my.ini with the NEW PC name once MySQL is installed and then rename the PC - reboot
install MySQL as a stand alone instance any way you want (not cluster).
change this in the my.ini before you add the instance to a cluster
# report_host =0.0
and change it to
report_host = 192.168.0.XXX
this is the IP of your machine
services
restart MySQL 80
mySQL SHELL
\c root@localhost
dba.configureInstance()
2 / icroot / 192.168.% / Y / Y
Use workbench to add a password to icroot which is not done by default.
You can just select 1 - which is to use "root" but I think it is less secure.
If this is your first instance / MASTER (for now) then open MySQL SHELL
and log in using \c root@localhost
password
then run this
var cluster = dba.createCluster("myCluster")
that's it - it should all work
cluster.status()
It should show you one very happy instance in the report :)
To add another instance to a cluster follow all the instructions above to create a new instance
Then on the master go into the MYSQL SHELL
\c root@localhost
var cluster = dba.getCluster()
cluster.addInstance("root@192.168.0.XXX:3306")
Clone
Takes less than a minute if there is no data on the database
thats it :)
cluster.status() should show your happily running instances.
START MY NOTES>>>> not for everyone
If creating a new Cluster then you will need to do this which will work through the whole cluster
You do this in Workbench
SET session sql_mode="";
SET GLOBAL max_connections = 500;
SET GLOBAL log_timestamps = SYSTEM;
SET GLOBAL innodb_buffer_pool_size=1*1024*1024*1024;
SET GLOBAL max_allowed_packet = 16*1024*1024;
check "MySQL usernames.doc" (installers folder) for the users to add
Extra notes
set global super_read_only = off;
END MY NOTES>>>> not for everyone
ROUTER
Use the installer to Add the router
REMEMBER : The management user is : icroot
You will need to manually open ports 6446 and 6447 in the firewall as they are not opened in the installer.
Easy to update the firewall at the same time with the one inbound rule for ports 33061,6446,6447 .
Hope this helps someone one day.
Stay safe
Subject
Views
Written By
Posted
923
April 06, 2020 12:23AM
Re: 2. MySQL Clean Install of INNODB fails when trying to join cluster.
558
April 06, 2020 07:50PM
510
April 06, 2020 07:54PM
526
April 16, 2020 04:02PM
491
June 08, 2020 11:14PM
496
June 10, 2020 05:38PM
389
September 30, 2020 04:23AM
375
October 06, 2020 05:37AM
440
October 30, 2020 06:36AM
453
November 03, 2020 01:58AM
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.