Automatic Rerouting of Databases
Go Up to Multi-Instance
Once multiple instance of InterBase servers are running on a machine simultaneously, this feature will allow setups where some database connections can be re-routed to a different InterBase server. The user will have to manually start the different instance of InterBase as an application or service.
Server Side Setup
In order to setup simultaneous InterBase servers on a machine follow the instructions specified above. Once these machines are set up, and running, follow the instructions below to setup and use the DB_ROUTE database table in the ADMIN.IB.
The structure of the DB_ROUTE table is as follows:
| Column Name | Data type | Length | Description |
|---|---|---|---|
|
DB_NAME |
CHAR |
1024 |
Complete name of the database to be rerouted, including the path of the database on the server. e.g. Server_Name:DATABASE_DIR\EMPLOYEE.Ib |
|
SERVICE_NAME |
CHAR |
30 |
Service name to look up in the services file for the port number to be re-routed to. The look up takes place at the server side, the client is only aware of the port number and not the service name. e.g. ib__a |
|
ACTIVATE_ROUTE |
BOOLEAN |
Set to true if this re-routing is active, flase it this re-routing is disabled. |
The service name that is entered in the set DB_ROUTE table must exist in the services file:
gds_db 3050/tcp #default interbase port number ib__a 3051/tcp # A’s interbase port number
Client Side Settings for Automatic Rerouting of Databases
No client side settings are required. In order to access the database database_name.ib located in the directory database_dir. On a remote machine remote_host accepting connections on a default port number. The database name specified in the client API or any InterBase driver would be REMOTE_HOST:DATABASE_DIR\DATABASE_NAME.IB.
In order to setup the database server AGNI so that it can re-route in coming connections, for the database c:\smistry\employee.ib to an older server running on port number specified by the service ib__a. The ADMIN.IB database on server AGNI will need the following row of information in DB_ROUTE table.
| DB_ROUTE Column Name | Value |
|---|---|
|
DB_NAME |
Server_Name:DATABASE_DIR/EMPLOYEE.IB |
|
SERVICE_NAME |
ib__a |
|
ACTIVATE_ROUTE |
TRUE |
Since the DB_ROUTE is a regular InterBase table in the ADMIN.IB database, you can use regular SQL to enter, modify or remove database re-routing from information.