Push notification from MYSQL

Question

I am having my database created in MYSQL and a WebSocket application(Autobahn Wamp WebSocket v1) created in Python. I have an application which makes entries in my database.

My requirement is that I need to create a trigger in MYSQL which would notify my Python WebSocket application(Autobahn Wamp WebSocket v1) when data gets inserted in my database.

I would like to know whether it is possible to achieve the above mentioned functionality or not, and if yes how?

Thanks in advance.

Answer 1

I think you can use pubsubsql which is Mysql push notification service. The link is as follows :
https://github.com/pubsubsql

Answer 2

The python-mysql-replication project maybe interesting. It allows you to receive event like insert, update, delete with their datas from your application