GoldenGate Hub Pattern for replication from Oracle to MySQL2019 Community Moderator ElectionHow do I quickly rename a MySQL database (change schema name)?Can I concatenate multiple MySQL rows into one field?How to output MySQL query results in CSV format?How do I connect to a MySQL Database in Python?How do I specify unique constraint for multiple columns in MySQL?MySQL: Large VARCHAR vs. TEXT?Duplicating a MySQL table, indices, and dataInsert into a MySQL table or update if existsHow to reset AUTO_INCREMENT in MySQL?How to import an SQL file using the command line in MySQL?
Do I need life insurance if I can cover my own funeral costs?
Why are there 40 737 Max planes in flight when they have been grounded as not airworthy?
Why did it take so long to abandon sail after steamships were demonstrated?
My adviser wants to be the first author
Does splitting a potentially monolithic application into several smaller ones help prevent bugs?
Rules about breaking the rules. How do I do it well?
Ban on all campaign finance?
Making a sword in the stone, in a medieval world without magic
Brexit - No Deal Rejection
Good allowance savings plan?
Science-fiction short story where space navy wanted hospital ships and settlers had guns mounted everywhere
Using "wallow" verb with object
Validating user input
Russian cases: A few examples, I'm really confused
Official degrees of earth’s rotation per day
Possible Leak In Concrete
Where is the 1/8 CR apprentice in Volo's Guide to Monsters?
Humanity loses the vast majority of its technology, information, and population in the year 2122. How long does it take to rebuild itself?
Pinhole Camera with Instant Film
Why are the outputs of printf and std::cout different
Why using two cd commands in bash script does not execute the second command
Can the damage from a Talisman of Pure Good (or Ultimate Evil) be non-lethal?
Instead of Universal Basic Income, why not Universal Basic NEEDS?
Replacing Windows 7 security updates with anti-virus?
GoldenGate Hub Pattern for replication from Oracle to MySQL
2019 Community Moderator ElectionHow do I quickly rename a MySQL database (change schema name)?Can I concatenate multiple MySQL rows into one field?How to output MySQL query results in CSV format?How do I connect to a MySQL Database in Python?How do I specify unique constraint for multiple columns in MySQL?MySQL: Large VARCHAR vs. TEXT?Duplicating a MySQL table, indices, and dataInsert into a MySQL table or update if existsHow to reset AUTO_INCREMENT in MySQL?How to import an SQL file using the command line in MySQL?
I have no experience with Oracle GoldenGate, so any information would be appreciated.
I found this old blog post about remote capture/delivery (GoldenGate Hub pattern) of Oracle GoldenGate for MySQL, but I am assuming this is about homogeneous migration, MySQL to MySQL.
Am I correct or is it also possible between heterogeneous migration, e.g, from on-premises Oracle to Aurora MySQL?
Thank you for your time in advance!
mysql oracle database-migration
asked Mar 7 at 12:11
tsz662tsz662
199
add a comment |
I have no experience with Oracle GoldenGate, so any information would be appreciated.
I found this old blog post about remote capture/delivery (GoldenGate Hub pattern) of Oracle GoldenGate for MySQL, but I am assuming this is about homogeneous migration, MySQL to MySQL.
Am I correct or is it also possible between heterogeneous migration, e.g, from on-premises Oracle to Aurora MySQL?
Thank you for your time in advance!
mysql oracle database-migration
asked Mar 7 at 12:11
tsz662tsz662
199
add a comment |
I have no experience with Oracle GoldenGate, so any information would be appreciated.
I found this old blog post about remote capture/delivery (GoldenGate Hub pattern) of Oracle GoldenGate for MySQL, but I am assuming this is about homogeneous migration, MySQL to MySQL.
Am I correct or is it also possible between heterogeneous migration, e.g, from on-premises Oracle to Aurora MySQL?
Thank you for your time in advance!
mysql oracle database-migration
asked Mar 7 at 12:11
tsz662tsz662
199
I have no experience with Oracle GoldenGate, so any information would be appreciated.
I found this old blog post about remote capture/delivery (GoldenGate Hub pattern) of Oracle GoldenGate for MySQL, but I am assuming this is about homogeneous migration, MySQL to MySQL.
Am I correct or is it also possible between heterogeneous migration, e.g, from on-premises Oracle to Aurora MySQL?
Thank you for your time in advance!
mysql oracle database-migration
mysql oracle database-migration
asked Mar 7 at 12:11
tsz662tsz662
199
asked Mar 7 at 12:11
tsz662tsz662
199
asked Mar 7 at 12:11
tsz662tsz662
199
asked Mar 7 at 12:11
tsz662tsz662
199
asked Mar 7 at 12:11
tsz662tsz662
199
199
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Yes, heterogeneous migration is possible. Not sure about Aurora MySQL specifically (I would imagine so as it is a MySQL database,) but GoldenGate does support heterogeneous configurations. From Oracle:
You can use the following supported heterogeneous databases with
Oracle GoldenGate.
DB2 LUW
DB2 for i
DB2 for z/OS
MySQL
SQL Server
Teradata
More information can be found here: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/12.3-what-is-oracle-goldengate-heterogeneous-databases.htm#GGHDB-GUID-08EAC588-F76C-4E37-BEBA-0DC57B98CA46
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
Thank you for the quick reply! Please allow me to dig this deeper. I've read the document but it doesn't really say which version of GoldenGate should be installed on where, if I'm not missing anything.
– tsz662
Mar 8 at 2:47
This document says " the GoldenGate application must be installed on both the source and target systems". Does this mean A) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and the target, B) Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the source and the target, or C) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the target?
– tsz662
Mar 8 at 2:58
1
I would wager that it means C), but you should really contact Oracle or an Oracle certified vendor to get the ball rolling on your technical requirements. While it's absolutely possible to set something like this up without a support contract, it will be in your best interest to have one if you are working with GoldenGate in any major capacity, especially if production systems are in the equation.
– cdb_dba
Mar 11 at 14:31
Thank you again for your suggestion. Personally, I too think C) is the bet but we will contact an Oracle support to clear things out. I will post their answer when I get it, for the sake of anyone who needs it.
– tsz662
Mar 12 at 0:59
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55043495%2fgoldengate-hub-pattern-for-replication-from-oracle-to-mysql%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Yes, heterogeneous migration is possible. Not sure about Aurora MySQL specifically (I would imagine so as it is a MySQL database,) but GoldenGate does support heterogeneous configurations. From Oracle:
You can use the following supported heterogeneous databases with
Oracle GoldenGate.
DB2 LUW
DB2 for i
DB2 for z/OS
MySQL
SQL Server
Teradata
More information can be found here: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/12.3-what-is-oracle-goldengate-heterogeneous-databases.htm#GGHDB-GUID-08EAC588-F76C-4E37-BEBA-0DC57B98CA46
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
Thank you for the quick reply! Please allow me to dig this deeper. I've read the document but it doesn't really say which version of GoldenGate should be installed on where, if I'm not missing anything.
– tsz662
Mar 8 at 2:47
This document says " the GoldenGate application must be installed on both the source and target systems". Does this mean A) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and the target, B) Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the source and the target, or C) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the target?
– tsz662
Mar 8 at 2:58
1
I would wager that it means C), but you should really contact Oracle or an Oracle certified vendor to get the ball rolling on your technical requirements. While it's absolutely possible to set something like this up without a support contract, it will be in your best interest to have one if you are working with GoldenGate in any major capacity, especially if production systems are in the equation.
– cdb_dba
Mar 11 at 14:31
Thank you again for your suggestion. Personally, I too think C) is the bet but we will contact an Oracle support to clear things out. I will post their answer when I get it, for the sake of anyone who needs it.
– tsz662
Mar 12 at 0:59
add a comment |
Yes, heterogeneous migration is possible. Not sure about Aurora MySQL specifically (I would imagine so as it is a MySQL database,) but GoldenGate does support heterogeneous configurations. From Oracle:
You can use the following supported heterogeneous databases with
Oracle GoldenGate.
DB2 LUW
DB2 for i
DB2 for z/OS
MySQL
SQL Server
Teradata
More information can be found here: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/12.3-what-is-oracle-goldengate-heterogeneous-databases.htm#GGHDB-GUID-08EAC588-F76C-4E37-BEBA-0DC57B98CA46
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
Thank you for the quick reply! Please allow me to dig this deeper. I've read the document but it doesn't really say which version of GoldenGate should be installed on where, if I'm not missing anything.
– tsz662
Mar 8 at 2:47
This document says " the GoldenGate application must be installed on both the source and target systems". Does this mean A) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and the target, B) Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the source and the target, or C) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the target?
– tsz662
Mar 8 at 2:58
1
I would wager that it means C), but you should really contact Oracle or an Oracle certified vendor to get the ball rolling on your technical requirements. While it's absolutely possible to set something like this up without a support contract, it will be in your best interest to have one if you are working with GoldenGate in any major capacity, especially if production systems are in the equation.
– cdb_dba
Mar 11 at 14:31
Thank you again for your suggestion. Personally, I too think C) is the bet but we will contact an Oracle support to clear things out. I will post their answer when I get it, for the sake of anyone who needs it.
– tsz662
Mar 12 at 0:59
add a comment |
Yes, heterogeneous migration is possible. Not sure about Aurora MySQL specifically (I would imagine so as it is a MySQL database,) but GoldenGate does support heterogeneous configurations. From Oracle:
You can use the following supported heterogeneous databases with
Oracle GoldenGate.
DB2 LUW
DB2 for i
DB2 for z/OS
MySQL
SQL Server
Teradata
More information can be found here: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/12.3-what-is-oracle-goldengate-heterogeneous-databases.htm#GGHDB-GUID-08EAC588-F76C-4E37-BEBA-0DC57B98CA46
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
Yes, heterogeneous migration is possible. Not sure about Aurora MySQL specifically (I would imagine so as it is a MySQL database,) but GoldenGate does support heterogeneous configurations. From Oracle:
You can use the following supported heterogeneous databases with
Oracle GoldenGate.
DB2 LUW
DB2 for i
DB2 for z/OS
MySQL
SQL Server
Teradata
More information can be found here: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/12.3-what-is-oracle-goldengate-heterogeneous-databases.htm#GGHDB-GUID-08EAC588-F76C-4E37-BEBA-0DC57B98CA46
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
answered Mar 7 at 15:42
cdb_dbacdb_dba
587817
587817
Thank you for the quick reply! Please allow me to dig this deeper. I've read the document but it doesn't really say which version of GoldenGate should be installed on where, if I'm not missing anything.
– tsz662
Mar 8 at 2:47
This document says " the GoldenGate application must be installed on both the source and target systems". Does this mean A) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and the target, B) Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the source and the target, or C) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the target?
– tsz662
Mar 8 at 2:58
1
I would wager that it means C), but you should really contact Oracle or an Oracle certified vendor to get the ball rolling on your technical requirements. While it's absolutely possible to set something like this up without a support contract, it will be in your best interest to have one if you are working with GoldenGate in any major capacity, especially if production systems are in the equation.
– cdb_dba
Mar 11 at 14:31
Thank you again for your suggestion. Personally, I too think C) is the bet but we will contact an Oracle support to clear things out. I will post their answer when I get it, for the sake of anyone who needs it.
– tsz662
Mar 12 at 0:59
add a comment |
Thank you for the quick reply! Please allow me to dig this deeper. I've read the document but it doesn't really say which version of GoldenGate should be installed on where, if I'm not missing anything.
– tsz662
Mar 8 at 2:47
This document says " the GoldenGate application must be installed on both the source and target systems". Does this mean A) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and the target, B) Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the source and the target, or C) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the target?
– tsz662
Mar 8 at 2:58
1
I would wager that it means C), but you should really contact Oracle or an Oracle certified vendor to get the ball rolling on your technical requirements. While it's absolutely possible to set something like this up without a support contract, it will be in your best interest to have one if you are working with GoldenGate in any major capacity, especially if production systems are in the equation.
– cdb_dba
Mar 11 at 14:31
Thank you again for your suggestion. Personally, I too think C) is the bet but we will contact an Oracle support to clear things out. I will post their answer when I get it, for the sake of anyone who needs it.
– tsz662
Mar 12 at 0:59
Thank you for the quick reply! Please allow me to dig this deeper. I've read the document but it doesn't really say which version of GoldenGate should be installed on where, if I'm not missing anything.
– tsz662
Mar 8 at 2:47
Thank you for the quick reply! Please allow me to dig this deeper. I've read the document but it doesn't really say which version of GoldenGate should be installed on where, if I'm not missing anything.
– tsz662
Mar 8 at 2:47
This document says " the GoldenGate application must be installed on both the source and target systems". Does this mean A) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and the target, B) Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the source and the target, or C) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the target?
– tsz662
Mar 8 at 2:58
This document says " the GoldenGate application must be installed on both the source and target systems". Does this mean A) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and the target, B) Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the source and the target, or C) Oracle GoldenGate 18.1.0.0.0 for Oracle on Linux x86-64 on the source and Oracle GoldenGate 18.1.0.0.0 for MySQL on Linux x86-64 (64 MB) on the target?
– tsz662
Mar 8 at 2:58
1
1
I would wager that it means C), but you should really contact Oracle or an Oracle certified vendor to get the ball rolling on your technical requirements. While it's absolutely possible to set something like this up without a support contract, it will be in your best interest to have one if you are working with GoldenGate in any major capacity, especially if production systems are in the equation.
– cdb_dba
Mar 11 at 14:31
I would wager that it means C), but you should really contact Oracle or an Oracle certified vendor to get the ball rolling on your technical requirements. While it's absolutely possible to set something like this up without a support contract, it will be in your best interest to have one if you are working with GoldenGate in any major capacity, especially if production systems are in the equation.
– cdb_dba
Mar 11 at 14:31
Thank you again for your suggestion. Personally, I too think C) is the bet but we will contact an Oracle support to clear things out. I will post their answer when I get it, for the sake of anyone who needs it.
– tsz662
Mar 12 at 0:59
Thank you again for your suggestion. Personally, I too think C) is the bet but we will contact an Oracle support to clear things out. I will post their answer when I get it, for the sake of anyone who needs it.
– tsz662
Mar 12 at 0:59
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55043495%2fgoldengate-hub-pattern-for-replication-from-oracle-to-mysql%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
