Deep diving into MySQL monitoring setup

Database Administration
1 April 1:30PM - 4:30PM @ Ballroom A

Experience level: 
Intermediate
Duration: 
3 hours tutorial
This is a hands-on tutotial on setting up MySQL monitoring for your production systems using Nagios (the main focus), Cacti and briefly Zabbix. The tutorial is based on the real best practice from Percona Remote DBA team and proven over time. Topics and tasks to be covered: * Active and passive monitoring with Nagios * Monitoring OS parameters of MySQL server * Monitoring MySQL service, its properties and replication * Monitoring backups * Monitoring HA solutions such as MHA, MMM, HAproxy, Percona XtraDB Cluster etc. * Monitoring Amazon RDS * Notification methods and pagers * Useful Nagios hints * Trending and graphing with Cacti * Quick walkthrough of monitoring and graphing with Zabbix and how it's different from Nagios Prerequisites: - good knowledge of Linux, shell and MySQL; - be familiar with Nagios; - a laptop with Virtualbox installed.


Speakers

Remote DBA, Percona
Biography: 
Roman is a Remote DBA in Percona. His duties include handling remote DBA ops, developing and improving of monitoring tools. He also maintains Percona Monitoring Plugins project. Roman holds both B Sc and M Sc Honors Degree in Computer Sciences. Prior to joining Percona, Roman worked as a Technical Support Engineer for hosting software and services on Positive Software Corporation later acquired by Parallels Inc., on different positions such as Configuration Manager, DBA, Senior Software Engineer and Technical Leader on outsourcing projects on SoftServe Inc. and on some smaller companies. The largest project was Cisco Ironport SenderBase Security Network. Roman holds certificates OCP MySQL 5 and CCNA.
Remote DBA , Percona
Biography: 
Akshay Suryawanshi, joined Percona in the month of March 2013. He began his role as a Support Engineer and then moved to the fast growing Remote DBA team. Before joining Percona he worked as a MySQL DBA managing more than a dozen clients. He specializes in MySQL internals especially InnoDB and frequently blogs about it at mysqlunlimited.blogspot.com. Akshay has done Bachelor of Science specialized in Information technology, OCP certified in Oracle earlier in his career. He currently stays at Mumbai, India, which is the economic capital of India and one of the largest cities in the world.
Support Engineer, Percona
Biography: 
Michael joined Percona in October 2007. He serves in several roles, including Wikimaster and company schedules administrator. In the latter role, he is involved in assuring Percona's 24x7 support coverage. He was also the organizer of the company's first two annual all-staff meetings. He is working now in Support team as Support Engineer. Prior to joining the company, Michael worked as a consultant on Enterprise Resource Planning and Customer Relationship Management systems. His introduction to computers was in 2000, when he began his university studies. He now has an undergraduate degree in computer sciences, and in 2011 he earned an MBA. Michael was born in Chervonograd, a small city in western Ukraine. He was married on his 25th birthday. He loves his wife and son and tries to spend as much of his free time as possible with them. His hobbies are music and cars.

Slides