{"id":52864,"date":"2018-08-09T09:00:41","date_gmt":"2018-08-09T08:00:41","guid":{"rendered":"http:\/\/content.n4stack.io\/?p=52864"},"modified":"2018-08-21T11:19:07","modified_gmt":"2018-08-21T10:19:07","slug":"oracle-data-amazon-rds-goldengate","status":"publish","type":"post","link":"http:\/\/content.n4stack.io\/2018\/08\/09\/oracle-data-amazon-rds-goldengate\/","title":{"rendered":"Migrating Oracle Data to Amazon RDS with GoldenGate"},"content":{"rendered":"
[et_pb_section bb_built=”1″ _builder_version=”3.0.47″][et_pb_row _builder_version=”3.0.48″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″][et_pb_text _builder_version=”3.9″]<\/p>\n
The migration of databases to cloud has increased rapidly in recent years and it\u2019s not hard to see why. Moving your capital expenditure (CapEx) costs into operational expenditure (OpEx) budgets offers greater flexibility and lower risk but there\u2019s still a major blocker in the way \u2013 how do<\/em> you get your Oracle data in there without major downtime? We\u2019ve got the answer \u2013 Oracle\u2019s GoldenGate<\/a>.<\/p>\n <\/p>\n Did you just spit your coffee out? I know, I know\u2026 GoldenGate (GG) is heralded as eye-wateringly expensive with processor costs equal to that of Enterprise Edition Oracle DB! To make things worse you\u2019re likely to only need a license for a short period of time when doing a cloud migration, making the CapEx a double hit. If you listen carefully you can hear the thud of GoldenGate hitting the cutting room floor. But let me ask you this, what if there was a way to use Oracle’s solution using an OpEx model instead? Well, we\u2019ve done just that! Let me tell you how\u2026<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”27px|0px|4px|0px|false|false” _builder_version=”3.0.48″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”1_2″][et_pb_text _builder_version=”3.9″ header_text_color=”#e05206″]<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″][et_pb_text _builder_version=”3.9″ header_text_color=”#e05206″]<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”0|0px|0|0px|false|false” _builder_version=”3.0.48″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”1_2″][et_pb_divider color=”#e05206″ height=”2px” _builder_version=”3.9″ background_color=”#e05206″ module_alignment=”center” \/][\/et_pb_column][et_pb_column type=”1_2″][et_pb_divider color=”#e05206″ height=”2px” _builder_version=”3.9″ background_color=”#e05206″ module_alignment=”center” \/][\/et_pb_column][\/et_pb_row][et_pb_row custom_padding=”14px|0px|21px|0px|false|false” _builder_version=”3.0.48″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”1_2″][et_pb_text _builder_version=”3.9″ header_text_color=”#e05206″]<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”1_2″][et_pb_text _builder_version=”3.9″ header_text_color=”#e05206″]<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.0.48″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0|0px|27px|0px|false|false”][et_pb_column type=”4_4″][et_pb_text _builder_version=”3.11″]<\/p>\n The customer agreed it was the best way forward, and this is when we had our epiphany. RDS environments are heavily locked down by Amazon so we were restricted on what we could deploy, meaning we needed to install the GoldenGate Manager Hub remotely \u2013 not uncommon but an interesting project nonetheless. The steps we took were:<\/p>\n Step 1:<\/strong> Create an EC2 instance with security VPC rules to control access<\/p>\n S<\/strong>tep 2:<\/strong> Create an S3 bucket with Oracle and GoldenGate binaries<\/p>\n Step 3:<\/strong> Deploy a second RDS instance as the target<\/p>\n S<\/strong>tep 4:<\/strong> Set up terraforming scripts to install GoldenGate on the EC2 instance, set up the GG Hub, and initialise the GoldenGate extract and replicate processes including deploying the GG users etc\u2026<\/p>\n Step 5:<\/strong> Initiate monitoring on the GG services to offer the service wrapper needed It ended up a bit like this: What we ended up with is a fully repeatable, secure and efficient method of setting up a GoldenGate extract which we could replicate from anywhere to anywhere via an EC2 hub. So, we can re-deploy this for anyone and, perhaps most importantly, we can REUSE the GG Hub.<\/p>\n So, what\u2019s the epiphany? Well, GoldenGate licensing, just like the Oracle licenses, are not restricted to a specific database. You can shut down one database and start another under the same license, or you can run multiple instances on the same host without invalidating any of your contract. If someone only needs a GoldenGate license for a short time (e.g. to migrate to cloud) then a remote hub can be set up, the source database linked to it and a target built before we define the replication rules, let the migration run (allowing for dual running and a full testing suite to be deployed to ensure everything is perfect), and, finally, terminate the links.<\/p>\n What does all this mean? It means you don\u2019t need a GoldenGate license (as you would use the hub license and reusable processor licenses). This turns the high CapEx costs into more manageable OpEx ones, letting someone else take the risk of the licensing costs while you get a fantastic end result!<\/p>\n Interested to see for yourself how N4Stack can cut costs and mitigate risk by utilising GoldenGate during your cloud migration? Give me a shout!<\/a><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.0.48″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″][et_pb_divider color=”#e05206″ height=”2px” _builder_version=”3.9″ background_color=”#e05206″ module_alignment=”center” \/][et_pb_team_member name=”Kate Gawron” position=”Database Consultant” image_url=”http:\/\/content.n4stack.io\/wp-content\/uploads\/2018\/07\/Kate-Gawron-2.png” _builder_version=”3.11″ saved_tabs=”all” global_module=”53225″]<\/p>\n Kate spends most of her time working with Oracle databases and products, but dabbles in MySQL and SQL Server when the need arises.<\/p>\n She enjoys researching and testing new solutions to see how they could benefit our projects, often testing to destruction!<\/p>\n To find out more about Kate click here!<\/a><\/p>\n [\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" The migration of databases to cloud has increased rapidly in recent years and it\u2019s not hard to see why. Moving your capital expenditure (CapEx) costs into operational expenditure (OpEx) budgets offers greater flexibility and lower risk but there\u2019s still a major blocker in the way \u2013 how do you get your Oracle data in there […]<\/p>\n","protected":false},"author":5,"featured_media":53234,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":" The migration of databases to cloud has increased rapidly in recent years and it\u2019s not hard to see why. Moving your capital expenditure (CapEx) costs into operational expenditure (OpEx) budgets offers greater flexibility and lower risk but there\u2019s still a major blocker in the way \u2013 how do<\/em> you get your data in there without major downtime? We\u2019ve got the answer \u2013 Oracle\u2019s GoldenGate<\/a>.<\/p> <\/p> Did you just spit your coffee out? I know, I know\u2026 GoldenGate is heralded as eye-wateringly expensive with processor costs equal to that of Enterprise Edition Oracle DB! To make things worse you\u2019re likely to only need a license for a short period of time when doing a cloud migration, making the CapEx a double hit. If you listen carefully you can hear the thud of GoldenGate hitting the cutting room floor. But let me ask you this, what if there was a way to use GoldenGate using an OpEx model instead? Well, we\u2019ve done just that! Let me tell you how\u2026<\/p> <\/p> \u00a0<\/p> The customer agreed it was the best way forward, and this is when we had our epiphany. RDS environments are heavily locked down by Amazon so we were restricted on what we could deploy, meaning we needed to install the GoldenGate Manager Hub remotely \u2013 not uncommon but an interesting project nonetheless. The steps we took were:<\/p> Step 1:<\/strong> Create an EC2 instance with security VPC rules to control access<\/p> Step 2:<\/strong> Create an S3 bucket with Oracle and GoldenGate binaries<\/p> Step 3:<\/strong> Deploy a second RDS instance as the target<\/p> Step 4:<\/strong> Set up terraforming scripts to install GoldenGate on the EC2 instance, set up the GG Hub, and initialise the GoldenGate extract and replicate processes including deploying the GG users etc\u2026<\/p> Step 5:<\/strong> Initiate monitoring on the GG services to offer the service wrapper needed<\/p> It ended up a bit like this:<\/p> <\/p> What we ended up with is a fully repeatable, secure and efficient method of setting up a GoldenGate extract which we could replicate from anywhere to anywhere via an EC2 hub. So, we can re-deploy this for anyone and, perhaps most importantly, we can REUSE the GoldenGate Hub.<\/p> So, what\u2019s the epiphany? Well, GoldenGate licensing, just like the Oracle licenses, are not restricted to a specific database. You can shut down one database and start another under the same license, or you can run multiple instances on the same host without invalidating any of your contract. If someone only needs a GoldenGate license for a short time (e.g. to migrate to cloud) then a remote hub can be set up, the source database linked to it and a target built before we define the replication rules, let the migration run (allowing for dual running and a full testing suite to be deployed to ensure everything is perfect), and, finally, terminate the links.<\/p> What does all this mean? It means you don\u2019t need a GoldenGate license (as you would use the hub license and reusable processor licenses). This turns the high CapEx costs into more manageable OpEx ones, letting someone else take the risk of the licensing costs while you get a fantastic end result!<\/p>The customer wanted to migrate to cloud but:<\/h4>\n
The methods we considered were:<\/h4>\n
\n
\n