ReadySet Server

The readyset-server command starts the ReadySet server.

This command is used only when running the ReadySet Server and Adapter as separate processes on separate machines. To run the ReadySet Server and Adapter as a single process, use the readyset command with the --standalone option.

Usage

Start the ReadySet Server:

readyset-server [OPTIONS]

Start the ReadySet Adapter:

readyset [OPTIONS, excluding --standalone]

View help:

readyset-server --help

Options

`--address`, `-a`

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

Env variable: LISTEN_ADDRESS

`--authority-address`

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

Env variable: AUTHORITY_ADDRESS

`--cannot-become-leader`

When running multiple ReadySet Servers, prevent this Server from ever being elected as leader.

`--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.

Env variable: DEPLOYMENT

`--disable-telemetry`

Don't sent anonymous telemetry data to ReadySet.

Env variable: DISABLE_TELEMETRY

`--external-address`

The IP address/hostname to advertise to ReadySet instances running in the same deployment. This also defines the IP address/hostname of the Prometheus endpoint for ReadySet metrics (opens in a new tab).

Default: Address from --address

Env variable: EXTERNAL_ADDRESS

`--external-port`, `-p`

The port to advertise to ReadySet instances running in the same deployment. This also defines the port of the Prometheus endpoint for ReadySet metrics (opens in a new tab).

Default: 6033

`--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 the ReadySet Server.

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.

`--no-readers`

If set, this server will never run domains containing reader nodes

Pass this flag to the server instance when running a ReadySet deployment in embedded readers mode (eg for high availability)

Env variable: NO_READERS=true

`--prometheus-metrics`

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

Env variable: PROMETHEUS_METRICS

`--quorum`, `-q`

For a distributed ReadySet deployment with multiple ReadySet Server instances, the number of ReadySet Server instances. ReadySet will wait until this number is reached before accepting requests.

Default: 1

Env variable: NORIA_QUORUM

`--reader-replicas`

Number of times to replicate domains that contain readers

This flag should be set to the number of adapter instances in the ReadySet deployment when running in embbedded readers mode (eg for high availability)

Env variable: READER_REPLICAS

`--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

`--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.

`--version`, `V`

Print ReadySet version information.

`--volume-id`

The volume associated with a ReadySet Server.

For a distributed ReadySet deployment with multiple ReadySet Servers, snapshotted tables are scheduled, round-robin, onto volumes associated with Server instances. If a Server restarts, the Server must know which volume contains its portion of the snapshot.

Env variable: VOLUME_ID

Examples

These examples focus on a distributed ReadySet deployment (i.e., ReadySet Server and Adapter running as distinct processes and separate machines). For running a standard ReadySet deployment, see the readyset examples.

Start ReadySet

Start an instance of Consul to serve as the external authority for node discovery, leader election, and consensus, and to manage internal state and metrics.
Start the ReadySet Server:

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

Start one or more ReadySet Adapters:

readyset \
--upstream-db-url="mysql://<db user>:<db password>@<db address>:3306/<database>" \
--username=<readyset user> \
--password=<readyset password> \
--address=<readyset adapter address> \
--authority-address=<consul address>
>> logs/readyset.log 2>&1 &

Print version information

readyset-server --version

readyset-server
release-version: beta-2023-01-18
commit_id:       de35883e248180c7e3f2f7913c0d1c2b371e53ec
platform:        aarch64-apple-darwin
rustc_version:   rustc 1.64.0-nightly (fe3342816 2022-08-01)
profile:         release
opt_level:       3

ReadySet Telemetry

ReadySet Server

Usage

Options

--address, -a

--authority-address

--cannot-become-leader

--db-dir

--deployment

--disable-telemetry

--external-address

--external-port, -p

--help, -h

--log-format

--log-level

--memory-limit, -m

--no-readers

--prometheus-metrics

--quorum, -q

--reader-replicas

--replication-tables

--replication-tables-ignore

--ssl-root-cert

--tracing-host

--tracing-sample-percent

--upstream-db-url

--version, V

--volume-id