--- Title: Write-behind configuration for mysql aliases: null alwaysopen: false categories: - docs - integrate - rs - rdi description: Describes the `application.properties` settings that configure Debezium Server for mysql group: di linkTitle: mysql summary: Redis Data Integration keeps Redis in sync with the primary database in near real time. type: integration weight: null --- ## application.properties ```properties debezium.sink.type=redis debezium.sink.redis.message.format=extended debezium.sink.redis.address=: # Comment the following line if not using a password for Write-behind. debezium.sink.redis.password= debezium.sink.redis.memory.limit.mb=80 # Redis SSL/TLS #debezium.sink.redis.ssl.enabled=true # When Redis is configured with a replica shard, these properties allow to verify that the data has been written to the replica. #debezium.sink.redis.wait.enabled=true #debezium.sink.redis.wait.timeout.ms=1000 #debezium.sink.redis.wait.retry.enabled=true #debezium.sink.redis.wait.retry.delay.ms=1000 #debezium.source.database.history.redis.ssl.enabled=true # Location of the Java keystore file containing an application process' own certificate and private key. #javax.net.ssl.keyStore= # Password to access the private key from the keystore file specified by javax.net.ssl.keyStore. This password is used twice: To unlock the keystore file (store password), and To decrypt the private key stored in the keystore (key password). #javax.net.ssl.keyStorePassword= # Location of the Java keystore file containing the collection of CA certificates trusted by this application process (trust store). #javax.net.ssl.trustStore= # Password to unlock the keystore file (store password) specified by javax.net.ssl.trustStore. #javax.net.ssl.trustStorePassword= debezium.source.connector.class=io.debezium.connector.mysql.MySqlConnector # A numeric ID of this database client, which must be unique across all currently-running database processes in the MySQL cluster. debezium.source.database.server.id=1 debezium.source.offset.storage=io.debezium.storage.redis.offset.RedisOffsetBackingStore debezium.source.topic.prefix= debezium.source.database.hostname= debezium.source.database.port= debezium.source.database.user= debezium.source.database.password= debezium.source.include.schema.changes=false # Determines whether the connector should omit publishing change events when there are no modifications in the included columns. debezium.source.skip.messages.without.change=true debezium.source.offset.flush.interval.ms=1000 debezium.source.tombstones.on.delete=false debezium.source.schema.history.internal=io.debezium.storage.redis.history.RedisSchemaHistory # Important: Do NOT use `include` and `exclude` database lists at the same time, use either `include` or `exclude`. # An optional, comma-separated list of regular expressions that match database names to be monitored. # By default, all databases are monitored. #debezium.source.database.include.list=,... # An optional, comma-separated list of regular expressions that match database names for which you do not want to capture changes. #debezium.source.database.exclude.list=,... # Important: Do NOT use `include` and `exclude` table lists at the same time, use either `include` or `exclude`. # An optional, comma-separated list of regular expressions that match fully-qualified table identifiers of tables whose changes you want to capture. #debezium.source.table.include.list=,... # An optional, comma-separated list of regular expressions that match fully-qualified table identifiers for tables whose changes you do not want to capture. #debezium.source.table.exclude.list=,... # Important: Do NOT use include and exclude column lists at the same time, use either include or exclude. # An optional, comma-separated list of regular expressions that match the fully-qualified names of columns to include in change event record values. #debezium.source.column.include.list=,... # An optional, comma-separated list of regular expressions that match the fully-qualified names of columns to exclude from change event record values. #debezium.source.column.exclude.list=,... # Records only DDL statements that are relevant to tables whose changes are being captured by Debezium. # In case of changing the captured tables, run `redis-di reset`. debezium.source.schema.history.internal.store.only.captured.tables.ddl=true # Whether to include the detailed schema information generated by Debezium in each record written to RDI. # Note: Including the schema reduces the initial sync throughput and is not recommended for large data sets. debezium.source.key.converter.schemas.enable=false debezium.source.value.converter.schemas.enable=false # When detailed schema information is excluded, handle decimal numeric types as strings. debezium.source.decimal.handling.mode=string debezium.transforms=AddPrefix debezium.transforms.AddPrefix.type=org.apache.kafka.connect.transforms.RegexRouter debezium.transforms.AddPrefix.regex=.* debezium.transforms.AddPrefix.replacement=data:$0 # Logging # Uncomment the following lines if running Debezium Server as a Java standalone process (non-containerized). #quarkus.log.file.enable=true #quarkus.log.file.path= #quarkus.log.file.rotation.max-file-size=100M #quarkus.log.file.rotation.rotate-on-boot=true #quarkus.log.file.rotation.file-suffix=.yyyy-MM-dd.gz #quarkus.log.file.rotation.max-backup-index=3 # The default minimum log level for every log category, change only quarkus.log.level when needed. quarkus.log.min-level=TRACE # The default log level for every log category. quarkus.log.level=INFO # Determine whether to enable the JSON console formatting extension, which disables "normal" console formatting. quarkus.log.console.json=false # The port on which Debezium exposes Microprofile Health endpoint and other exposed status information. quarkus.http.port=8088 ```