Could you use transaction logging & process the log file as soon as it
fills? You'd have to make very small log files in order to keep latency at a
minimum, but even then you might be looking at lag times on the order of 1
or 2 dozen minutes. Perhaps throttle that a bit by artificially filling the
log by writing a lot of zeroes to a file (created for that purpose &
logged) after x seconds, then ignore those zeroes at conversion...
From: "Kevin King" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: <[email protected]>
Subject: [U2] Replication Between Unidata and MySQL
Date: Fri, 28 Jul 2006 14:30:56 -0700
I have been assigned a unique project and have been given some pretty
stringent requirements. Basically the project involves a subset
replication of a Unidata database into MySQL. As certain records
change in Unidata (6.0) that record is to be flushed to a separate
server running MySQL. Off-hours batch updates are not an option at
this point, inconsistency between systems is intended to be momentary
at best.
I can handle the conversion and flattening of the data; that's
certainly no deal breaker but keeping the MySQL server updated on a
near-realtime basis has me a bit freaked out. Has anyone handled this
kind of thing? Is there a connector to MySQL that can be addressed
from within Unidata? I could certainly do something with ODBC I would
figure but with Unidata running on AIX I'm not sure how exactly I'd
move the data to the MySQL server (running on a Win box) directly.
Other options off the top of my head include
* ...using a http server to update the MySQL instance and using the
callHttp interface or...
* ...writing a TCP listener to do the updating of the MySQL instance
and using Unidata sockets to move the data.
However, these will necessitate a bit of code that I'd prefer to
avoid. What would you do?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com <http://www.precisonline.com/>
** Check out scheduled Connect! training courses at
<http://www.precisonline.com/train.html>
http://www.PrecisOnline.com/train.html.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
