Add an option for SQL on IAAS VMs - Githubissues

adrianlavery / contosotraders-cloudtesting

The Contoso Traders app is a sample application showcasing Playwright, Azure Load Testing, Azure Chaos Studio.

https://cloudtesting.contosotraders.com

MIT License

1 stars 2 forks source link

Add an option for SQL on IAAS VMs #1

Closed adrianlavery closed 7 months ago

adrianlavery commented 7 months ago

Is your feature request related to a problem? Please describe. I'd like to demo using this application and chaos studio / load testing on IAAS workloads.

Describe the solution you'd like A simple first step would be to move the SQL databases from Azure SQL to SQL cluster on IAAS VMs. There should be a parameter flag, similar to the private endpoints one to say whether it should be deployed on IAAS/PAAS.

[x] #2
[x] Create bicep code to deploy a SQL cluster across 3 AZs
[x] Understand if the SQL connection string needs to be updated

adrianlavery commented 7 months ago

We'll need an AD domain and associated services to spin up a SQL cluster, so will run on a single server to reduce complexity