Push functionality from MySQL database

Question

I have a python application. I wanted to know whether there is any functionality(i.e. event or trigger) in mysql which will allow me to notify my python application when data is inserted in the database. I would like to avoid the use of polling because it will cause a large overhead on my database.

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

It's not directly for Python,but Is there a way to watch a mysql database for changes using perl? gives two option how to do that:

1.Create an audit table in the database, and have the trigger write the relevant info there; and have your watching application poll the audit table for new entries. You're still polling, but in a controlled way which won't hit the server too hard.

2.Have the trigger call an external app through a UDF.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 17, 2014 at 9:13

Klaus D.

14.5k5 gold badges44 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Push functionality from MySQL database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related