Should I use two databases?

Question

suppose you wanted to publish or reuse some external database, and keep it separate from your primary database.This would be a good reason to use 2 databases. You can drop and reimport the external database at any time without affecting your database, and vice versa. 10 нояб. 2009 г.

Is it better to have multiple databases?

Good reasons to create separate databases would be to support different availability requirements or simplify administration. For example if your databases require very different backup schedules or different recovery models. Another reason would be if you may want to run them on different instances.

Can I use multiple databases?

With Master-Slave topologies and modern practices such as Database sharding becoming increasingly ubiquitous, database administrators (DBAs) and developers are working with multiple databases more than ever before. Doing so is made a lot easier by software that can accommodate multiple database connections.

Can an application have 2 databases?

Multiple database technologies can be used with monolithic applications, and can even seem more natural in a microservices environment, where each service would have its own database. This approach, however, is not bulletproof. Far from it, actually.

Should I separate database?

A database is the unit of backup and recovery, so that should be the first consideration when designing database structures. If the data has different back up and recovery requirements, then they are very good candidates for separate databases.

Expert · Answer