Desired inconsistency is a second or less, the time it takes to push bits on a wire. Interesting ideas, of course, but not likely.
-Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, July 28, 2006 3:09 PM To: [email protected] Subject: RE: [U2] Replication Between Unidata and MySQL 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
