How to get here

To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client.

This will bring up the “Add Instance” wizard, which will guide you through the following steps.

Select Instance Type and Input Connection Details

mysql-installation-define-connection-details

The Host info is the hostname or ip address of the database instance.
The Port is the port number where the listener process is listening on.

dbWatch will attempt to select the correct instance type based on the entered port number. If the instance type is wrong, select the correct one in the drop down.
The authentication types available will depend on the selected instance type.

Currently, MySQL will only allows Password authentication.
You need to specify a username with admin privileges that will be used during the installation.

By default dbWatch will select the most apropiate JDBC driver for the database instance. It is possible to select a specific JDBC driver and set driver properties by clicking on “Advanced Driver Setup”. Read more.

Click “Next”.

Select Instance Type and Connection Details

mysql-installation-define-monitoring

Specify the group and license for the instance. Default groups are Development, Test and Production, but you can easily create and customize your own groups based on your requirements.
The licensing options available will depend on your license. The selected option will determine what monitoring jobs are available.

You can choose to register this instance with or without a local database schema. This choice will influence the available monitoring jobs. Some jobs require objects in the database (procedures, tables etc.), others do not. We recommend installing a database schema, as this will give the most monitoring options.

You can stick with the jobs that are selected by default or customize the selection as needed.

Click “Next”.

Define Module authentications

Within this window you have an option to choose which credential to use for each module within dbWatch.
You can use the existing user or select a new user whether password.

mysql-installation-define-module-authentications

If you’ve finished specifying a credential for each module. Click Next.

Instance Installation

mysql-installation-add-instance-wizard

Specify a display name for this instance. You can also provide a description or any relevant information you want to remember about this instance.

Click Install to start installing.

Underneath you will see the status of various jobs being installed.

mysql-installation-installation-complete

We’ve now successfully added the MySQL instance in our dbWatch monitor.

If dbWatch cannot install the software due to a Super Privilege Error, see Super Privilege Error for steps in solving it.

← Adding Postgres Instance / Bulk installing instances →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment