Mysql notification

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Hi All,

We've only used MySQL in a very cursory way supporting PHP scripts
running on a server.  We now have a requirement to write an application
that shares data using a centralised repository.  The application will
be written in Java and we may potentially use MySQL as the data store
using JDBC drivers to bridge the two.  One of the key requirements is
that the java application is notified when the data store is updated or
changed such that it can dynamically update its view to the user.  Does
MySQL provide anything that may provide for this, is there a standard
way for dealing with this pattern of usage?  One solution would be to
continuously query the database, but that seems prohibitively expensive
- particuarly for large data sets.


Re: Mysql notification

Mysql has a logging feature which logs all transactions. The manual
describes using this to synchonize 2 mysql databases where the shadow mysql
uses the log file from the master copy to update itself.
I suspect this file (log) could be monitored for changes. Don't know if
that's sufficient. I know they are working on "triggers" in some future

Quoted text here. Click to load it

Site Timeline