How to organize communication between the site and the program on the VDS server using the HTTP protocol to ensure maximum efficiency?

Question

Database

Hey! There is such a problem. There is a site on shared hosting and a program on VPS. And you need to combine them somehow with maximum efficiency.

There is a site where people apply for processing. Applications are stored and displayed there. The VPS server has a program that will perform these tasks. What is the best way to make communication between these systems?

Suppose I added a task, it was added to the site database and a request was sent to update the data of the handler program (the same process when deleting) on ​​the server it will be processed until it is deleted from the site. As an option, I thought to update the data at a certain time.

Who is responsible for initializing the data update? Should the program processing the data have HTTP access? Or are there some tricky ways that the Pros use? ;-)

Thank you for your understanding and incomprehensible explanation =) I hope you will help me think it over.

Answer 1

If such an architecture is needed, then something like this:
- On the shared, we store tasks in the database and, on an event, push them into the queue.
- On VDS, we pick up tasks from the queue and execute them.
You can take any queue (for simplicity, you can take iron.io)