The same system currently runs as multiple separate sites.
How it works is the apache+tomcat+postgres web service.
if you decide to consolidate these multiple sites into one site
If you want to lump multiple data into the same DB,
One possible problem is the primary key (continuous number) in the log table overlaps
The primary key is tied to columns in other tables, and the workload is quite heavy.
The complexity of the database configuration also results in high-risk responses.
So, is there a good way to consolidate data without changing the existing table configuration?
apache postgresql tomcat database-design database
DB consolidation is not necessary if "multiple sites are integrated into one site" is simply "want to run multiple sites on one server."Simply migrate your current DB.
On the other hand, if you are "integrating multiple sites into one site" to consolidate DB, this is a question that no one can answer because it has a system-wide requirement.Even with the "log table" shown as an example, it depends on the requirement whether it should be one or more.
© 2024 OneMinuteCode. All rights reserved.