Search code examples
virtual-machinemysql-clusterrundeck

Rundeck project and job sync between 2 instances with backend as mysql cluster

I have set up 2 rundecks in 2 VMs and mysql cluster so Rundeck #1 on VM#1 connects to Mysql DB#1 and similarly Rundeck #2 on VM#2 connects to Mysql DB#2.

The problem now I have is whenever I am creating a project / job in rundeck #1 that I am not able to see it in rundeck #2. What should I do?

Any help will be appreciated

Solution

  • The issue can be fixed by maintaining the default engine in my.cnf. So in my case I just modified the /etc/my.cnf

    Introduced the following option below the header [mysqld]:

    default-storage-engine=NDBCLUSTER

    And did a mysql restart and the tables sync started to happen.

    delete the rundeck db before proceeding with any modifications.

    Thanks and hope this helps everyone facing such issues.