Can I replicate a replicated database?

[desmondchew]

I have setup a task to replicate Source Oracle DB 11g to Target MySQL 8.0.31 on premise database. It's working well. Now the application team wants to perform testing  on the target database and they require a clone.

Can I setup a new task to replicate the "Target MySQL" as source DB and another target MySQL as endpoint?

[KellyHobson]

Hey @desmondchew ,

Thanks for reaching out! 

Yes, you can do this but you need to make sure your Replicate license includes MySQL as a source endpoint.  The list of supported endpoints is at the top of reptask log files. 

You will need to follow the steps in the User Guide to ensure a successful set up as MySQL as a source. 

Additionally, make sure your secondary/clone mySQL target is pointing to a different schema so avoid overwriting the original. 

Let us know if you have any other questions.

Best,

Kelly 

[Heinvandenheuvel]

Yes. You can Replicate a Replicatated DB.

It had better be safe because Replicate only uses standard SQL to keep a target in sync.

But just because you can doesn't mean you should. It seems to me that it would be more realistic to for that target db application team to just give them their own close straight from the source. That way they get exposed more closely to what is happening on the main target. Ofcourse this would increase the overhead on the source instead of target. So you have to consider that.

Hth, Hein 

[Michael_Litz]

I like this idea since it would be closer to connecting to the source directl.

One way to mitigate the extra overhead on Oracle source would be to set up Logstream configuration and have the two targets be the children of the source (parent) Oracle - that way only one task is connected to the source - not two.

Thanks,
Michael