Relational database

Your relational database is a critical element for performance and disaster recovery.

The provided Derby database, while sufficient for proof-of-concept work, is often insufficient for the enterprise. Full-featured databases like Oracle, MS SQL Server, or MySQL are better options. Ideally, the database should be configured for high-availability, high-performance, and be backed-up regularly.

10-20 GB of database storage is sufficient for most environments. For Oracle, use an architecture that is based on Oracle RAC in most cases. For Microsoft SQL Server, use a clustered configuration in most cases. For MySQL, use MySQL Cluster in most cases.


Feedback