Trade-offs in Databases

Which is the best database sharding approach?

Both horizontal and vertical sharding involve adding resources to our computing infrastructure. Our business stakeholders must decide which is suitable for our organization. We must scale our resources accordingly for our organization and business to grow, to prevent downtime, and to reduce latency. We can scale these resources through a combination of adjustments to CPU, physical memory requirements, hard disk adjustments, and network bandwidth.

The following sections explain the pros and cons of centralized and distributed database:

Advantages and disadvantages of a centralized database

Advantages

• Data maintenance, such as updating and taking backups of a centralized database, is easy.

• Centralized databases provide stronger consistency and ACID transactions than distributed databases.

• Centralized databases provide a much simpler programming model for the end programmers as compared ...