question

ShivendooKumar-8455 avatar image
0 Votes"
ShivendooKumar-8455 asked AlbertoMorillo edited

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

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.



azure-sql-databaseazure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.