1 / 13

Replication Service Evolution

Join us for the Data Replication Workshop held on June 3, 2014, to explore the transition from Oracle Streams to GoldenGate 12c. We'll cover the impactful changes necessary for effective data replication, including zero-downtime upgrades, DDL replication, and the centralization of GoldenGate installation. By aligning with Oracle recommendations and industry trends, businesses can optimize their data integration with non-Oracle databases. Participate in hands-on testing and discussions on monitoring and configuration strategies for seamless migration to GoldenGate.

conner
Download Presentation

Replication Service Evolution

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Replication Service Evolution Data replication workshop 3.06.2014

  2. Outline • WWHWW

  3. What we would like to change? Data replication workshop 3.06.2014 • Streams => GoldenGate12c • Conditions data between online-offline • Conditions data between offline-T1s • … • DataGuard services stay unchanged

  4. Why to change now? Data replication workshop 3.06.2014 • LS1 is a good occasion to introduce changes • Streams are in maintenance mode • still supported • no enhancements and no new database features will be adopted • Lets follow new trends and Oracle recommendations • Expertise in GoldenGate opens new possibilities • zero-downtime migrations/upgrades • enables data integration with other non-Oracle database

  5. Are our workloads ready for GoldenGate? Data replication workshop 3.06.2014 • (Native) DDL replication (>=11.2.0.4) • Table creation, granting of user privileges • Data filtering on schema and table name level • Remote configuration and management of replication processes • Proactive and reactive monitoring • (See Lorena’s and Maciej presentation tomorrow) • DDL handler at target database • Not really needed for conditions data • Will be available at the end of this year

  6. Are we ready for GoldenGate Data replication workshop 3.06.2014 • Functional test • Performance test • Long distance tests (with T1s) • Long term stability tests • Tests with production data (ATLASCond) • Optimize networking parameters • Long term test with production data • Local and long distance

  7. How? Data replication workshop 3.06.2014 • Central GoldenGate installation • All GoldenGate software installed on a two-node cluster • Processes operate on databases remotely • All binaries & configuration stored on NAS volumes • All monitoring agents installed on the cluster • Cluster in master-slave configuration • With automatic failover

  8. Central GoldenGate installation Replica databases • GG processes • monitoring agents Source databases WAN A’ Central GG servers A A” B B’ C NAS storage with config and trail files C’ Data replication workshop 3.06.2014

  9. Central GoldenGate installation Data replication workshop 3.06.2014 • Easier deployment and management • Everything in one place => easy hardware migration • Installation of GG software on each db server is not needed • Additional integration with RAC is not need (except central service) • No need of running datapump process (from GG stack) • Single trail files (local) copy =>less storage needed • Improved security • No need of additional port opening on replica sites • Simplified deployment of GG monitoring • enables using of Oracle EM plugin to monitor entire environment • Better performanceover WAN (T0->T1s) measured

  10. How on the D-Day? Data replication workshop 3.06.2014 0) ConfigureGoldenGate processes 1) StartGoldenGate extraction processes 2) Stop Streams processes 3) StartGoldenGatereplicat process *) Keep Streams configuration switched off Impact: less than 1 hour of downtime

  11. Who does what? Data replication workshop 3.06.2014 • Experiment • Gives a green light • Support the testing (if possible) • T0 • Central installation of GG cluster • Central installation of monitoring • Deploy of initial configuration • Long term: administration of online-offline replication • Long term: co-administration of online-T1s replication • T1s • Continue long distance tests • Upgrade to 11.2.0.4 (almost done) • Re-instantiation of data (if needed) • Update firewall port configuration • Register on GG monitoring tool • Long term: co-administer of offline-T1s replication

  12. When to change? (proposal) Data replication workshop 3.06.2014 Long term tests with production data (T0->T1s) June ATONR & ATLR compatibility update max: 1stweek of July GoldenGate for online-offline (condDB) week of 21st of July GoldenGate for offline-T1s 1st week of September

  13. THANK YOU! Data replication workshop 3.06.2014

More Related