cluster control install for managing existing mysql cluster

Follow

Anand N S

• November 09, 2018 08:50

Hello ,

 

I am a new user & Installed cluster control & got the Http port up & running.   While importing the existing mysql cluster, Its mandating two working data nodes .

 

IN my setup I have only one working data node & other as some random ip.

 

How to import mysql cluster into cluster control in this scenario ? 

0

• Official comment

  

  Krzysztof Ksiazek

  • November 09, 2018 09:18

  Hi,

  MySQL NDB Cluster requires at lest two data nodes for high availability. For this reason ClusterControl does not support importing a single data node.

  Thanks,
  Krzysztof

  Comment actions Permalink
• 

  Anand N S

  • November 12, 2018 03:23

  root@clustercontrol-mysql:/opt# s9s cluster --register --cluster-type=ndbcluster --nodes='ndb_mgmd://10.142.0.21;ndbd://10.142.0.22,mysql://10.142.0.23' --vendor=oracle --cluster-name='ndbcluster' --wait

  The 'cluster --register' is not a valid mode.

   

  Is this a valid command ?  Please suggest, if there is a command line way of forced import of ONE node SQL cluster & later install multiple nodes with the help of cluster control

  0

  Comment actions Permalink
• 

  Paul Namuag

  • November 12, 2018 20:27

  Hi Anand,

   

  It looks right to me:

  [root@testccnode html]# s9s cluster --register --cluster-type=ndbcluster --nodes='ndb_mgmd://10.142.0.21;ndbd://10.142.0.22,mysql://10.142.0.23' --vendor=oracle --cluster-name='ndbcluster' --wait

  Register NDB Cluster

  | Job 1072 RUNNING    [ █        ] ---% Importing Cluster      

  ^CJob 1072 RUNNING    [      █   ] ---% Importing Cluster      

  Aborted...

  [root@testccnode html]# s9s --version

        ___            _              _     

   ___ / _ \ ___      | |_ ___   ___ | |___ 

  / __| (_) / __|_____| __/ _ \ / _ \| / __|

  \__ \\__, \__ \_____| || (_) | (_) | \__ \

  |___/  /_/|___/      \__\___/ \___/|_|___/

   

  s9s Version 1.7.0 (Virgo)

  BUILD (1.7.0-release) 2018-11-08 10:05:39+00:00

  Copyright (C) 2016-2018 Severalnines AB

   

  Could you check what version do you have.

  0

  Comment actions Permalink
• 

  Anand N S

  • November 13, 2018 12:17

  Hello,  I have the latest version....as per this tool update.

   

   

  testgtotest@clustercontrol-mysql:~$ sudo apt-get install s9s-tools

  Reading package lists... Done

  Building dependency tree       

  Reading state information... Done

  s9s-tools is already the newest version (1.7.20181108-release1).

  The following package was automatically installed and is no longer required:

    grub-pc-bin

  Use 'sudo apt autoremove' to remove it.

  0 upgraded, 0 newly installed, 0 to remove and 36 not upgraded.

  0

  Comment actions Permalink
• 

  Anand N S

  • November 13, 2018 12:33

  After updating the VM user (instead of root user), I am able to proceed.    The next issue I see here is:

   

  testgtotest@clustercontrol-mysql:~/.ssh$ s9s cluster --register --cluster-type=ndbcluster --nodes='ndb_mgmd://10.142.0.21;ndbd://10.142.0.22,mysql://10.142.0.23' --vendor=oracle --cluster-name='ndbcluster' --wait 

  No user name set.

  0

  Comment actions Permalink

Please sign in to leave a comment.