I am working on a project where I need to implement real-time updates from a MySQL database table to a server. The goal is to ensure that any changes made to specific tables in the database are immediately reflected on the server side without relying on frequent polling.

I though of creating trigger in database sql to log the updated entry to a log table . then I will create a service in backend server which will read the data from log table and delete once its read.
is there any better approach ?