How to Setup MySQL Discovery on Your Turbonomic Instance

Document created by Anson McCook Expert on Aug 26, 2015Last modified by vbranici on Feb 28, 2018
Version 15Show Document
  • View in full screen mode

The following setup is only applicable to users with the Application Control Module or Application Edition running on Operations Manager 5.3 or higher.


If you do not have the Application Control Module or Application Edition, please contact your Customer Experience representative or your Account Executive for licensing.


Ensure your Turbonomic appliance is running 5.3 or higher. Follow these instructions to update:

How To Perform an Operations Manager "Offline Update" - Latest Links Included


Table of Contents



In this document, we’ll review how to setup control for the MySQL database running within Turbonomic.


To enable MySQL discovery on any MySQL database please reference this document: How to Target MySQL Servers in Turbonomic.


To be able to target the MySQL database of a Turbonomic appliance there are two things that must happen:

- the firewall must allow you to remotely connect to the database at the right port.

- the database itself must be willing to communicate with VMs other than localhost. 


Also, refer to How to Target MySQL Servers in Turbonomic about how to create the target itself.


Open the Firewall for the MySQL Port

The firewall on the VM containing the MySQL instance must allow connections to the public MySQL port.



We will use Yast to install

1) Run yast. Open a Terminal session and enter the command:


2) Open Software Management.


3) If you see the following error, Cannot access installation media simply select Skip. This prompt may appear multiple times. Select Skip each time.

Select OK to any Warnings that appear



4) Search for Firewall. Scroll down to yast2-firewall and press Enter. Then select Accept.


5) Exit yast for the new options to be available. Quit Yast.


6) Run yast again.


7) Under Security and Users select Firewall.


8) Under “Custom Rules”, set the Firewall Zone to the interface you would like to communicate to through to access MySQL. In this example, we will be setting the Firewall zone to the External Zone. Select Add and press Enter.



9) Fill out the fields below. In the example, we are using a configuration that will open up the port to anyone and everyone. Enter the values appropriate for your configuration. You should only open the port for known trusted source networks to ensure security.


Source Network: 0/0

Protocol: TCP

Destination Port: 3306


Select Add.


10) Select Next and Finish.


11) Quit Yast.


There are any number of good articles explaining how to open a firewall port for your version of Windows. Web search is your friend.

Unbind MySQL from LocalHost (Turbonomic 5.6+)


In Turbonomic versions 5.6+ and up, you'll need to unbind MySQL from the localhost. Note that if you update your Turbonomic appliance, you will need to repeat these steps to unbind MySQL from LocalHost.


1) SSH into Turbonomic (with credentials: root/vmturbo)


2) Open the following file:

vi /etc/my.cnf


3) Navigate to the following line:



4) Comment out the line:



5) Save the file and quit


6) Restart MySQL:

service mysql restart