In instance management we focus on the process of adding, removing and managing instances and instance groups.
You will need to add database instances to dbWatch Control Center in order to monitor, manage and create reports from your database instances.
There are 4 ways to start adding database instances to dbWatch.
- Adding instances using the wizard
This is the most common way to get started. It is simple and works great for adding instances for testing and for scenarios where you are adding less than 50 database instances at once.
Wizard step by step for MS SQL Server
Wizard step by step for Oracle
Wizard step by step for PostgreSQL
Wizard step by step for MySQL
- Adding instance from autodiscovery
dbWatch Control Center can scan networks, both once and periodically to detect database instances that are not already added. This is typically used on larger installations after initial installation to detect new database instances that you might not know of or that has been added without notifying the DBA’s. Control Center will detect the database instances and pre-fill in details for the wizard process that is used to add the instances.
- Bulk import of instances
Bulk import of is used in larger deployments where a CSV formatted file with the details of database instances to be added to Control Center is processed in an automated fashion. This is a good method when adding more than 50 database instances. It is very quick once the CSV file is created, and database environments of around 200 database instances can be installed and configured in less than one hour.
- Using Control Center Commandline (CCC) scripts
The CCC is a commandline tool used to run scripts that interact with dbWatch Control Center or database instances that is added to it. This method is used to automate the process of adding database instances to Control Center, for example as part of automated deployment of database servers.
Post your comment on this topic.