Hi folks! We have a multi-tenant MySQL instance wh...
# replication-troubleshootingi
Igor
11/22/2022, 1:02 PMHi folks! We have a multi-tenant MySQL instance where each database (aka schema) have the same structure and contains data for a certain customer. In Airbyte you can only create a connection to a single database as a source. We have thousands customers though. So is there a way to create sources for all the customers dynamically/programmatically? Appreciate any advice.
✅ 1
b
Bob De Schutter
11/22/2022, 1:03 PMmaybe have a look at the octavia-cli and generate your yaml files for sources and connections programatically?
i
Igor
11/22/2022, 1:22 PM@Bob De Schutter looks handy! But can not really find how to properly describe my sources in the YAML file, could you help with that?
b
Bob De Schutter
11/22/2022, 1:28 PMWell, you use the command
octavia generate source <definition_id> <source_name>Bob De Schutter
11/22/2022, 1:29 PMThis generates a yaml file to configure a mysql source
Bob De Schutter
11/22/2022, 1:29 PMyou could use that one as a template and produce multiple of those in a loop
Bob De Schutter
11/22/2022, 1:29 PMit's just a thought, I haven't done it myself 🙂
i
Igor
11/22/2022, 1:38 PM@Bob De Schutter thanks for your comments!
4 Views