ReadySet

The readyset command starts the ReadySet server and adapter as a single process on a single machine (with the --standalone option) or starts the ReadySet adapter as a distinct process from the ReadySet server (readyset-server).

Usage

Start the ReadySet Server and Adapter as a single process:

readyset --standalone [OPTIONS]

Start the ReadySet Adapter as a distinct process, after starting the ReadySet Server:

readyset-server [OPTIONS]
readyset [OPTIONS, excluding --standalone]

View help:

readyset --help

Options

`--address`, `-a`

The IP address/hostname and port that ReadySet listens on.

Default: 3307 for MySQL deployments and 5433 for PostgreSQL deployments.

Env variable: LISTEN_ADDRESS

`--authority-address`

The IP address/hostname and port of the external authority. ReadySet clusters support Consul as the external authority.

This option is ignored when --standalone is passed. In that case, the ReadySet Server and Adapter are run as a single process, and no external authority is required.

Env variable: AUTHORITY_ADDRESS

`--db-dir`

The path to the directory where ReadySet stores replicated table data.

Default: Current working directory

Env variable: DB_DIR

`--deployment`

A unique identifier for the ReadySet deployment.

Default: tmp-readyset

Env variable: DEPLOYMENT

`--disable-telemetry`

Don't sent anonymous telemetry data to ReadySet.

Env variable: DISABLE_TELEMETRY

`--embedded-readers`

For a distributed ReadySet deployment, store cached query results with the Adapter instead of the Server.

To use this option, you must pass --no-readers and --reader-replicas when starting readyset-server.

Env variable: EMBEDDED_READERS

`--help`, `-h`

Print help information.

`--log-format`

Format to use when emitting log events. See the docs for the tracing library (opens in a new tab) for details.

Possible values: "compact", "full", "pretty", "json"

Default: "full"

Env variable: LOG_FORMAT

`--log-level`

The severity level(s) (opens in a new tab) to include in ReadySet logs. Messages at the specified and more severe levels are included. For example, when set to INFO, messages at the INFO, WARN, and ERROR levels are included.

Possible values, from most to least severe:

ERROR: Used for hazardous situations that require special handling, where normal operation cannot proceed as expected.
WARN: Used for potentially hazardous situations that may require special handling.
INFO: Used for information messages that do not require action.
DEBUG: Used for lower priority information.
TRACE: Used for very low priority, often extremely verbose information.

The TRACE level is not available for official releases of ReadySet, or for binaries built with the --release flag. Also, --log-level can be set to a comma-separated list of directives for debugging during development. For the directive syntax, see the docs for the tracing library.

Default: INFO

Env variable: LOG_LEVEL

`--memory-limit`, `-m`

The amount of memory, in bytes, available to ReadySet.

This memory limit accounts for all memory use, including partial materializations (i.e., queries for which ReadySet stores only part of the result set), full materializations (i.e., queries for which ReadySet stores the entire result set), and other parts of the ReadySet process (e.g., RocksDB).

Once memory usage surpasses this limit, ReadySet starts evicting cache entries from partial materializations based on the --eviction-policy.

Default: 0 (unlimited)

Env variable: READYSET_MEMORY_LIMIT

💡

For production deployments, start by setting this to 60-80% of the machine's total memory. Then run the system under load, observe, and increase or decrease as needed.

`--metrics-address`

The IP address/hostname and port of the Prometheus endpoint for ReadySet metrics (opens in a new tab).

This option is ignored unless --prometheus-metrics is passed. Also, when running a distributed ReadySet deployment, this option determines the Prometheus endpoint for the ReadySet Adapter only. The --external-address option for the readyset-server command determines the Prometheus endpoint for the ReadySet Server.

Default: 0.0.0.0:6034

Env variable: METRICS_ADDRESS

`--password`

The password for authenticating connections to ReadySet. This can differ from the password in the database connections string in --upstream-db-url.

This option is ignored when --allow-unauthenticated-connections is passed.

Default: The username for the upstream database in --upstream-db-url.

Env variable: ALLOWED_PASSWORD

`--prometheus-metrics`

Output ReadySet metrics to the Prometheus endpoint at <metrics address>/metrics. The metrics address is defined by --metrics-address.

Env variable: PROMETHEUS_METRICS

`--query-log`

Include query-specific execution details in Prometheus metrics. Enabled by default if PROMETHEUS_METRICS is set.

To use this option, you must pass `--prometheus-metrics as well.

Env variable: QUERY_LOG

`--query-log-ad-hoc`

Include execution details for ad-hoc queries in Prometheus metrics. Ad-hoc queries are those that do not use parameters. Enabled by default if PROMETHEUS_METRICS is set.

To use this option, you must pass `--query-log as well.

Env variable: QUERY_LOG_AD_HOC

`--replication-tables`

By default, ReadySet attempts to snapshot and replicate all tables in the database specified in --upstream-db-url. However, if the queries you want to cache in ReadySet access only a subset of tables in the database, you can use this option to limit the tables ReadySet snapshots and replicates. Filtering out tables that will not be used in caches will speed up the snapshotting process.

This option accepts a comma-separated list of <schema>.<table> (specific table in a schema) or <schema>.* (all tables in a schema) for Postgres and <database>.<table> for MySQL.

Only tables specified in the list will be eligible to be used by caches.

Env variable: REPLICATION_TABLES

`--replication-tables-ignore`

By default, ReadySet attempts to snapshot and replicate all tables in the database specified in --upstream-db-url. However, if you know the queries you want to cache in ReadySet won't access a subset of tables in the database, you can use this option to limit the tables ReadySet snapshots and replicates. Filtering out tables that will not be used in caches will speed up the snapshotting process.

This option accepts a comma-separated list of <schema>.<table> (specific table in a schema) or <schema>.* (all tables in a schema) for Postgres and <database>.<table> for MySQL.

Tables specified in the list will not be eligible to be used by caches.

Env variable: REPLICATION_TABLES_IGNORE

`--ssl-root-cert`

Path to the PEM or DER root certificate that the upstream database connection will trust.

Default: System root store

Env variable: SSL_ROOT_CERT

`--standalone`

Run the ReadySet Server and Adapter as a single process. When this option is not passed, the readyset command starts just ReadySet Adapter. In this case, the ReadySet Server must be started first via the readyset-server command.

Env variable: STANDALONE

`--tracing-host`

When using open telemetry, the IP address/hostname and port of the telemetry server to send traces/spans to.

Env variable: TRACING_HOST

`--tracing-sample-percent`

The percent of traces to send to the open telemetry server.

To use this option, you must set --tracing-host.

Possible values: Between 0.0 and 100.0

Default: 0.01

Env variable: TRACING_SAMPLE_PERCENT

`--upstream-db-url`

The URL for connecting ReadySet to to the upstream database. This connection URL includes the username and password for ReadySet to authenticate with as well as the database to snapshot/replicate.

Env variable: UPSTREAM_DB_URL

💡

By default, ReadySet attempts to snapshot and replicate all tables in the database specified in --upstream-db-url. However, if the queries you want to cache in ReadySet access only a subset of tables in the database, you can use the --replication-tables option to narrow the scope accordingly. Filtering out tables that will not be used in caches will speed up the snapshotting process.

💡

Special characters that may be interpreted as dividers of the connection string (e.g. @, :, /, #) must be percent-encoded, including in passwords. For example, password# should be password%23.

`--username`, `-u`

The username for authenticating connections to ReadySet. This can differ from the username in the database connections string in --upstream-db-url.

This option is ignored when --allow-unauthenticated-connections is passed.

Default: The username for the upstream database in --upstream-db-url.

Env variable: ALLOWED_USERNAME

`--version`, `V`

Print ReadySet version information. See the example below.

💡

You can also use the custom SHOW READYSET VERSION SQL command to print ReadySet version information.

Examples

These examples focus on running a standard ReadySet deployment (i.e., ReadySet Server and Adapter running as a single process on a single machine). For running a distributed ReadySet deployment, see the readyset-server examples.

Start ReadySet

readyset \
--standalone \
--upstream-db-url="postgresql://<db user>:<db password>@<db address>:5432/<database>" \
--database-type=postgresql \
--username=<readyset user> \
--password=<readyset password> \
>> logs/readyset.log 2>&1 &

Output metrics to Prometheus

To output ReadySet metrics to Prometheus, pass --metrics-address and --prometheus-metrics. To include query-specific execution details, pass --query-log and --query-log-ad-hoc as well.

readyset \
--standalone \
--upstream-db-url="postgresql://<db user>:<db password>@<db address>:5432/<database>" \
--username=<readyset user> \
--password=<readyset password> \
--prometheus-metrics \
--metrics-address=<prometheus address> \
>> logs/readyset.log 2>&1 &

Print version information

To print ReadySet version information, pass the --version flag:

readyset --version

readyset
release-version: beta-2023-02-15
commit_id:       0f40cee0b4583d559d247077b7c140dce6977f00
platform:        x86_64-unknown-linux-gnu
rustc_version:   rustc 1.64.0-nightly (fe3342816 2022-08-01)
profile:         release
opt_level:       3

Alternatively, you can connect a SQL shell to ReadySet and run the following custom SQL command:

SHOW READYSET VERSION;

ReadySet      |             Version Information
--------------------+---------------------------------------------
release version    | beta-2023-02-15
commit id          | 0f40cee0b4583d559d247077b7c140dce6977f00
platform           | x86_64-unknown-linux-gnu
rustc version      | rustc 1.64.0-nightly (fe3342816 2022-08-01)
profile            | release
optimization level | 3
(6 rows)

Overview ReadySet Server

ReadySet

Usage

Options

--address, -a

--authority-address

--db-dir

--deployment

--disable-telemetry

--embedded-readers

--help, -h

--log-format

--log-level

--memory-limit, -m

--metrics-address

--password

--prometheus-metrics

--query-log

--query-log-ad-hoc

--replication-tables

--replication-tables-ignore

--ssl-root-cert

--standalone

--tracing-host

--tracing-sample-percent

--upstream-db-url

--username, -u

--version, V