Forum Stats

  • 3,876,212 Users
  • 2,267,082 Discussions
  • 7,912,473 Comments

Discussions

GoldenGate Component Architecture Question

Art T
Art T Member Posts: 15
edited Mar 1, 2011 12:21AM in GoldenGate
Reading about GG architecture I only see discussion of components that reside either on the source or the target systems.
Which GG components reside in the FMW?

Thanks
-Art

Best Answer

  • stevencallan
    stevencallan Member Posts: 3,459
    Answer ✓
    There is no benefit to running a GoldenGate instance on a remote server. By doing so, you've introduced a potential point of failure (network transport to the remote server). If you lose connectivity, where do the trails go? The only possible benefits would be related to constrained memory on the source database server, where a maxed out instance using 300 processes takes up around 15GB of memory, and possibly, a lack of disk space for trails. Although possible, it isn't likely when you consider how much it costs to license GG. If you can afford to license GG, being short on RAM or disk space is probably not on your list of things to worry about.

Answers

  • stevencallan
    stevencallan Member Posts: 3,459
    GoldenGate does not depend on Fusion Middleware; hence, there is no mention or need of a MW home. GG reads native transaction logs, has nothing whatsoever to do with any middleware components. If you read the architecture as you say, then what about using GoldenGate in a SQL Server environment - where middleware doesn't exist to begin with?

    That's not to say you cannot install GoldenGate on a FWM server and run an extract there, connecting to the source via Net Services. In that scenario, GoldenGate still couldn't care less about Fusion Middleware. It would merely be running on the same server as other Oracle products/components, but would independent of them.
    stevencallan
  • Art T
    Art T Member Posts: 15
    Thanks.
    So, if I install GG on FMW, which components will run there? Is there any benefit to it?
  • stevencallan
    stevencallan Member Posts: 3,459
    Answer ✓
    There is no benefit to running a GoldenGate instance on a remote server. By doing so, you've introduced a potential point of failure (network transport to the remote server). If you lose connectivity, where do the trails go? The only possible benefits would be related to constrained memory on the source database server, where a maxed out instance using 300 processes takes up around 15GB of memory, and possibly, a lack of disk space for trails. Although possible, it isn't likely when you consider how much it costs to license GG. If you can afford to license GG, being short on RAM or disk space is probably not on your list of things to worry about.
This discussion has been closed.