Geek Answers Handbook

Business and journal data separated by DB or Schema?

When creating a monolith, you probably want to somehow separate log data / technical data and business / operational data. Assuming you are using only one RDBMS DB instance, are you splitting data with multiple databases in a DB instance or one database with multiple database schemas?

+8
database rdbms database-schema
source share
1 answer

It depends on how accessibility and connectivity of your system is created. What is the data that is stored in these Databases. If they are connected by data, they can be stored on the same database instance, but if they are partially connected and can be partially executed, if one system is unavailable, then it should be in different copies.

Detailed explanation: -

1) When you use one database instance and use several databases, you are faced with the problem that if your connection drops (due to a system failure or mysql server is down), all the Databases as they are on the same instance also unavailable, so all of your applications are affected.

2) When you split a database instance for each database, then if any one database system is down, your other applications have no effect. In addition, in another application, only an application can work, depending on p>

In addition, in both cases, I think you should also use the replication mechanism so that load balancing can be performed in the slave Databases.

0
source share

More articles:


All Articles