Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Galera Cluster

Published and supported by Pythian Open-Source DB


Galera Plugin (Java) by Pythian

A fork of New Relic Platform MySQL Plugin Java


Metrics Included:

  • Excessive replication conflicts (high rate of wsrep_local_cert_failures and wsrep_local_bf_aborts)
  • Excessive Flow control messages (wsrep_flow_control_sent/ wsrep_flow_control_recv)
  • Large replication queues (wsrep_local_recv_queue).
  • Queue sizes (wsrep_local_recv_queue, wsrep_local_send_queue)
  • Flow control (wsrep_flow_control_sent, wsrep_flow_control_recv)
  • Number of transactions in and out of this node (wsrep_replicated, wsrep_received)
  • Number of transactions in and out in bytes (wsrep_replicated_bytes, wsrep_received_bytes)
  • Replication conflicts (wsrep_local_cert_failures and wsrep_local_bf_aborts)
  • InnoDB Buffer Pool Metrics
  • Connection Metrics

Requirements

The requirements for running this plugin are:

  • A New Relic account. Sign up for a free account here
  • Java Runtime (JRE) environment Version 1.6 or later
  • A server running MySQL Version 5.0 or greater
  • Network access to New Relic (authenticated proxies are not currently supported, but see workaround below)

Note: The MySQL Plugin includes the Connector/J JDBC Driver and it does not need to be installed separately.


Installation

Step 1 - Downloading and Extracting the Plugin

The latest version of the plugin can be downloaded here. Once the plugin is on your box, extract it to a location of your choosing.

note - This plugin is distributed in tar.gz format and can be extracted with the following command on Unix-based systems (Windows users will need to download a third-party extraction tool)

    tar -xvzf newrelic_galera_plugin-X.Y.Z.tar.gz

Step 2 - Configuring the Plugin

Check out the configuration information section for details on configuring your plugin.

Step 3 - Running the Plugin

To run the plugin, execute the following command from a terminal or command window (assuming Java is installed and on your path):

    java -Xmx128m -jar plugin.jar

Note: Though it is not necessary, the '-Xmx128m' flag is highly recommended due to the fact that when running the plugin on a server class machine, the java command will start a JVM that may reserve up to one quarter (25%) of available memory, but the '-Xmx128m' flag will limit heap allocation to a more reasonable 128MBs.

For more information on JVM server class machines and the -Xmx JVM argument, see:

Step 4 - Keeping the Plugin Running

Step 3 showed you how to run the plugin; however, there are several problems with running the process directly in the foreground (For example, when the machine reboots the process will not be started again). That said, there are several common ways to keep a plugin running, but they do require more advanced knowledge or additional tooling. Startup scripts for RHEL / Debian / Ubuntu (Upstart) can be found here

Further information including configuration steps can be found here

The Galera Cluster plugin extends the power of New Relic's monitoring capabilities.


Get This Plugin

Already have a New Relic account? Log in and begin using this plugin.

If you don't have a New Relic account, follow these three simple steps:

How To Install A Plugin

Installing a plugin is simple and fast.

Installing
a Plugin
  1. Step One

    Sign in to your New Relic account

  2. Step Two

    Select and install plugin

  3. Step Three

    Start seeing data

That’s it. You’re done. Simple.

Sign Up for New Relic

Back to top icon