Configure MySQL as the only Database Type used by the Smarts SolutionPack

Products

• VMware Smart Assurance

Issue/Introduction

This article provides details for using MySQL as the Database Type in M&R.

• In this configuration, the MySQL database holds both the active and inactive (archived) events.
• In the past, different databases were used in Watch4net for active and inactive (archived) events.
• When you upgrade older Watch4net releases to M&R, you need to consider which database you want to use to show the event history in the reports. 

Choice of database for M&R:

• MySQL database holds active and inactive (archived) event data
• Datastore database(x100 type database) holds inactive (archived) event data. When Datastore is chosen, the MySQL database is still used but it holds only active event data

We recommend using the Datastore for inactive (archived) data for performance reasons, but this KB article covers how to configure the MySQL database to hold active and inactive (archived) event data.

Environment

M&R - 7.x

Resolution

To use MySQL as the only Database Type for the Smarts SolutionPack, do the following:
 

1. Install the SolutionPack for EMC Smarts.

Note: The PDF attached to this article includes the following articles that provide instructions for this step:

• SolutionPack for EMC Smarts Summary Sheet
• How to Set Up SAM, EMC Smarts, and the SolutionPack for EMC Smarts

2. During installation, choose MySQL as the Database Type in the Events section of the SolutionPack configuration window. The following example has the database on the same host:

 

 

3. From Centralized Management > Logical Overview > Miscellaneous > Web-Servers (1) > Tomcat :: Default - <hostname-or-IP>, expand the Configuration files and edit the APG.xml file found here: 
 

conf\Catalina\localhost\APG.xml

 

 

 

4. Look for the following line in the file:
 

 

 

5. Uncomment the resource link as shown in the following example:

6. Restart the Tomcat service to apply the change in the active environment.

Additional Information