As a JMX MBean, MySQL Connector/MXJ requires a JMX v1.2 compliant MBean container, such as JBoss version 4. The MBean will uses the standard JMX management APIs to present (and allow the setting of) parameters which are appropriate for that platform.
If you are not using the SUN Reference implementation of the JMX libraries, skip this section. Or, if you are deploying to JBoss, you can also skip to the next section.
We want to see the MysqldDynamicMBean in action inside of a JMX
agent. In the
package is a custom JMX agent with two MBeans:
The MysqldDynamicMBean, and
A com.sun.jdmk.comm.HtmlAdaptorServer, which provides a web interface for manipulating the beans inside of a JMX agent.
When this very simple agent is started, it will allow a MySQL database to be started and stopped with a web browser.
Complete the testing of the platform as above.
Current JDK, JUnit, Connector/J, MySQL Connector/MXJ
This section requires the SUN reference implementation of JMX
If not building from source, skip to next step
Rebuild with the "sunri.present"
ant -Dsunri.present=true dist re-run tests: java junit.textui.TestRunner com.mysql.management.AllTestsSuite
Launch the test agent from the command line:
java com.mysql.management.jmx.sunri.MysqldTestAgentSunHtmlAdaptor &
From a browser:
Observe the MBean View
Scroll to the bottom of the screen press the startMysqld button
Back to MBean View
Scroll to the bottom of the screen press stopMysqld button
Kill the java process running the Test Agent (jmx server)