Checking slave status

Follow

Arifin

• July 27, 2017 05:00

Hello, is it possible to create developer studio to get slave status? And if replication break (from the status reply) is it possible to force mysql shutdown the service?

0

• 

  Johan

  • July 27, 2017 08:12

  Hi

  Here is an example to read the properties and print them out:

  https://gist.github.com/freddielunchbird/d0eef43a5dfa6e643b9979e19eda2250

  To shutdown a node, i must check with the devs; i could not find this command implemented. But it is a very small command to add.

   

  
  BR
  johan

   

  0

  Comment actions Permalink
• 

  Arifin

  • July 28, 2017 06:39

  Hello Johan,

  Thank you for good response. So basically it's possible to execute something like this "service mysql stop" after replication failure?

   

  0

  Comment actions Permalink
• 

  Johan

  • July 28, 2017 07:22

  Hi,

   

  yes it could be by using the 'system' function on the host  object.

   

  function main()

  {

  var hosts = cluster::hosts();

  var host = hosts[0];

  var retval;

   

  retval = host.system("ls -lha /home");

  if (!retval["success"])

  {

  error("ERROR: ", retval["errorMessage"]);

  }

   

  print("Result: ", retval["result"]);

  return retval["success"];

  }

  0

  Comment actions Permalink

Please sign in to leave a comment.