

|
Valid XHTML v1.0
Author Profile
Top Authors
Log In to set widget preferences
| Author | # |
|---|---|
|
185 |
|
148 |
Anonymous User
|
49 |
|
28 |
Kimberly Hieber
|
27 |
|
23 |
Note: some conversations may be proxied or secured, thereby causing # differences
Subscribe
Partners
Recent
Tags
Log In to set widget preferences
Recent
Log In to set widget preferences
Most Active
Log In to set widget preferences
Popular
Log In to set widget preferences
|
|
MySQL Replication Monitoring
by Akif on 2008-11-03 08:00 PM read 107 times |
Listed below are some of the techniques/tools that can be used to monitor the MySQL Master/Slave replication process.
MySQL Enterprise Monitor: This is a comprehensive commercial product that provides a number of monitoring features. Details are available here.
Custom Perl Scripts: This is a simple set of scripts that uses the basic commands MySQL commands for retrieving master/slave status and performing a comparison between them. These could be modified/enhanced and combined with monit to check periodically and send out emails if the lag time is beyond a certain limit or if any errors are encountered. A basic sample of these scripts is available here.
Custom Ruby Scripts: We could write our own scripts in Ruby to do the same tasks as mentioned above with the Perl Scripts.
No current tags
Log In to Reply |
Log In to Copy |
Tell a Friend
|
Trackback URL: http://www.kalivo.com/trackback/1841-mysql-replication-monitoring
