Configure ksqlDB CLI

You can connect the ksqlDB CLI to one ksqlDB server per cluster.

Important

There is no automatic failover of your CLI session to another ksqlDB Server if the original server that the CLI is connected to becomes unavailable. Any persistent queries you executed will continue to run in the ksqlDB cluster.

To connect the ksqlDB CLI to a cluster, run the following command with your ksqlDB server URL specified (default is http://localhost:8088):

<path-to-confluent>/bin/ksql <ksql-server-URL>

Configure Per-session Properties

You can set the properties by using the ksqlDB CLI startup script argument /bin/ksql <server> --config-file <path/to/file> or by using the SET statement from within the ksqlDB CLI session. For more information, see Start the ksqlDB CLI.

Here are some common ksqlDB CLI properties that you can customize:

• ksql.streams.auto.offset.reset
• ksql.streams.cache.max.bytes.buffering
• ksql.streams.num.stream.threads

---

Last update: 2020-07-30