Creating independent database server environments on the same computer allows you to perform the following actions:
When you use multiple residency, each database server has its own configuration file. Thus, you can create a configuration file for each database server that meets its special requirements for backups, shared-memory use, and tuning priorities.
You can separate production and development environments to protect the production system from the unpredictable nature of the development environment. You might also find it useful to isolate applications or databases that are critically important, either to increase security or to accommodate more frequent backups than most databases require.
If you are developing an application for use on a network, you can use local loopback to perform your distributed-data simulation and testing on a single computer. (See Using a Local-Loopback Connection.) Later, when a network is ready, you can use the application without changes to application source code.
However, running multiple database servers on the same computer is not as efficient as running one database server. You need to balance the advantages of separate database servers against the extra performance cost.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]