Uploaded image for project: 'Cloudify-Recipes'
  1. Cloudify-Recipes
  2. RECIPES-4

MySQL master-slave mode does not work when startDetectionQuery=""

    Details

      Description

      This is an issue with the MySQL recipe. When startDetectionQuery is set to an empty string (i.e., startDetectionQuery=""), the MySQL master-slave mode does not work.

      The symptom is that although application can write data to the master node, the data never gets replicated to the slave node. On the slave node, mysql is running, but the processes/threads for performing the replication of data from master to slave are not running. The log shows that the slave node is waiting for the master node to become ready.

      This issue is caused by the logic in mysql_startDetection.groovy. The service attribute "masterIsReady" is never set when startDetectionQuery="". It is only set in the branch when startDetectionQuery is not empty.

      Thus, to fix this issue, we need to add code to set masterIsReady to true when the master node is ready in the situation where startDetectionQuery is empty as well.

        Gliffy Diagrams

          Activity

          Hide
          uri Uri Cohen added a comment -
          Thanks for submitting Lianping.
          We'll look into it. If you have fixed the code already fill free to submit a github pull request.
          Show
          uri Uri Cohen added a comment - Thanks for submitting Lianping. We'll look into it. If you have fixed the code already fill free to submit a github pull request.
          Hide
          tamir Tamir Korem added a comment -
          Fixed.
          Show
          tamir Tamir Korem added a comment - Fixed.
          Hide
          tamir Tamir Korem added a comment -
          Added a check of an empty startDetection in masterslave more
          Show
          tamir Tamir Korem added a comment - Added a check of an empty startDetection in masterslave more
          Hide
          tamir Tamir Korem added a comment -
          Show
          tamir Tamir Korem added a comment - Get the latest version from https://github.com/CloudifySource/cloudify-recipes

            People

            • Assignee:
              tamir Tamir Korem
              Reporter:
              lianping Lianping Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development