How to get here
To add a MySQL instance, click on the “Add” icon on the main toolbar.
This will bring up the “Add Database Instance” wizard, which will guide you through the following steps.
Select Installation Type
The first step of the wizard lets you select the type of installation.
Select MySQL as the database type.
There are two types of installations available, Add Database Instance adds a single instance and Add Database Instance (BULK) lets you add several instances at once.
Adding instances using BULK uses more default settings and thus allows for less customization. Select “Add Database Instance”.
Next specify the given name, group and connection details for this instance.
Group specifies the group this instance will sort under, the default groups are Development, Test and Production.
You also need to specify a login with the sa role that will be used during the installation (and to test connectivity to the instance)
If you check the Management/SQL/Properties login checkboxes, this login will be used as default for these logins. (This can be changed later)
Name and Monitoring
Next you specify a user and password for the dbwatch database that will be created on the instance and the dbwatch monitoring framework will be installed here (a set of tables and procedures used for monitoring).
clicking *Next” will proceed directly to the last install screen.
Select Tasks and Alerts
Next select the tasks and alerts you wish to install. A number of tasks will be pre selected, these are the recommended tasks for a standard installation.
Here you can see a summary of the installation details you have provided. If you are satisfied, click “Next”.
The instance will now be registered in dbWatch. Depending on the modules selected, network and instance, this process can take from a few seconds to a few minutes.
When the installation is completed, you should get the following message.