Job "Create Galera Cluster" continuously running

Comments

6 comments

  • Official comment
    Avatar
    Ashraf Sharif

    Hi Stephane,

    The job is specifically for ClusterControl automatic deployment in Docker environment. You can simply delete the entry inside cmon.containers table and restart cc-auto-deploy using supervisorctl. For example:

    $ docker exec -it clustercontrol mysql -uroot -p -e 'DELETE FROM cmon.containers WHERE ip = "10.129.21.196"'
    $ docker exec -it clustercontrol docker exec -it clustercontrol supervisorctl restart cc-auto-deployment

     

    Regards,
    Ashraf

  • Avatar
    Metairie, Stephane

    That sounds good. Could I shutdown this service :

     cc-auto-deployment

    I think I have to shutdown in any case when I'm building the cluster (Deploy Nodes in Cluster Control GUI)

    Thanks a lot

  • Avatar
    Metairie, Stephane

    Now I have another issue :

    I have 3 nodes 10.129.15.148, 202,204. 

    The error below is one proxysql. I don't understant this message?

     

     

     [10:15:54]: Host 10.129.15.142 is already in another cluster. See http://support.severalnines.com/entries/82995999-Host-already-in-another-Cluster for suggestions.
     
     [10:15:54]: 10.129.15.142: Checking if host already exists in another cluster.
     
     [10:15:54]: All 3 hosts are accessible by SSH.
     
     [10:15:54]: 10.129.21.202: Access with ssh/sudo granted.
     
     [10:15:53]: 10.129.21.198: Access with ssh/sudo granted.
  • Avatar
    Metairie, Stephane

    mysql> select hostname from hosts;

    +-----------------------------------------+
    | hostname |
    +-----------------------------------------+
    | deploymentconfig-0-galera-4-5899z |
    | deploymentconfig-0-proxysql-1-tc7kj |
    | deploymentconfig-1-galera-1-n42rb |
    | deploymentconfig-1-proxysql-1-m8nqr |
    | deploymentconfig-2-galera-1-kfh6v |
    | deploymentconfig-clustercontrol-1-bffzh |
    | localhost |
    +-----------------------------------------+
    7 rows in set (0.00 sec)

  • Avatar
    Metairie, Stephane

    mysql> select hostname from mysql_server;
    +-----------------------------------+
    | hostname |
    +-----------------------------------+
    | deploymentconfig-1-galera-1-n42rb |
    | deploymentconfig-2-galera-1-kfh6v |
    +-----------------------------------+
    2 rows in set (0.00 sec)

  • Avatar
    Metairie, Stephane

    mysql> select hostname from server_node;


    +-----------------------------------------+
    | hostname |
    +-----------------------------------------+
    | localhost |
    | deploymentconfig-0-galera-4-5899z |
    | deploymentconfig-clustercontrol-1-bffzh |
    | deploymentconfig-1-galera-1-n42rb |
    | deploymentconfig-2-galera-1-kfh6v |
    | deploymentconfig-0-proxysql-1-tc7kj |
    | deploymentconfig-1-proxysql-1-m8nqr |
    +-----------------------------------------+
    7 rows in set (0.00 sec)

Please sign in to leave a comment.

Powered by Zendesk