Configuring Remote Databases
This page describes how to add and delete remote databases. A remote database is a database that is physically located on another server system, as opposed to a local database which is physically located on the local server system.
Adding a Remote Database
You can define a remote database on the local server if the database’s host is configured on that server as a distributed cache data server. For instructions for adding a data server, see Configuring an Application Server.
To add a remote database, follow these steps:
Navigate to the Remote Databases page (System Administration > Configuration > System Configuration > Remote Databases) and click Create Remote Database to launch the wizard.
Select the data server that hosts the database from the Remote Server drop down.
Choose how you want to specify the remote database directory from the Remote Directory radio buttons:
Select databases from a list lets you choose from a drop-down list of database directories on the remote server. If the remote data server cannot currently be reached, the drop-down list is empty.
Enter your own database specification lets you enter the database directory directly, but the Portal does not validate your entry.
Enter a database name (its name on the local server; it does not need to match its name on the remote server); see Rules for Database Names. You have defined a remote database.
You can optionally specify the directory in which streams associated with this database are stored. By default, the stream location for a remote database is the InterSystems IRIS Temp directory (install-dir\mgr\Temp).
InterSystems recommends that you use the default location.
Click Save to configure the remote database.
You can click the Edit link for a remote database at any time to modify the remote database fields.
Deleting a Remote Database
To delete a remote database, click the Delete link in the appropriate row. The Delete Database page displays information about the database you are deleting, and lets you:
Select the namespaces mapped to this database for deletion. You cannot delete a database if a namespace is mapped to it, so unless you select all of the listed namespaces you cannot delete the database.
You cannot delete namespaces that are also mapped to other databases. When this is the case, a link is provided to take you to the Namespaces page, where you can modify the database mappings of the namespaces involved. After you delete all mappings to another database, that database will be removed from the list of databases you have to delete.
Confirm that you want to delete the database after reviewing information about it by clicking Delete Database Now.
This action simply removes the database from the local instance’s remote database configuration; the actual database and its local configuration on its host are not affected.