0

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

KronnorK
  • 539
  • 5
  • 17

2 Answers2

0

I would first try to switch the databases, i.e. Rundeck#2 connects to MySql DB#1 to see if the jobs are visible.

If this is the case, then you have a sync issue.

If jobs are still not visible, then i assume that there are some identification problems of the Rundeck instances.

Just my 2 cents.

ljubomir
  • 1,495
  • 1
  • 21
  • 40
  • I setup a mysql cluster which works fine as the database created in one gets reflected in another...but when i configured rundeck db it also got reflected in another data node... now when i create a project and jobs in one rundeck then it is not reflecting in another.. can pls you help me with the issue? – KronnorK Sep 22 '15 at 03:44
  • 1
    @KronnorK Good, so the DB setup is correct. I believe these pointers can help you moving forward: https://github.com/rundeck/rundeck/issues/757 & https://groups.google.com/forum/#!topic/rundeck-discuss/aXkDkNeTEp0 – ljubomir Sep 22 '15 at 06:51
  • Got it working... I had to change the Engine to ndbcluster... that made it working – KronnorK Sep 24 '15 at 05:27
  • Glad to hear that. It would be nice if you post your answer here and accept it, so others can benefit too. – ljubomir Sep 24 '15 at 06:48
0

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.

KronnorK
  • 539
  • 5
  • 17