2 Replies Latest reply on Feb 11, 2020 3:58 AM by ORASCN

    Goldengate architecture analysis

    Robeen

      Hi,

       

         Goldengate scenario explained below . It should be Bi-directional replication ( active -passive)

       

      1) Eight 11.2.0.4 database (in IBM-AIX)  should replicate to Dubai site  ( 11.2.0.4.0 -RAC - Oracle SPARC)

       

      2) Five 12.2.0.1.0 database (in IBM-AIX)  should replicate to Dubai site  ( 12.2.0.1.0 -RAC - Oracle SPARC)

       

      3) One 12.1.0.2.0 database (in IBM-AIX)  should replicate to Dubai site  ( 12.1.0.2.0 -RAC - Oracle SPARC)

       

      3) One 12.2.0.1.0 database (RHEL 7)  should replicate to Dubai site  ( 12.2.0.1.0 -RAC - Oracle SPARC)

       

      4) Four 11.2.0.4.0 database (RHEL 7)  should replicate to Dubai site  ( 11.2.0.4.0 -RAC - Oracle SPARC)

       

      Can you please advise how to proceed with OGG? What OGG technique should I use?

       

      In what way can I use the microservices API?

       

      Regards,

       

      Joe

        • 1. Re: Goldengate architecture analysis
          Robeen

          GG cannot be installed in each servers to replicate... managing is very tough. Is there a tool to use? Is goldengate hub ok? It seems to work in a classic way. We are expecting html screen to manage all. Goldengate microservices gives html option.. but client didn't mention it works with goldengate hub.

          • 2. Re: Goldengate architecture analysis
            ORASCN

            Hi Joe,

             

            Oracle GoldenGate Microservices Architecture (OGG MA) is mainly designed for the HUB model. Yes, you can go with OGG MA and build a HUB type of model. Create multiple deployments for each databases and create remote capture/apply processes.

             

            In this scenario, you will have a separate server with OGG MA installed and replicat data across your different sites. There will no OGG running in the servers where your databases are running.

             

            OGG 19c MA doesn't depend on the endian formats. This is a new feature of OGG 19c.

             

            Regards,

            Veera