Create multiple database instances
Overview
If have only one database instance (in Oracle terminology, one database), we can skip this task.
Multiple instances provide...
- The ability to use different instances for development and production.
- Restricted access to sensitive information.
- An optimized configuration for each instance.
For example, if make changes to one of the instances, we can restart just that instance instead of restarting the whole system. Similarly, if take an instance offline, only the databases hosted on that instance are unavailable during the outage, while the other databases are unaffected.
See
- Create multiple DB2 database instances
- Create multiple Oracle databases
- Create multiple SQL database instances
Parent topic:
Create databases