<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Hi Bucardo community,
<div><br>
</div>
<div>We are new to Bucardo and we are trying to migrate data from an old active Postgres AWS RDS cluster to a brand-new cluster using Bucardo. And I have some questions here.</div>
<div><br>
</div>
<div><b>Background about migration plan:</b></div>
<div>1. Take a snapshot of an active old cluster (source cluster).<br>
2. Create a new cluster (target cluster) using the snapshot from step 1 (so that I don't need to copy schema individually).<br>
3. Create a Bucardo server and set up sync between the old and new cluster with one time copy first then sync delta only.<br>
4. After the new cluster is in sync with the old one, switch application point to the new cluster.</div>
<div><br>
</div>
<div><b>Question 1: How should I set up the onetimecopy property?</b></div>
<div>So please correct me if I'm wrong:</div>
<div>I think I should set it to <b>onetimecopy=1</b> when I add the sync. It will automatically delete all data from the new cluster table first and do a full load from the source cluster, then automatically change to the delta mode, am I right?</div>
<div>And during the full load, all changes happened on source cluster will be buffered and will be applied to the target cluster after the completion of full load, am I right?</div>
<div><br>
</div>
<div><b>Question 2: Table has "auto increment" primary key.</b></div>
<div>We have some use cases using sequence <span style="color: rgb(51, 103, 145); font-family: monospace, monospace; font-size: 14.4px;">nextval </span>to generate incremental numbers as the primary keys for the table. And I have a concern about key collisions
during migration. Because when we switch the application endpoint, we will have moments that application pods point to both old and new clusters. That might have a chance to create primary key collisions. Is this concern valid?</div>
<div><br>
</div>
<div><b>Question 3: What is the best practice of using a herd?</b></div>
<div>If I have 5 dbs in the source cluster, and each db has 10 tables, should I create 5 herds to sync 5 dbs concurrently? or create 1 herd to sync the 5 dbs sequentially? What is the best practice here? </div>
<div><br>
</div>
<div><b>Question 4: Any issue could be caused by Bucardo if the source cluster has a lot of traffic?</b></div>
<span>Is it possible that after I set the sync, and start bucardo, somehow it will crash the source DB? maybe somehow lock the table? Is that concern valid?</span><br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<span><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Please feel free to let us know if you need more details.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Thank you,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Su</div>
</body>
</html>