Skip to content

Instantly share code, notes, and snippets.

@mpenick
Last active May 8, 2025 20:58
Show Gist options
  • Save mpenick/da95f42dfa1fcf3617325570092b1d9f to your computer and use it in GitHub Desktop.
Save mpenick/da95f42dfa1fcf3617325570092b1d9f to your computer and use it in GitHub Desktop.
CQL Router Fallout Tests
description: |
A workload with only text keys and text values.
This workload is rather simple but it is useful for demonstration purposes.
If you want a more thorough example, you might be interested in the
baselinesv2/cql-* workloads.
defaults:
TEMPLATE(keyspace,baselines)
TEMPLATE(table,keyvalue)
scenarios:
astra:
schema: run driver=cql tags==block:schema-astra threads==1 cycles==UNDEF
rampup: run driver=cql tags==block:rampup cycles===TEMPLATE(rampup-cycles,10000000) threads=auto
main: run driver=cql tags=='block:main-.*' cycles===TEMPLATE(main-cycles,10000000) threads=auto
bindings:
rw_key: <<keydist:Uniform(0,1000000000)->int>>; ToString() -> String
rw_value: AlphaNumericString(<<valuesize:1024>>);
blocks:
schema-astra:
ops:
create-table:
raw: |
create table if not exists TEMPLATE(keyspace,baselines).TEMPLATE(table,keyvalue) (
key text,
value text,
PRIMARY KEY (key)
);
main-read:
params:
ratio: 5
cl: TEMPLATE(read_cl,LOCAL_QUORUM)
ops:
main-select:
prepared: |
select * from TEMPLATE(keyspace,baselines).TEMPLATE(table,keyvalue) where key={rw_key};
main-write:
params:
ratio: 5
cl: TEMPLATE(write_cl,LOCAL_QUORUM)
ops:
main-insert:
prepared: |
insert into TEMPLATE(keyspace,baselines).TEMPLATE(table,keyvalue)
(key, value) values ({rw_key}, {rw_value});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment