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, you should skip this section. Or, if you are deploying to JBoss, you also may wish to skip to the next section.
We want to see the MysqldDynamicMBean in action inside of a JMX
agent. In the com.mysql.management.jmx.sunri
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
PATH,JAVA_HOME,ANT_HOME,CLASSPATH
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:
http://localhost:9092/Under MysqldAgent,
select "name=mysqld"Observe the MBean View
Scroll to the bottom of the screen press the button
Click
Back to MBean ViewScroll to the bottom of the screen press button
Kill the java process running the Test Agent (jmx server)