Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- James Willans
April 19, 2005, 3:25 pm
rate this thread
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
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum