I am trying to create a cluster with one master aggregator and 4 leaf nodes
each VM 8 cpu and 32GB RAM assuming that is ok for free license
I have following nodes set up
±-----------±--------±--------------------------±-----±--------------±-------------±--------±---------------±-------------------±-------------+
| MemSQL ID | Role | Host | Port | Process State | Connectable? | Version | Recovery State | Availability Group | Bind Address |
±-----------±--------±--------------------------±-----±--------------±-------------±--------±---------------±-------------------±-------------+
| B7961A9093 | Master | memsqlaggregator.hq.local | 3306 | Running | True | 6.8.10 | Online | | 0.0.0.0 |
| 8C17A0E114 | Unknown | memsqlleaf1.hq.local | 3306 | Running | True | 6.8.10 | Online | | 0.0.0.0 |
| 31C9B5A5DB | Unknown | memsqlleaf2.hq.local | 3306 | Running | True | 6.8.10 | Online | | 0.0.0.0 |
| A6821F8549 | Unknown | memsqlleaf3.hq.local | 3306 | Running | True | 6.8.10 | Online | | 0.0.0.0 |
| 60A3EAC6C4 | Unknown | memsqlleaf4.hq.local | 3306 | Running | True | 6.8.10 | Online | | 0.0.0.0 |
±-----------±--------±--------------------------±-----±--------------±-------------±--------±---------------±-------------------±-------------+
But next steps which adding leaf Role to one of nodes it fails as below
[dxj001@memsqlaggregator software]$ memsql-admin add-leaf --memsql-id 8C17A0E11431225F81BCC6D049561A6429B51E13
dxj001@memsqlleaf1.hq.local’s password:
dxj001@memsqlleaf2.hq.local’s password:
dxj001@memsqlleaf3.hq.local’s password:
dxj001@memsqlleaf4.hq.local’s password:
Toolbox will perform the following actions on host memsqlaggregator.hq.local:
· Run ‘memsqlctl add-leaf --host memsqlleaf1.hq.local --port 3306 --user root’
Would you like to continue? [y/N]: y
✘ Failed to run ‘memsqlctl add-leaf’
error running memsqlctl: error running command: `“/usr/bin/sudo” “-S” “-k” “–” “/bin/sh” “-c” "‘printf’ ‘f33eab5a-dbe2-485d-b566-6f60955490aa’ && ‘exec’ 'memsqlct
l’ ‘–json’ ‘–yes’ ‘add-leaf’ ‘–host’ ‘memsqlleaf1.hq.local’ ‘–port’ ‘3306’ ‘–user’ ‘root’"`: exit status 1
stderr: Error 1045: Access denied for user ‘root’@‘172.19.135.159’ (using password: NO)
Could not add leaf to cluster. Verify network connectivity between the node at memsqlleaf1.hq.local:3306 and the master aggregator.
Please ensure that you have entered the correct password for the node.
If the node does not yet exist, run ‘memsql-admin create-node’ and then retry this command.
I have verified ssh access across servers using ssh keys
Not sure what is wrong