Hi there, it’s better to setup replica and use it ...
# replication-troubleshooting
a
Hi there, it’s better to setup replica and use it as a db for airbyte or use directly master mysql database? I’m worried about impact on the production database during initial sync. On the other hand I saw that initial sync do only simple select. Do you have any recommendations in this case?
m
This question is about source or destination? For sources Airbyte will only use select queries to retrieve data. Destination can execute more heavy operations with dbt creating the final tables without dedup data.
a
Question is about source
u
Airbyte only runs select in sources, the sync shouldn't consume much resource from it.
👍 1