Designing scalable databases
As applications grow, you need to be able to accommodate the need for more storage and more processing power to cope with demand. Sometimes, this growth is organic and happens naturally over time as your service becomes more popular.
For some applications, the need to rapidly scale out is known ahead of time—for example, with reporting solutions where you know you will be ingesting large amounts of data.
Within Azure, there are many options for achieving growth. However, the correct choice will, as always, depend on your precise requirements and solution architecture.
Both Cosmos DB and Azure SQL Database design for scale from the outset. As we saw in the previous section, the available tier is built around Azure storage with separate compute nodes. Upgrade to the Hyperscale tier, and your databases can grow up to 100 TB. However, in order to manage additional storage, you must also increase the compute capabilities.
The default options for...
