Galera Plugin (Java) by Pythian
A fork of New Relic Platform MySQL Plugin Java
- 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
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.
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.