- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
SMR replication using xDB
We migrating data from Oracle to EPAS using xDB snapshot only replicaiton.
Data is being migrated, but the migration speed is not upto the mask as per our requiremet (Need to migrate 2TB data in 2Hrs). Please find below configuration being used for xDB:
cpBatchsize=1024MB
Javaheapsize=30GB
Are thare any parameters we can look for to increase data transfer speed?
Archived Discussions
Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SMR replication using xDB
Are you using 6.2 xDB version?
Going through your last few queries, We are guessing that it must be xDB 6.2.
Please confirm.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SMR replication using xDB
Considering xDB 6.2, please go through the below sections from the xDB doc which will elaborate the how to gain the performance while xDB snap and replication.
2.4.4 Performance Considerations
5.8 Optimizing Performance
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SMR replication using xDB
@Ranjan Thanks for your response.
yes we are using xDB 6.2.
I've gone through performance considerations, unfortunately we can't make use of synchronization in our enviornment as we don't have primary keys on all the tables, and creating a primary key on existing tables is not permited due to business restrictions.
As mentioned in initial post we are migrating 2TB data, as per default xDB default setting it may take few days to complete.
I'm looking for any parameters which we can tweak to gain migration speed. We have got 8core of CPU, 56GB RAM and unlimited bandwidth b/w the Oracle and EPAS databases.
Any further inputs really appreciated.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SMR replication using xDB
Hi @Mahisha,
As recommended earlier, use the sync replication and not the snapshot replication for 2 TB DB size.
For faster snapshot, some of the recommendation are mentioned at the section 5.8 in the document shared earlier.
You can use the options such as copyViaDBLinkOra, please go through the document and try it.
It may increase your performance. However, it may not complete within your expected time frame (2 hours for 2 TB).
Please let us know in case of any issues/queries.
Regards,
Sudhir
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SMR replication using xDB
Thank you @slonkar for your inputs, as we can't go ahead with sync replication, will try copyViaDBLinkOra option.
Will keep the results posted here :)