My question is as follows,
I need to write a script that monitors a database table for changes and then when an update to the table happens that information gets sent to a web service to be sent to a clients database. Our database is a MySQL database.
A trigger isn't a good solution because our database is hosted on amazon web services and the only available methods are only useable if you have the SUPER privilege.
The only solutions i have been able to find are 1. Websockets or 2. longpolling.
I'm really not sure the best possible way to go about this.. can anyone point me in the right direction on what i should be searching for?