Cost Benefit Analysis of Centralised and Distributed Database
Learn when to use horizontal sharding instead of vertical sharding and vice versa.
We'll cover the following
- Which database sharding approach is best for your organization?
- Pros and cons of centralized database (No-Sharding)
- Advantages and disadvantages of distributed database
- Query optimization and processing speed in a distributed database
- Strategy 01: Move parts to site A and process the query at A
- Strategy 02: Move Store and Sales to site B and process the query at B
- Strategy 03: Restrict Brand at site B to Wolf ones and move the result to site A
- Conclusion
- Ref:
Which database sharding approach is best for your organization?
For your organization and business to grow, prevent downtime, and reduce latency, you must scale your resources accordingly. You can scale these resources through a combination of adjustments to network bandwidth, CPU and physical memory requirements, and hard disk adjustments. Both horizontal sharding and vertical sharding involve adding resources to your computing infrastructure; your business stakeholders must decide which is right for your organization.
The following sections explains the pros and cons of no-sharding vs sharding.
Create a free account to access the full course.
By signing up, you agree to Educative's Terms of Service and Privacy Policy