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
Marcos Marx (Airbyte)
01/24/2023, 5:42 PM
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
Andrzej Lewandowski
01/24/2023, 5:43 PM
Question is about source
u
user
01/24/2023, 5:54 PM
Airbyte only runs select in sources, the sync shouldn't consume much resource from it.