Re: [U2] Using UNIVERSE Triggers for MYSQL?
I have used triggers to write the data I want to transfer to a queue file where I have another process that transfers the data in the queue to the remote database (Microsoft SQL). I designed the trigger that way because if for whatever reason the remote database becomes unavailable (and that does happen), it only impacts the process that is doing the transfer rather than causing my trigger to fail. Obviously the process that does the transfer has error handling to deal with failed transfers. Having a separate process to do the transfer allows the trigger to remain very small and fast with no noticeable impact to the end-user - and most important, no reason for the trigger to fail. We never use CLEARFILE on our main database files - so that is not an issue for us. Barry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ARAMAIES BAGHDASRAIAN Sent: Tuesday, March 23, 2010 6:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] Using UNIVERSE Triggers for MYSQL? Good day, I would like to learn on Universe Triggers for MYSQL. using Universe 10.3 . I have read the materials and there were issues on speed, dailiung to update if trigger fails, or Clearfile where the trigger does not get activated. Please let me know if you have used the Universe triggers in production environment to update MYSQL tables? Best regards, Ara ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Using UNIVERSE Triggers for MYSQL?
Good day, I would like to learn on Universe Triggers for MYSQL. using Universe 10.3 . I have read the materials and there were issues on speed, dailiung to update if trigger fails, or Clearfile where the trigger does not get activated. Please let me know if you have used the Universe triggers in production environment to update MYSQL tables? Best regards, Ara ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using UNIVERSE Triggers for MYSQL?
Hi Ara, We have used UniVerse triggers to replicate UniVerse tables to Microsoft SQL Server, MySQL, and Oracle. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ARAMAIES BAGHDASRAIAN Sent: Tuesday, March 23, 2010 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] Using UNIVERSE Triggers for MYSQL? Good day, I would like to learn on Universe Triggers for MYSQL. using Universe 10.3 . I have read the materials and there were issues on speed, dailiung to update if trigger fails, or Clearfile where the trigger does not get activated. Please let me know if you have used the Universe triggers in production environment to update MYSQL tables? Best regards, Ara ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users