Monitoring of MySQL for Drupal service

Monitoring set-up

  • Monitoring of MySQL service for Drupal is done using Oracle Enterprise Manager and free management plugin delivered by Pythian group (http://www.pythian.com/news/mysql-plugin-for-oracle-grid-control/)
    • The management plugin installed on agents on OMS server - monitoring is done outside of MySQL servers
    • The plugin is installed on agent on dbsrvg3109 and is set-up to monitor MySQL DB on the drupal-v VIP
    • Name of the target in OMS is "Drupal_MySQL"
    • Basic monitoring template ("MySQL PROD") and notification rule ("MySQL") is set-up in OMS.
    • Emails are sent to people subscribed to "MySQL" notification rule only when the service is down.
  • This set-up has a limitation on MySQL version as only versions <=5.5.9 are supported in the newer version of MySQL an incompatible change in protocol standard has been introduced
    • We will try to contact Pythian to see if they have an updated version of the plugin

Reporting on performance

  • The management plugin gathers data on various metrics (~120 different metrics) and provides reporting and plotting in OMS:
    • "Quick status" - Status, processes, response time
    • "Commands and executions" - executions - current and history, joins per minute (history)
    • "Connections and threads" - connections and threads, running and idle, cache hit ratio
    • "Binary Log Cache" - binary log transaction statistics

-- DawidWojcik - 23-May-2011

Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2011-05-23 - DawidWojcik
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    DB All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback