Database Configurations
A Model Manager server database can be set as either active or inactive depending on whether or not it should accept connections from COMSOL Multiphysics or the Model Manager server web interface. You would typically deactivate a Model Manager server database when you want to change its configuration settings or perform a restore from backup. One of the databases can also be set as the default one, which is the default server database that users will connect to when accessing the Model Manager server from COMSOL Multiphysics. It is also the database initially selected as the Current Database in the web-based asset management system.
The Database Configurations page, opened by clicking Databases in the System navigation sidebar, shows a table with the configurations of all Model Manager server databases. If you selected the Managed PostgreSQL® and Managed Apache Solr™ check boxes in the Products step of the Model Manager server installation, the configuration of a single database — Default managed database — is initially shown in the table. This database is automatically created by the Model Manager server when the latter is started for the first time — see also The Default Managed Database.
The table columns are:
•
The Label column — the label of the database. Used for display purposes in the Model Manager server web interface.
•
The Status column — the active and default status of a database.
Click on the label of a Model Manager server database on the Database Configurations page to show more details for that database. Click the Add button to add a new database.
The Default Managed Database
If you selected the Managed PostgreSQL® and Managed Apache Solr™ check boxes when installing the server, a default Model Manager server database is automatically created when the Model Manager server starts for the first time. This database uses managed server components with default locations for their data directories and backup directories. These locations are not ideal, as backups are placed on the same physical disk as the data itself. You are recommended to either add new Managed Server Components or update the configurations of the automatically added default components — see also Moving a Model Manager Server Database.
A default managed database is only created if you selected both the Managed PostgreSQL® and Managed Apache Solr™ check boxes in the Products step of the Model Manager server installation. If you select just one of them, only the corresponding default managed server component will be created.
Place the backup directories for the managed SQL database server and the managed resources directory on a physical disk different than that of their corresponding data directories if you decide to use the default managed database. This will protect you from complete data loss in case of a server disk crash. See The Managed SQL Database Server Page and The Managed Resources Directory Page for instructions.
•
Default Data Directories
•
Default Managed Backup Directories
Adding Databases
You can add a new database to the Model Manager server. This is useful if, for example, you want to use different options than The Default Managed Database but at the same time want to keep the default database around as a reference.
To add a new database:
1
Write a label for the database in the Label field.
2
Write an optional alias for the database in the Alias field. When set, the alias must only contain lowercase Latin alphabet characters, numerical characters, underscores, and dashes. The alias can contain, at most, 100 characters.
The alias field is required if you want to connect to a Model Manager server database other than the default server database from a COMSOL Multiphysics installation.
3
In the SQL Database>Type list, select among the options:
-
Managed — to use a SQL database in one of the Managed SQL Database Servers. See Managed SQL Databases.
-
Custom — to use a SQL database in an external SQL database server. See External SQL Databases.
4
In the Resources Directory>Type list, select among the options:
-
Managed — to use one of the Managed Resources Directories.
-
Custom — to use an external directory on the file system. See External Resources Directories.
5
In the Search Indexes>Type list, select among the options:
-
Managed — to use search indexes in one of the Managed Search Index Servers. See Managed Search Indexes.
-
Custom — to use search indexes in an external search index server. See External Search Indexes.
6
Click the Save button.
You need to activate the database before users can connect to it from COMSOL Multiphysics or the Model Manager server web interface — see The Database Configuration Page.
The Database Configuration Page
The Database Configuration page contains details on the configuration of a database added to the Model Manager server. The configuration fields are:
•
Label. The label of the Model Manager server database. Used for display purposes in the Model Manager server web interface.
•
Alias. An optional alias for the Model Manager server database.
The alias is used as an identifier to, for example, connect to the Model Manager server database from a COMSOL Multiphysics installation even when the database is not set as the default one.
•
SQL Database. The SQL database used by the Model Manager database.
•
Resources Directory. The resources directory used by the Model Manager database.
•
Search Indexes. The two search indexes used by the Model Manager database.
Click the Edit button to edit the configuration for the database.
Click the Test Connection button to test if the configuration can be used to connect to the database.
Click the Deactivate button to deactivate the database. Users will not be able to connect to the database from COMSOL Multiphysics or the Model Manager server web interface. Click Activate to make the database available again.
Always deactivate a database before editing its configuration.
If you have configured multiple databases, you can click the Set as Default button to set the database as the current default. Click Remove as Default to remove it as the current default.
Click the Delete Permanently button to permanently delete the database configuration.
Clicking Delete Permanently will only delete the configuration for the Model Manager server database; it will not delete any data. You can add the database again using a new configuration.