… to announce that version 1.0 of Percona Monitoring Plugins is now available. The Percona Monitoring Plugins are high-quality plugins, templates, and add-ons for Nagios and Cacti, so you can add world-class MySQL monitoring to your existing enterprise open-source monitoring products. Version 1.0 fixes a variety…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… forecast scalability and performance The new Percona Toolkit release is available for download today. It is also in our YUM and… also a version 1.0 GA release of the Percona Monitoring Plugins project. It features a variety of bug fixes.
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… you want to have a good level of availability, you need a good monitoring and alerting system to quickly react to replication… the number of MySQL servers. For the write VIP, MMM monitors the state of the current master and, upon failure, try… that is running on each server. The manager controls and monitors the state of the replication and assign virtual IPs for…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…/ubuntu-images-testing/ubuntu-lucid-daily-i386-server-20100618 099720109477 available public i386 machine aki-aca44cc5 instance-store So, lauching 2… internal network of the other host. On the monitor host, we will have: root@monitor:/etc/ha.d# cat ha.cf autojoin… 2 Nodes configured, unknown expected votes 1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL For the sake of simplicity, we will…
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
… the resources scripts On each host: root@monitor:~# touch /usr/local/bin/mysql root@monitor:~# chmod u+x /usr/local/bin/mysql… stonith-enabled -v false root@monitor:~# crm_attribute –attr-name symmetric-cluster –attr-value false root@monitor:~# crm configure crm(live)configure… on hamysql but, if hamysql is not available, will be able to run on monitor. That’s the basis we will expand…
Post: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 17, 2010 By 8 Comments
…) Launch a new instances Reconfigure the shared resources Reconfigure instance monitoring Reconfigure the database clients Facing these challenges, a customer recently… a cheap small instance monitor the availability of a large (any size) and taking measures to keep MySQL available. A few weeks later…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… be stated that high-availability is not only a matter of technical solutions, good management practices covering monitoring, alerting, security and documentation… is basically the service monitoring frequency and timeout that fix it. Level of Availability The level of availability is basically the guaranteed percentage…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… for Percona Replication Manager. All the parts are opensource and available under the GPL license. Keep in mind this solution is…=”root” \ test_passwd=”rootpass” \ op monitor interval=”5s” role=”Master” OCF_CHECK_LEVEL=”1″ \ op monitor interval=”2s” role=”Slave” OCF_CHECK… given should at least have select on that table. op monitor: An entry is needed for each role, Master and Slave…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… Here are estimates of the level of availability offered by the various solutions. Level of availability Simple replication 98 to 99.9… extensive testing, fire drills, full documentation, monitoring, alerting, backups, migration to production and post migration monitoring. Of course, it is the safest…
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
… on the MySQL node. At its smallest expression, the instance monitoring script is a simple empty loop that will run forever… while [ 1 ] do sleep 60 done Although fully functional, this monitoring script is rather weak could be not working and the… written but let’s provide a basic functional one that monitor MySQL with the mysqladmin ping command. #!/bin/sh # MySQL basedir…
