Need to implement High availibalilty for Customer Information lookup on Website?

Question

Hi All,
Looking for a robust and cost-effective solution for this requirement:

We have customer information (2-3 million rows) and it is used across the website as a lookup. Looking for a solution to quick lookup of customer database.

1. How about if we create VM on Azure cloud to host SQL Database and that can have customer information. We need 2 Identical VMs to host primary and secondary DBs (Replicated DB). If the primary is down then Secondary should be online. Data should always be sync between the primary and secondary.
2. How about if we use Azure SQL Server DB (Azure SQL Server software as a Service) and implement high availability by replicating data.
3. How about Cosmos DB?
4. what are other options?

Please share your thoughts. The solution should have a very fast look-up response and cost-effective.

Answer 1

If the customer information is only added to and almost never changed but that data is read/queried constantly you should consider Azure SQL Server + Azure Cache for Redis (caching). Here is a webinar that can help you understand how it fit or not to your scenario.