0

I want to create a system like sending push notifications to the registered device id's whenever there is a change in the online web server's MySQL databases.

Chetan J Rao
  • 905
  • 9
  • 14
  • This may help https://stackoverflow.com/questions/13474012/invoke-pusher-when-mysql-has-changed – Milorad Apr 30 '18 at 13:58
  • That would require to install the UDF sys_eval and the source code @GramHolo – Raymond Nijland Apr 30 '18 at 14:00
  • There isn't a method out of the box within MySQL.. PostgreSQL has a out of the box solution with LISTEN / NOTIFY -> ( https://www.postgresql.org/docs/current/static/sql-notify.html) Stackoverflow example https://stackoverflow.com/questions/42852595/real-time-postgresql-client-updates-based-on-notification – Raymond Nijland Apr 30 '18 at 14:03
  • Other solution can be a combination between android and node.js.. Node.js support's clients push when you use websockets.. For example one client inserts you detect a successful insert and notify all connected clients with a event. – Raymond Nijland Apr 30 '18 at 14:14

1 Answers1

0

You can try to use Maxwell Daemon to monitor the mysql binary logs updates and then send the push notification to your devices.

hutabalian
  • 3,254
  • 2
  • 16
  • 13