Fabrizio Spini
02/10/2025, 2:22 PMpt-online-schema-change
if mysql is the source?kapa.ai
02/10/2025, 2:22 PMpt-online-schema-change
tool when MySQL is the source. The documents do not contain any explicit mention of Percona or the pt-online-schema-change
tool. However, I can provide some relevant information about how Airbyte handles schema changes in MySQL sources in general: 1. Airbyte has a feature for detecting and propagating schema changes. According to the [Schema Change Management documentation](https://docs.airbyte.com/using-airbyte/schema-change-management#detect-and-propagate-schema-changes-connection-setting), there are several options for handling schema changes: - Propagate field changes only - Propagate all field and stream changes - Approve all changes manually - Stop future syncs 2. For MySQL sources using CDC (Change Data Capture), Airbyte checks for schema changes before each sync. As mentioned in the [MySQL Source documentation](https://docs.airbyte.com/integrations/sources/mysql#quick-start): "For Cloud users, Airbyte automatically checks for any changes in your source schema immediately before syncing, at a maximum of every 15 minutes per source." 3. Airbyte can detect various types of schema changes, including new columns/fields, removal of columns/fields, new streams, removal of streams, and column data type changes. 4. If a breaking schema change is detected (such as removal of a primary key or cursor), the connection will be paused for manual review. While these features suggest that Airbyte has mechanisms to handle schema changes, the knowledge sources do not provide specific information about how it interacts with Percona's pt-online-schema-change
tool. To get a definitive answer about Airbyte's compatibility with this specific tool, you may need to consult Airbyte's support or documentation directly, or consider testing it in a non-production environment.