Jump to content


Photo

Galera Replication


  • Please log in to reply
6 replies to this topic

#1 00aet

00aet

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 30 March 2012 - 06:28 PM

Are there any plans to add galera monitoring to monyog?

thanks

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 31 March 2012 - 07:06 PM

We have not scheduled any plans for this currently. Our scheduled tasks reach 3-4 months into the future.




I know basically what Galera is but I never used it myself. Are you sure that you cannot create 'Custom SQl Objects' yourslef for this?




For 'Custom SQl Objects' Please refer:

http://www.webyog.co...efore-use-csos/

http://www.webyog.co...ject-in-monyog/




If Galera adds status variables and/or populates Information_Schema tables you can create 'Custom SQl Objects'.


Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 00aet

00aet

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 02 April 2012 - 02:03 PM

Very nice. Trying to dig thru the notification setup for the various monitors I'm playing with as there are a few things I would like to setup and I'm not making much progress. All of my custom SQL are status variables.

I have a monitor setup for a local state variable and I want to notify if that does not return a value of ON. If it not ON, can I return the value of another status variable? Galera stores a comment variable that describes the state value.

so I have wsrep_ready that should return ON, if it doesn't, I want to notify of that and include a wsrep_local_state_comment variable.

#4 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 03 April 2012 - 06:32 AM

I think you do not have to use CSO (Custom SQL objects) feature, you can do it using MOM variable itself.

You can create your own counter from Monitors page and in value and Alert condition section specify values you want to retrieve from :

show global variables;
show global status;


For example in case of "MySQL logs" --> "General log- Enabled?" counter "value" and "alert condition" shows:

Value
function x()
{
    if(MONyog.MySQL.Custom.Available != 1)
        return "(n/a)";

    if(MONyog.MySQL.GlobalVariables.log == "ON")
        return "Yes";
    else
        return "No";
}
Alert condition


function()
{
    if(this.Value == "Yes")
        return "Warning";

    return "None";
}

Similarly, you can create your own counter and apply any condition on a MOM variable which can be retrieved from show global variables and show global status.

Further, if you need any help we can arrange screen sharing session, let me know your Timezone and convenient time to have it?
For privacy you can create a support ticket by sending an email to 'support@webyog.com'.



Regards,
Mahesh

#5 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 04 April 2012 - 12:20 PM

Does it work for you or need any help?

#6 00aet

00aet

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 13 April 2012 - 09:31 PM

I just got back in the office after the mysql conference. I just set it up and the first go at it didn't work as expected, I will look a bit further.

#7 00aet

00aet

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 17 April 2012 - 05:18 PM

Got this working now, I was using the Globalvariables instead of Globalstatus. Haven't had any notifications from it but I suppose that's a good thing :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users