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.
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.
How about if we use Azure SQL Server DB (Azure SQL Server software as a Service) and implement high availability by replicating data.
How about Cosmos DB?
what are other options?
Please share your thoughts. The solution should have a very fast look-up response and cost-effective.