Events not getting triggered for MySQL Views

rodrigogs / mysql-events

A node package that watches a MySQL database and runs callbacks on matched events.

BSD 3-Clause "New" or "Revised" License

136 stars 52 forks source link

Closed ghost closed 5 years ago

ghost commented 5 years ago

I'm trying to set a watch on a MySQL view, but it is never getting triggered on view update. Doesn't it support view change events?

rodrigogs commented 5 years ago

I never tested, but I dont think It would work :/

ghost commented 5 years ago

I tried and it's not working. Is there any workaround to make it work?

rodrigogs commented 5 years ago

I don't think so. If it's not working, it's because MySQL doesn't writes binlog data for views.