Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 35 Next 5 Older Entries

Displaying posts with tag: Nagios (reset)

Percona Monitoring Plugins 1.1.3. Addressed CVE-2014-2569.
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.3.

Changelog:

* Introduced more secure location of PHP script configs to harden a Cacti setup
* Addressed CVE-2014-2569

We have introduced a more secure location /etc/cacti/ for PHP script configs. Earlier, the only way was to keep .php.cnf configs inside of scripts/ folder which falls under the web directory of Cacti setup, thus provides a potential security vulnerability. We strongly recommend to move all .php.cnf files from /usr/share/cacti/scripts/ to /etc/cacti/ and also harden your Cacti setup.

A new tarball is available


  [Read more...]
Percona Monitoring Plugins 1.1.2, now with Amazon RDS support
+1 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.2.

Changelog:

* Added Nagios plugin and Cacti template for Amazon RDS
* Added Nagios config template to the documentation
* Added an option to pmp-check-pt-table-checksum to check MAX(ts) of latest checksum
* Added generic Nagios plugin for PT tables
* Extended pmp-check-mysql-processlist with max user connections check
* Zabbix MySQL.running-slave item failed with MySQL 5.6 (bug 1272358)
* ss_get_mysql_stats and MariaDB does not use have_response_time_distribution (bug 1285888)
* Cacti Monitoring plugins and SNMP via TCP (bug 1268552)

Shortly about the new features.

Amazon RDS support








  [Read more...]
Percona Monitoring Plugins 1.1.1 release (enterprise-grade MySQL monitoring and graphing)
+1 Vote Up -0Vote Down

Percona announces the release of Percona Monitoring Plugins 1.1.1 to address the critical bug that appears after the 1.1 upgrade.

Changelog:

* Cacti mysql graphs stop working with data input field “server-id” after 1.1 upgrade (bug 1264814)
* Non-integer poller errors for MySQL Query Response Time (bug 1264353)

A new tarball is available from downloads area or RPM and DEB packages from our software repositories. The plugins are fully supported for customers with a


  [Read more...]
Percona Monitoring Plugins 1.1, now with Zabbix support
+2 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Monitoring Plugins 1.1. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios, Cacti and Zabbix, and are delivered in the form of templates, plugins, and scripts.

In this release we have added MySQL template for Zabbix 2.0.x adopted from the existing Cacti one.

Changelog:

* Added MySQL template for Zabbix 2.0.x (first release)
* Added FreeBSD support to Nagios plugins, partially rewritten pmp-check-unix-memory

  [Read more...]
Percona Monitoring Plugins 1.0.5 release for MySQL
+1 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.5 for MySQL. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.

Changelog:

* Added mysql-ca option to ss_get_mysql_stats.php (bug 1213857)
* Added user info to the idle_blocker_duration check of pmp-check-mysql-innodb (bug 1215317)
* Extended pmp-check-mysql-processlist with more locking states (bug 1213859)
* ss_get_mysql_stats.php did not work with custom mysql port (bug 1213862)
* ss_get_mysql_stats.php silently failed



  [Read more...]
Why is the ibdata1 file continuously growing in MySQL?
+1 Vote Up -0Vote Down

We receive this question about the ibdata1 file in MySQL very often in Percona Support.

The panic starts when the monitoring server sends an alert about the storage of the MySQL server – saying that the disk is about to get filled.

After some research you realize that most of the disk space is used by the InnoDB’s shared tablespace ibdata1. You have innodb_file_per_table enabled, so the question is:

What is stored in  [Read more...]

Percona Monitoring Plugins 1.0.4 release: Now with Galera graphs
+2 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.

Changelog:

* Added Galera/MySQL Monitoring Template for Cacti
* Added “Disk Read/Write Time per IO Request (ms)” graph
* Added “MySQL InnoDB Buffer Pool Efficiency” graph
* Switched ss_get_mysql_stats.php to PHP MySQLi extension and made it working with SSL (bug 1193097)
* Added user info to the max_duration check of



  [Read more...]
Vote for MySQL[plus] awards 2011 !
+5 Vote Up -0Vote Down

First of all, I wish you a happy new year.
Many things happened last year, it was really exciting to be involved in the MySQL ecosystem.
I hope this enthusiasm will be increased this year, up to you !

To start the year, I propose the MySQL[plus] Awards 2011
It will only take 5 minutes to fill out these polls.
Answer with your heart first and then with your experience with some of these tools or services.

Polls will be closed January 31, so, vote now !
For “other” answers, please,  let me a comment with details.

Don’t hesitate to submit proposal for tools or services in the comments.






  [Read more...]
Summary of Blog Posts for Week of June 25
+0 Vote Up -0Vote Down

We make a lot of posts that give IT tips and advice, as well as recommendations on how to use Monitis, so here is a summary of the posts for this week in case you missed them.

Monitoring IIS With VBScript via Monitis; It’s so Easy!

This post demonstrates how to monitor an IIS using Monitis Custom Monitors and VBscript. You can use the Monitis API to monitor your own custom metrics. This is very powerful because it lets you monitor any IIS metrics you like, set thresholds and receive notifications.

  [Read more...]

Nagios Checks for HandlerSocket
+0 Vote Up -0Vote Down
I’ve written some new Nagios checks for HandlerSocket. check_handlersocket is a part of http://code.google.com/p/check-mysql-all/, and is meant to be called locally on the HandlerSocket server (usually via NRPE), but the perl-Net-HandlerSocket module must be installed. Feedback is welcome, usage is as follows: Usage: check_handlersocket -K [options] Options: -K, --check= The check to run --columns= Comma-separated [...]
10 Steps: MySQL Monitoring through Nagios: Install & Configure
+2 Vote Up -0Vote Down
Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL […]
If you fork it, will they come?
+4 Vote Up -0Vote Down

There is much excitement this week (understandably) about the formation of the Document Foundation and the LibreOffice fork of Openoffice.org.

Alan Bell sees correlation with the previous fork of Joomla from Mambo and has illustrated the potential impact that forking a project can have with a Google Trends chart, where Mambo is the blue line, and Joomla is the red line:

A similar chart for Debian (blue) and Ubuntu (red) is also instructive:

Or what about Nagios (blue) and Icinga


  [Read more...]
Careful how you monitor MySQL
+8 Vote Up -0Vote Down

I was recently struck by a problem which is unusual. In order to keep an eye on the database server I use nagios, cacti, merlin (http://www.mysql.com/products/enterprise/monitor.html" target="_blank) and some local scripts to monitor the database instance and ensure that it is working properly.  That normally works fine.  The different monitor processes do various things, one of which is to monitor the replication status of a slave, and warn me if the replication is not working or if it’s behind. This is done with the command SHOW SLAVE STATUS.

The server I was looking at runs some large local batch jobs aggregating data. Unfortunately, I was experiencing that replication was interfering with these batch jobs so decided to see if things would perform better if

  [Read more...]
Don’t forget to monitor your nameservers
+0 Vote Up -0Vote Down
As I mentioned in a past article I got my IPv6 connectivity working so started working on setting up various IPv6 services. One of these was to setup my name server so it also worked on IPv6. This worked fine, but recently I lost my IPv6 connectivity but thought no more about it. I’m trying [...]
Cloud monitoring keeps open source in cool crowd
+0 Vote Up -0Vote Down

One of the first special reports I wrote for 451 Group was an analysis of the open source systems management vendors on the scene — GroundWork, Hyperic, Zenoss, OpenNMS Group, Nagios Enterprises and some others. These named ones are those that made it and while there was some reckoning in the market and there have been changes, it is interesting to see these players still plugging away, pushing into new markets and powering open source for systems, network and application monitoring and management, including cloud computing environments.

When acquired by SpringSource a year ago, there was some question as to the real value of open source systems monitoring and management

  [Read more...]
Knowing your PERC 6/i BBU
+2 Vote Up -0Vote Down
I’ve recently become supremely disappointed in the availability of Nagios checks for RAID cards. Too often, I see administrators rely on chance (or their hosting provider) to discover failed drives, a dying BBU, or a degrading capacity on their RAID cards. So I began work on check_raid (part of check_mysql_all) to provide a suite of [...]
451 CAOS Links 2010.02.02
+1 Vote Up -1Vote Down

Oracle’s plans for Sun’s OSS. The UK’s updated OSS strategy. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Oracle’s plans for Sun’s OSS
# Oracle’s MySQL strategy slide.

# eWeek reported that database thought leaders are divided on Oracle MySQL.

# Savio Rodrigues and Computerworld on Oracle’s plans for MySQL, other open source assets.

# Zack Urlocker is leaving Oracle/Sun/MySQL.

# Red Hat’s Mark Little



  [Read more...]
451 CAOS Links 2009.12.23
+0 Vote Up -1Vote Down

Red Hat’s Q3. Google’s definition of open. Copyright assignment. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Red Hat reported third quarter net income of $16.4m on revenue up 18% at $194m

# Jonathan Rosenberg, Google’s senior vice president, product management, presented Google’s


  [Read more...]
451 CAOS Links 2009.11.20
+0 Vote Up -0Vote Down

Google launches Chromium project, Terracotta acquires Quartz. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Google launched the Chromium OS open source project, a prelude to the Chrome OS, while Canonical confirmed that it is contributing to the development of Chrome OS.

# Terracotta


  [Read more...]
451 CAOS Links 2009.10.30
+0 Vote Up -0Vote Down

Government adoption. Financial results. New funding. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

Government approval
The US Department of Defense issued guidance on the adoption of open source software, while ComputerWorld reported that the U.S Department of Defense has open-sourced an enterprise


  [Read more...]
MMM Nagios plugin
+1 Vote Up -0Vote Down

There is a nagios plugin available on the MMM's google-code page, but if you didn't find it yet, here it is:

http://code.google.com/p/check-mysql-all/wiki/check_mmm

You can call this plugin over nrpe. I'm already working on to fork a version which more useful with passive checks.

This plugin was developed by Ryan Lowe (Percona).

Monitoring MySQL Product Options
+0 Vote Up -0Vote Down

I’ve had plenty of comments on specific products to Monitoring MySQL Options before providing the completed list. Here are the results from my survey to give everybody a more complete list.

Nagios 25 xxxxxxxxxxxxxxxxxxxxxxxxx MONyog 8 xxxxxxxx Cacti 4 xxxx Munin 3 xxx MySQL Enterprise Monitor/Merlin 3 xxx   [Read more...]
Monitoring MySQL options
+3 Vote Up -0Vote Down

My recent poll What alert monitoring do you use? showed 25% of the 58 respondents to bravely state they had no MySQL monitoring. I see 1 in 3, ~33% in my consulting so this is consistent.


There is no excuse to not have some MySQL Monitoring on your production system. At the worse case, you should be logging important MySQL information for later analysis. I use my own Logging and Analyzing scripts on every client for an immediate assessment regardless of what’s available. I combine that with my modified statpack to give me immediate text based analysis,

  [Read more...]
Nagios Checks For MMM
+0 Vote Up -0Vote Down
I’ve written some new Nagios checks for MMM (MMM on Google Code … MMM on Launchpad). check_mmm is a part of http://code.google.com/p/check-mysql-all/, and is meant to be called locally on the MMM Monitor server (usually via NRPE). Feedback is welcome, usage is as follows: Usage: check_mmm --cluster C# Options: --cluster= The MMM Cluster to check [...]
Reflections on MySQL Enterprise Monitor
+0 Vote Up -0Vote Down

Merlin is MySQL’s Enterprise Monitor (http://www.mysql.com/products/enterprise/monitor.html" target="_blank), a system designed to monitor a number of MySQL database servers and provide useful feedback to the DBAs as to how they are running and what things may require attention.

It provides various things:

  • graphs of key database and server performance indicators: load average, cpu usage and mysql specific information such as number of database connections, replication delays, buffer usage statistics, etc…
  • a set of advisors which are intended to tell you if things are not configured properly and what to do to correct the problem.
  • monitoring of servers which are linked together through replication
  • the latest version of merlin (v2.0, which has been available since the beginning of the year) additionally adds via mysql proxy
  [Read more...]
Monitoring MySQL
+0 Vote Up -0Vote Down

The slides for my Monitoring MySQL talk , which I gave earlier today in an overcrowded MySQl Developersroom at Fosdem are now online, both at my site and at Slideshare

As of now I actually expect people to use those slides for schoolwork or next year in a main Fosdem track :)
As afterall that is the goal of Open Source and spreading the word ..

MySQL Monitoring Shoot Out View more presentations from Kris Buytaert. (tags: mysql monitor)
  [Read more...]
Nagios Monitoring
+0 Vote Up -0Vote Down

[inline:nagios-pic.png] Tag1 offers hosted Nagios monitoring, tuned for database servers. We offer monitoring of not just uptime and disk space, but MySQL performance metrics, such as InnoDB Buffer Pool Hitrate and MyISAM Index Usage. Our Nagios instance can not only notify you of service impacting problems, but of performance issues and signs that a service failure maybe coming in the future. We like to think of this as preventative monitoring.

read more

Do we want an Open Source MySQL Monitoring tool ?
+0 Vote Up -0Vote Down

Matt Reid wants to know what we want in an Open Source MySQL monitoring solution ?

He is working on the second incarnation of Monolith and wants input from the MySQL community.

Now for me the bigger question is if we want an isolated tool that runs stand alone, or a tool which we can integrate it in something we already have.

To me there is a difference between a tool that I want to use to debug my environment, such as Mytop or MySQL Activity Report, in that case I need some tool that quickly installs with little dependencies and little impact.

On the other side I want a tool that is constantly there, that tells me about trends and performance history. But there I don't want an isolated toool, I want something fully integrated where I can correlate different measurements from disk io,

  [Read more...]
Setting up MySQL monitoring with Nagios
+0 Vote Up -0Vote Down

It’s been a while since my last post! I have a few half-written entries, but I figured I just get one out there so I don’t appear to have dropped off the face of the planet

Being more of a DBA than a sysadmin myself, I’ve noticed that there is a surprising dearth of information regarding how to actually get nagios set up to monitor MySQL, especially if you’re not experienced with nagios.

In my own experience, MySQL monitoring often ends up being a homegrown thing, especially if you’re a small shop. It is definitely a good idea to consolidate all of your monitoring, DB-related or not, into one solution: roll-your-own monitoring solutions can be brittle and burn you in the end. One example that comes to mind, a few years back i had a quick perl-based script to monitor replication and set it to mail a few

  [Read more...]
Netways Nagios Conference 2008
Employee +0 Vote Up -0Vote Down
The Netways Nagios Conference 2008 in Nürnberg (DE) was opened today by Ethan Galstad, creator of Nagios. He gave an overview of how Nagios evolved and the steady growth of the monthly downloads, now reaching 16k!
The Nagios 3.0 overview was quite nice. Apparently lots of effort was put in optimizing it for bigger setups, like doing host checks in parallel and changing internal structures not using linked lists.Great was also to hear that the web interface is being revamped, as well as the Embedded Perl becoming some kind of plugin, called Event Broker Modules. This is however for the next experimental versions (v3.).NRPE/NSCA are probably doomed to go into maintenance. Ethan said they would likely be replaced by more standard protocols and web services.
MySQL

  [Read more...]
Showing entries 1 to 30 of 35 Next 5 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.