Back to course home
0% completed
Vote For New Content
What is best strategy to use no of databases to host partitions
Nagaraju P
Sep 12, 2024
Say there are ~30 data partitions. Usually each partition will be hosted in separate database instance. So, for 30 partitions, 30 database instances needed. We place LB to balance partitions and replications can be done as well. This will be huge cost for 30 database instances.
Question:
To save costs, if we want to use say 5 database instances, is it allowed to host more than one partition in single database instance? If Yes, How do we load balance the partition and also do replication as multiple partitions are part of single base instance?
0
0
Comments
Comments
K
kartech11 9 months ago
Not necessary that each partition has to be in a separate database instance. They are separate tables not database instances.