How can I integrate data on regular bases between 2 different MySQL Servers?
I currently have 2 MySQL Serve running on a different machines. Once of
them is a staging environment (A) and another is a production environment
(B). What I need to do is to take data from (A) and update/insert into B
based on the conditions. If MySQL had Linked option then I can simply
create a stored procedure that does the work for me and that would solve
my whole problem. Unfortunately a great product like MySQL does not have
this necessary future.
But since I can't write a procedure to do that what application I can use
that will do the integration for me? note this integration will need to be
automatic so it can be done daily and sometimes hourly.
My question is there an integration application out there that will
integrate data from on MySQL Server to another automatically?
Thanks
No comments:
Post a Comment