How to change default snapshot implementation to ad-hoc

[CC VMaster]

The default snapshot implementation is 'Starts a transaction with repeatable read semantics to ensure that all subsequent reads within the transaction are done against the consistent snapshot',    It can not be  snapshot  in parallel and this make take a long time.

How can i change the default consistent snapshot to ad-hoc snapshot when first startup?

[Chris Cranford]

Hi

So in order to use ad-hoc snapshots you must first configure your connector to use signaling.  You can take a look at this document [1] which includes links to the various connectors to go into more detail about ad-hoc incremental snapshots per connector.  Once this is configured you will want to set the "snapshot.mode" to perform a schema only snapshot for MySQL, Oracle, SQL Server, or Db2, or set it to not perform a snapshot at all for PostgreSQL.  Then you will want to insert a record as described in the document [1] into the signal table, which will trigger the ad-hoc incremental snapshot.  If the connector has been correctly set up, the connector will receive the signal and will proceed with performing the snapshot concurrently while streaming changes from the database transaction logs.

Hope that helps
Chris

[1]: https://debezium.io/documentation/reference/stable/configuration/signalling.html

On 6/28/22 07:39, CC VMaster wrote:

The default snapshot implementation is 'Starts a transaction with repeatable read semantics to ensure that all subsequent reads within the transaction are done against the consistent snapshot',    It can not be  snapshot  in parallel and this

 make take a long time.

How can i change the default consistent snapshot to ad-hoc snapshot when first startup? --
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/b9b7e784-3af6-4c21-bc2d-42200ec47911n%40googlegroups.com.