I want to get the response time of a couple of websites, without overloading the server in which I keep my database. The dns of the websites are located on a mysql database within a linux machine (Amazon Linux AMI). After I get the response time I want to insert the response time in the mysql database.
Firstly, I have done a php script on my server( where I keep my mysql database) but this took too long, and decided to let azure handle this task.
I have tried 2 different approaches:
- Using logic apps, but I couldn't receive the data sent by Postman in the logic app using POST. (this method however is costly because I need to call it from my server and loads the server too much )
- Using Web Apps, I have created a WebJob, and in the WebJob I have created a script that get me the response of the website (but here also I don't know how to take the send the dns from the database to the WebJob - the problem is how to connect the mysql database which resides on a Amazon Linux AMI machine to azure WebApps. I have tried using Hybrid connections, but only has support for windows machines).
Some helpful links:
I am opened to any suggestions!