Unable to to do chaos Experiment on Azure SQL data base

zay9899 0
Viewed 45

I'm new to Chaos engineering. I'm trying to attach PAAS service hosted in Azure like SSMS(Azure SQL).

I'm using LitmusChaos and Gremlin tools to connect and attack but fail. is there any way I can validate? My objective to validate the Scaling-resilience and DR for SSMS.

litmus chaos spring-boot-chaos-monkey gremlin azure-sql-database
1 Answers

Chaos Experiment can only be performed on some targets which may directly or indirectly connected with Azure SQL Database, like Network Security Group (NSG). I have tried to repro the same for NSG connected with Azure SQL Database and it is working fine for me.

Please follow the below steps:

  1. Search for Chaos Studio in Azure Portal and select the same from the results.

enter image description here

  1. Before that, create a NSG and add it to the SQL Server, under Networking, add the virtual network rule associated with the NSG for secure connection.

enter image description here

  1. Now, in Chaos Studio, click on the Targets on left panel. Search for the NSG group you have created and select it. On the top Enable targets select Enable service-direct targets.

enter image description here

  1. Next, create the Experiment on the same page. Give basic details, Experiment designer details with Fault details and Target resources details. Refer below images.

enter image description here

enter image description here

  1. Once deployed, Start the experiment for the same.

enter image description here

  1. Wait for the experiment to complete and check the status for the same.

enter image description here

Utkarsh Pal0
Related