<html><body><div>Hi Pavel,</div><div><br></div><div>Yes, I chart everything from collectd over to graphite and use Icinga to alarm on everything.</div><div><br></div><div>Icinga is better than Nagios. More active. An improved fork.</div><div><br></div><div>Anyway, where do the following live in collectd? (Otherwise, I have</div><div>to one-off each with the collectd "exec" plugin and that costs one</div><div>process per measurement during the running system... which is not scalable.</div><div><br></div><div>Does Florian need to be in on this? He offered to help.</div><div><br></div><div>Needed items:</div><div><br></div><div>Retrieved_Gtid_Set: e42edd38-2f71-11e3-b83b-02a15cb45f0d:344269919-487420351<br>Executed_Gtid_Set: 1709fc15-6903-11e3-af9f-06de0b35f7f1:1, e42edd38-2f71-11e3-b83b-02a15cb45f0d:1-487420351<br>Slave_IO_Running: Yes<br>Slave_SQL_Running: Yes<br><br>Thanks!</div><div><br></div><div>--Stuart</div><div><br>On Oct 12, 2014, at 10:12 PM, "Pavel V." <pavel2000@ngs.ru> wrote:<br><br></div><div><blockquote type="cite"><div class="msg-quote"><div class="_stretch"><span style="white-space: pre-wrap;" data-mce-style="white-space: pre-wrap;">Hi, Stuart.<br><br><br> > Our test case is flatlining due to<br> > very low replication data need. <br><br> > The other 4 stats that we look <br> > at a lot:<br> > <br> > Retrieved_Gtid_Set: e42edd38-2f71-11e3-b83b-02a15cb45f0d:344269919-487420351<br> > Executed_Gtid_Set: 1709fc15-6903-11e3-af9f-06de0b35f7f1:1, e42edd38-2f71-11e3-b83b-02a15cb45f0d:1-487420351<br> > Slave_IO_Running: Yes<br> > Slave_SQL_Running: Yes<br> > <br> > Are these anywhere in the collectd mysql plugin or do you think<br> > collectd plugin exec will be needed?<br><br>Do you want to place these on charts?<br>I can imagine how the last two metrics will look, but two the first?<br><br>Maybe you need other tool like Nagios which will monitor replication process and send you<br>notifications if something will fail? Personally I'm using both Nagios and Collectd on my servers.<br><br><br>-- <br>Regards,<br> Pavel mailto:<a href="mailto:pavel2000@ngs.ru" data-mce-href="mailto:pavel2000@ngs.ru">pavel2000@ngs.ru</a><br><br></span></div></div></blockquote></div></body></html>