Mirroring the ZM database
Posted: Thu Feb 19, 2004 3:14 am
Hello All,
After a little fiddling and and some good help on this forum, I now have zm up and working fine. Great program and great work Philip.
This might be a little outside the scope of this forum, but here goes.
My application calls for a server to be located remotely which can only be accessed by modem. There will be toll charges for each call, so I do not want to spend a whole lot of time checking and reviewing events. Also I want to be able to maintian a second database that will contain sensor information such as humidity, temperature and perhaps status and control of X10 events.
A second local server would periodically dialin to the remote server and transfer data to a local database. This in turn would be accessed by zm in the case of video events and a different application for the sensor information. So my question now is how difficult would it be to develop a program to mirror the two databases? Are there apps out in the Linux world to do this? At first glance this doesn't look to difficult of a task, but then again I been there and done that and then reality sets it.
Can anyone offer any suggestions, whether this would be a major undertaking or maybe just a gentle "are you crazy?" would be greatly appreciated.
Cheers
Mark
After a little fiddling and and some good help on this forum, I now have zm up and working fine. Great program and great work Philip.
This might be a little outside the scope of this forum, but here goes.
My application calls for a server to be located remotely which can only be accessed by modem. There will be toll charges for each call, so I do not want to spend a whole lot of time checking and reviewing events. Also I want to be able to maintian a second database that will contain sensor information such as humidity, temperature and perhaps status and control of X10 events.
A second local server would periodically dialin to the remote server and transfer data to a local database. This in turn would be accessed by zm in the case of video events and a different application for the sensor information. So my question now is how difficult would it be to develop a program to mirror the two databases? Are there apps out in the Linux world to do this? At first glance this doesn't look to difficult of a task, but then again I been there and done that and then reality sets it.
Can anyone offer any suggestions, whether this would be a major undertaking or maybe just a gentle "are you crazy?" would be greatly appreciated.
Cheers
Mark