Can application use multiple databases?

Question

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. 12 авг. 2021 г.

Can an application have multiple databases?

Each option has its merit. Separate databases mean more maintenance on patches/fixes/updates, more overhead to administrate. But it also means easier segregation of data, ability to scale by splitting users to different database servers easier. It really depends on what your end goals and requirements are.

Should you use 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 a website have multiple databases?

You would just create two data sources and potentially two data access layers if you want to take it that far. At least for . Net/C#/VB.Net this wouldn't be a problem. I'm not sure I understand the benefit in this case but if you feel you have a good reason to separate the database, there's no reason it can't be done.

Can a project have multiple databases?

Generally, if one project consumes multiple databases, it is because it must consume different, often legacy sources of information that originated outside of this particular project. This is most common in Enterprise environments.

Expert · Answer