When a MySQL connecor is started, there are various options. The default is
when_needed. The other options may be useful from time to time.
|Initial||The connector runs a snapshot if no offsets have been recorded for the logical server name|
|when_needed||The connector runs a snapshot upon startup when no offsets are available or when a previously recorded offset refers to a binlog location or GTID that is unavailable on the server|
|never||The connector never uses snapshots. On first startup with a logical server name, the connector reads from the beginning of the binlog. Use this carefully when the entire database history is guaranteed to be in the binlog|
|schema_only||The connector runs a snapshot of schemas but not data. Useful when consistent data snapshots are not needed, only changes since the connector started|
|schema_only_recovery||A recovery setting for a connector already capturing changes. Enables recovery of a corrupted or lost database schema history topic. Can be periodically used to clean up unexpected growth in the database schema history topic, which requires infinite retention|
Updated 5 months ago