Pattern Goal
The goal of the MySQL RDBMS Database Detail pattern is to obtain the list of Databases being managed by the SQL Server, and furthermore to obtain (optionally, and disabled by default) the list of Tables within these databases.
| Note: The patterns will not by default return the list of all tables within the discovered databases as this can have a marked impact on discovery of hosts with large database installations |
The information is then stored within the Foundation Model as DatabaseDetail Nodes.
The pattern connects to the SQL Server using a JDBC connection.
Configuration Required
The Database Detail Patterns require additional configuration before they can be used.
- Setting of Database Integration Point : - set the Connection Parameters, including Username and Password.
- Setting the port: the core TKU MySQL RDBMS Pattern will attempt to obtain the listening port for the Database server dynamically. In the case where it fails, the Database Detail pattern will use the default port which is set in its configuration parameters. If the default port is likely to be different in your environment, please alter the Pattern Configuration, according to your needs. Changing Pattern Configuration is detailed in Foundation 7.2 Documentation .
- Editing Pattern Configuration: decide whether the pattern should attempt to retrieve tables or not, and whether any specific Databases should be ignored
Database User Configuration
In order for Foundation to retrieve the Database details, it will need to be able to access the Database as a legitimate user, with privileges sufficient to execute the SQL Queries below.
SQL Queries Executed
The pattern executes the following SQL Queries.
- Obtaining a list of Databases being managed: SHOW DATABASES
- Obtaining a list of tables within a database: SELECT table_name FROM information_schema.tables WHERE table_schema = %db_name%
RSS
Tideway Blog