All most all corporations move data from one database to another or from one location to another for various purposes. There are various products like GoldenGate, Data Guard, Attunity Replicate, Tungsten and others for replicating data. I often hear one product is better than other and I don't want to deny that but what matters in the data replication is the design of the database and the replication strategies.
These are my replication best practices which I learnt the hard way so I and my colleagues can sleep without getting a single page for latencies, locked tables or other replication errors. I don't make any exception to these rules for any customers or clients because this is going to bite us and become a nightmare to support it.
- Limit the number of tables to as low as possible. Don't replicate the whole schema or database using a single replication task. Divide them into many jobs and balance big and small tables in terms of volume and data size.
- Don't replicate CLOB or LOB. Many replication tools either don't support or truncate CLOB/LOB column even though they advertise it.
- 1-1 table replication between the source and target table. The replication always should be the 1-1 table from source and target and it can't be from many tables in the source to one table in the target. Some tools support MERGE logic but this is a terrible idea when data volumes grow.
- Limit the number of Constraints in Target tables. PK is the only constraints that you need to avoid duplicate. Adding too many Constraints slow down the replication and those constraints check should happen in source and not target table.
- Absolutely No DDL Replication just DML Replication. Yes, most tool support this feature but I would disable these features to prevent the target table from being ALTERed, TRUNCATEd, and DROPped.
- The table structure should be the same in both source and target. The source and target table should have the same table structures including data types and the only thing that can be different is the constraint on target tables.
- Not your ETL or Data Manipulation Tool. Remember, this is your replication tool, not your ETL tool. Even though they allow some kind of data manipulation, we should limit the data manipulation for data conversion from one database to another. The will and can slow down the replication.
- Don't Advertise real-time replication. There are no tools for real-time replication and never promise anyone regardless of data volumes. With the best database design and replication best practices, you can achieve close to near-real-time but there are so many other factors like network, database load, bandwidth which can increase latencies which you don't have control.
- No Replication within the same database. Yes, I have seen a replication happening from one schema to another schema within the same Oracle database. Similarly, in one database to another database within a SQL Server Instance. Don't set up this type of replication even though replication is supported within a database, use script or other database vendor provided tools. It causes a lot of latency and generates redo log that isn't necessarily causing overhead to the database.
- No Merge/UPSERT logic. This is similar to that of rule #3, repeating again to reinforce the practice
- Never enable Bi-Directional replication feature. This is the most dangerous replication practices of all and I would tell my client there is no such feature out there. Anyone has enabled bi-directional replication? Please tell us more on the project and how do you support when there is data mismatch issue? I would like to learn more and everyone here would like to know more.
Violating these Eleven Golden Replication rules may suffer into a loss of sleep, latency anxiety, replication PTSD and much, much more. I hope you use them at your own risk to benefit your health, the database health and make no exception to these rules. Oops, I just got a latency alert, I will see you after the latency is caught up.
Interested in working with me? I can be reached at pbaniya04[at]gmail.com for any questions, consulting opportunities or you may drop a line to say HELLO. Thank your again for visiting my blog and looking forward to serving you more.
Have a Database-ious Day!
Have a Database-ious Day!

On the off chance that the exhibit isn't numerical, there isn't much we can do with the exception of perusing and composing its information. ExcelR Data Science Courses
ReplyDeleteGreat Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
ReplyDeleteThis is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
data science course in guwahati
This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
ReplyDeleteData Science Institute in Bangalore
Great post i must say and thanks for the information.
ReplyDeleteData Science Certification in Bangalore
I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
ReplyDeleteSimple Linear Regression
Correlation vs Covariance
I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
ReplyDeletedata science course in guntur
I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
ReplyDeleteData Analytics Course in Pune
Data Analytics Training in Pune
Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.
ReplyDeleteData Science In Banglore With Placements
Data Science Course In Bangalore
Data Science Training In Bangalore
Best Data Science Courses In Bangalore
Data Science Institute In Bangalore
Thank you..
Hello, I have browsed most of your posts. This post is probably where I got the most useful information for my research. Thanks for posting, we can see more on this. Are you aware of any other websites on this subject.
ReplyDeletedata science training
data science course
data science course in hyderabad
This post is great. I reallly admire your post. Your post was awesome.
ReplyDeletedata science course in Hyderabad
I feel a lot more people need to read this, very good info!.Learn best Data Science Course in Hyderabad
ReplyDeleteI am impressed by the information that you have on this blog. Thanks for Sharing
ReplyDeleteEthical Hacking in Bangalore
Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.
ReplyDeleteRowe Rowe
Manager Rowe Rowe
Rapper Rowe Rowe
Thank you..
Damien Grant
ReplyDeleteDamien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
ReplyDeleteDamien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
Damien Grant
A good blog always comes-up with new and exciting information and while reading I have felt that this blog really has all those quality that qualify a blog to be a one.
ReplyDelete360gigitmg.com
The article unambiguously showed each of the positive and negative sides of the issue. This is indeed a thought infuriating article.
ReplyDeleteData Science training in Mumbai
Data Science course in Mumbai
SAP training in Mumbai
Highly appreciable regarding the uniqueness of the content. This perhaps makes the readers feels excited to get stick to the subject. Certainly, the learners would thank the blogger to come up with the innovative content which keeps the readers to be up to date to stand by the competition. Once again nice blog keep it up and keep sharing the content as always.
ReplyDelete360DigiTMG Business Analytics Course
Attend The Data Analyst Course From ExcelR. Practical Data Analyst Course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analyst Course.
ReplyDeleteData Analyst Course
Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteSimple Linear Regression
Correlation vs covariance
data science interview questions
KNN Algorithm
Logistic Regression explained
This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data sciecne course in hyderabad
ReplyDeleteThis was certainly one of my preferred web journals. Each post distributed impressed me.
ReplyDeletedata science courses in delhi
There is no dearth of Data Science course syllabus or resources. Learn the advanced data science course concepts and get your skills upgraded from the pioneers in Data Science.
ReplyDeletedata science course bangalore
data science course syllabus
help in understanding the recent trends and customer demands, also to analyze customer feedbacks and most importantly handle inventory and warehousing. data science course syllabus
ReplyDeleteIncredibly in general very intriguing post. I was looking for such an information and took pleasure in scrutinizing this one. Keep posting. An obligation of appreciation is all together for sharing.data analytics course in Hyderabad
ReplyDeleteAttend The Machine Learning Course Bangalore From ExcelR. Practical Machine Learning course Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Machine Learning course Bangalore.
ReplyDeleteMachine Learning Course Bangalore
Very nice blog and articles. I am realy very happy to visit your blog. Now I am found which I actually want. I check your blog everyday and try to learn something from your blog. Thank you and waiting for your new post.
ReplyDeletedata science course in India
You might comment on the order system of the blog. You should chat it's splendid. Your blog audit would swell up your visitors. I was very pleased to find this site.I wanted to thank you for this great read!!
ReplyDeleteArtificial Intelligence Course
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it.
ReplyDeletemachine learning course training in Hyderabad
A great service is that the mistake they make will be send to all other AI computers linked to them so that they will also not make that same mistake. data science course in india
ReplyDeleteYou completed a number of nice points there. I did a search on the issue and found ExcelR Data Analytics Course nearly all people will have the same opinion with your blog.
ReplyDeleteI like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you!
ReplyDeletebusiness analytics course
Really very informative and inoperative blog, Thanks for the post and effort! keep sharing more blogs.
ReplyDeletenew trends in digital marketing
big data analytics
latest technology trends
graphic design for beginners
rpa interview questions for freshers
angularjs interview questions and answers for freshers
As always your articles do inspire me. Every single detail you have posted was great.
ReplyDeletedata science certification in noida
Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
ReplyDeleteData Science Course in Bangalore
Happy to visit your blog, I am by all accounts forward to more solid articles and I figure we as a whole wish to thank such huge numbers of good articles, blog to impart to us.
ReplyDeletedata scientist course
ReplyDeleteI see the greatest contents on your blog and I extremely love reading them.
Best Institute for Data Science in Hyderabad
I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
ReplyDeleteartificial intelligence course in pune
Through this post, i do know that your smart information in fiddling with all the items was very useful. I advise that this can be the primary place wherever I notice problems i have been sorting out. you've got a creative nevertheless engaging approach of writing.
ReplyDeletedata scientists training
If you are looking for Illinois license plate sticker renewals online, you have to go to the right place. We have the fastest Illinois license plate sticker renewals in the state.
ReplyDeleteData Science Course in Pune
Mua vé tại Aivivu, tham khảo
ReplyDeleteVe may bay di My
các chuyến bay từ mỹ về việt nam hiện này
lịch bay từ tphcm đi quy nhơn
vé máy bay ra hà nội bao nhiêu
giá vé hà nội- nha trang vietnam airlines
I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
ReplyDeleteartificial intelligence course in pune
I need to communicate my deference of your composing aptitude and capacity to make perusers read from the earliest starting point as far as possible. I might want to peruse more up to date presents and on share my musings with you.
ReplyDeletebig data analytics malaysia
Thanks for your nice post I really like it and appreciate it. My work is about Custom Vape Cartridge Boxes. If you need perfect quality boxes then you can visit our website.
ReplyDeletei am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
ReplyDeletedata science courses in hyderabad
Good information you shared. keep posting.
ReplyDeletedata scientist course
I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
ReplyDeleteartificial intelligence course in pune
Informative blog
ReplyDeletedata science course in india
I’ve been browsing on-line greater than 3 hours as of late, but I by no means found any attention-grabbing article like yours. It’s pretty value sufficient for me. In my view, if all web owners and bloggers made just right content material as you did, the web can be a lot more useful than ever before.
ReplyDeletedata scientist training in hyderabad
It was a good experience to read about dangerous punctuation. Informative for everyone looking on the subject.
ReplyDeletedata scientist training and placement in hyderabad
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeletedata science course in chennai
This website and I conceive this internet site is really informative ! Keep on putting up!
ReplyDeleteai course
I just couldn't leave your website before telling you that I truly enjoyed the top quality info you present to your visitors? Will be back again frequently to check up on new posts.
ReplyDeletedata scientist training in hyderabad
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeletedata science training in chennai
i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
ReplyDeleteartificial intelligence training in chennai
"Very Nice Blog!!!
ReplyDeletePlease have a look about "
ai courses aurangabad
Thanks for posting the best information and the blog is very important.artificial intelligence course in hyderabad
ReplyDeleteI want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeletedata science course
Thanks for bringing such innovative content which truly attracts the readers towards you. Certainly, your blog competes with your co-bloggers to come up with the newly updated info. Finally, kudos to you.
ReplyDeleteData Science Course in Varanasi
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeletebusiness analytics courses
I am sure that this is going to help a lot of individuals. Keep up the good work. It is highly convincing and I enjoyed going through the entire blog.
ReplyDeletedata science course
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeleteaws training in hyderabad
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
ReplyDeleteiot course in bangalore
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. best institute for cloud computing in hyderabad
ReplyDeleteAmazing Article! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.If you are Searching for info click on given link
ReplyDeleteData science course in pune
Informative blog
ReplyDeletedata analytics courses in hyderabad
This article gives the light in which we can observe reality. This is a very nice one and gives in depth information. Thanks for this nice article.
ReplyDeletedata scientist course in hyderabad
Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one. Keep posting. An obligation of appreciation is all together for sharing.business analytics course in gwalior
ReplyDeleteI want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
ReplyDeletedata science course in thiruvananthapuram
Well we really like to visit this site, many useful information we can get here. data science course in mysore
ReplyDeleteI am the first time visiting this page, really awesome and knowledgeable content. I bookmarked your site for future blogs. Keep up this work. Thank you.
ReplyDeleteAI Patasala Data Science Course in Hyderabad
Thanks for sharing this.,
ReplyDeletecertified scrum master certification
agile scrum master certification
Excellent content ,Thanks for sharing this .,
ReplyDeleteCSPO
CSPO certification cost
Excellent content ,Thanks for sharing this .,
ReplyDeleteOnline teaching platform
Online teaching tool
Online teaching platform
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.data science course in kolhapur
ReplyDeleteThank you so much for doing the impressive job here, everyone will surely like your post.
ReplyDeletecyber security course in malaysia
Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.
ReplyDeleteData Science Certification in Bhilai
Extraordinary blog went amazed with the content that they have developed in a very descriptive manner. This type of content surely ensures the participants to explore more themselves. Hope you deliver the same near the future as well. Gratitude to the blogger for the efforts.
ReplyDeleteData Science Training
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
ReplyDeleteContinue posting. A debt of gratitude is in order for sharing.
data science training in gwalior
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
ReplyDeleteContinue posting. A debt of gratitude is in order for sharing.data science course in warangal
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
ReplyDeletebusiness analytics course in varanasi
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
ReplyDeleteContinue posting. A debt of gratitude is in order for sharing.
data scientist course in warangal
Wonderful blog. I delighted in perusing your articles. This is genuinely an incredible perused for me. I have bookmarked it and I am anticipating perusing new articles. Keep doing awesome!.data science course in bhubaneswar
ReplyDeleteI want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
ReplyDeletedata science training in delhi
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. Project Management Course
ReplyDeleteI want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
ReplyDeletedata scientist course in delhi
Informative blog
ReplyDeletebusiness analytics course in agra
I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors
ReplyDeletedata science course delhi
Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one.
ReplyDeleteKeep posting. An obligation of appreciation is all together for sharing.
data science course in gwalior
Good to visit your weblog again, it has been months for me. Nicely this article that i've been waiting for so long. I will need this post to total my assignment in the college, and it has the exact same topic together with your write-up. Thanks, good share.
ReplyDeletedata analytics course in hyderabad
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
ReplyDeleteContinue posting. A debt of gratitude is in order for sharing.
data analytics course in kolhapur
This post is very simple to read and appreciate without leaving any details out. Great work! PMP Training in Malaysia
ReplyDeleteI’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read!! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site. PMP Course
ReplyDeleteThanks for sharing such useful information with us. I hope you will share some more info about your blog. Please keep sharing. We will also provide HR Software India
ReplyDeleteOur Data Science certification training with a unique curriculum and methodology helps you to get placed in top-notch companies.
ReplyDeleteThanks to all the contents that appear in this guide, those in charge of business management and administration can find out about the characteristics that Microsoft Dynamics 365 presents and the benefits that it brings to the different departments of the companies. Dynamics 365 Customer Service
ReplyDeleteEight fundamental steps to use an online ERP
ReplyDeleteOrganize a suitable team: All software changes are traumatic for companies. This fact is more accentuated when it comes to a large company and complex software.
If we start with a team that is enthusiastic about change and committed to the new software, it will be much easier to extend that encouragement to the rest of the organization.
Incorporation by modules: It can also be efficient to incorporate a new online ERP by modules . Implement it only in one department and see the results and then carry out implementations in other departments.
Good practices: When a new ERP in the cloud is incorporated into business management, it is time to re-imagine what the best operation of the company will be. If you just copy what you already have, you will not get the most out of the new software nor will it be a step forward for the company.
Dynamics 365 Business Central Implementation
NAV to Business Central Upgrade
A person who works on data, manipulates it, and takes the right outcomes from it, but did not deliver the message properly, then all the efforts are a waste of time.data science training in kolkata
ReplyDelete"If you are also one of them and want to know what the companies demand from the data scientists to do in their organization, you have come to the right place.data science course in kolkata"
ReplyDeleteThank you very much for letting me read this. It is incredibly beneficial and instructive, and I gained a lot from it. Data science course in bhopal
ReplyDelete