PeterCorless’s gists

PeterCorless / 01-config.dynamodb.yaml

Last active September 12, 2019 15:33

Scylla Alternator Gists

	source:
	hostURL: http://dynamodb.us-east-1.amazonaws.com
	region: us-east-1
	port: 8000
	credentials:
	accessKey: <user>
	secretKey: <pass>
	target:
	hostURL: http://scylla-ip
	port: 8000

PeterCorless / 01-system.large_rows.cql

Created April 8, 2020 15:58

Large Rows and Cells

	> SELECT * FROM system.large_rows;

	keyspace_name \| table_name \| sstable_name \| row_size \| partition_key \| clustering_key \| compaction_time
	--------------+------------+--------------------------------------------------------------------------------------+----------+---------------+----------------+---------------------------------
	mykeyspace \| gr \| /var/lib/scylla/data/mykeyspace/gr-67d502908ea211e98d05000000000000/mc-1-big-Data.db \| 1206130 \| 1 \| 1 \| 2019-06-14 13:03:24.039000+0000

PeterCorless / newstack-01-file-descriptors.c

Last active January 6, 2024 16:40

newstack-io_uring-ebpf-examples

	ssize_t read(int fd, void *buf, size_t count);

	ssize_t write(int fd, const void *buf, size_t count);

PeterCorless / 01-create-table.cql

Created May 6, 2020 19:32

Introducing-Scylla-Open-Source-4.0

	> CREATE TABLE base_table (
	pk text,
	ck text,
	val1 text,
	val2 text,
	PRIMARY KEY (pk, ck)
	) WITH cdc = { ‘enabled’ = ‘true’, preimage = ‘true’ };

PeterCorless / 01-sctool-task-list.sh

Created July 7, 2020 17:12

Scylla Manager 2.0 Backups

	> sctool task list Cluster: cluster1 (7313fda0-6ebd-4513-8af0-67ac8e30077b)
	╭───────────────────────────────────────────────────────┬────────────────────────────────────────────────────────────┬───────────────────────────────┬─────────╮
	│ Task │ Arguments │ Next run │ Status │
	├───────────────────────────────────────────────────────┼────────────────────────────────────────────────────────────┼───────────────────────────────┼─────────┤
	│ healthcheck/ba29df86-6f31-4984-a2ba-a3855290f00d │ │ 12 May 20 13:15:47 UTC (+15s) │ DONE │
	│ healthcheck_rest/dcb6cd6a-f66c-4493-824d-43599dc83519 │ │ 12 May 20 14:08:47 UTC (+1h) │ DONE │
	│ backup/001ce624-9ac2-4076-a502-ec99d01effe4 │ -L s3:backup-bucket --retention 7 --rate-limit 50 │ 13 May 20 13:15:18 UTC (

PeterCorless / sctool-repair.sh

Created November 12, 2020 18:03

Scylla Manager 2.2 Repair Revisited

	Status: DONE
	Start time: 12 Nov 20 13:17:26 CET
	End time: 12 Nov 20 13:21:11 CET
	Duration: 3m45s
	Progress: 100%
	Datacenters:
	- dc1
	- dc2

	╭───────────────┬────────┬──────────┬──────────╮

PeterCorless / cqlsh-select-from-system-status.sh

Created December 29, 2020 18:51

	cqlsh> SELECT * from system.status;

	peer \| dc \| host_id \| load \| owns \| status \| tokens \| up
	-----------+-------------+--------------------------------------+-------------+------+--------+--------+------
	127.0.0.1 \| datacenter1 \| cf58dfca-c221-4b4a-a67a-414d4be5bb33 \| 1.18745e+08 \| 1 \| NORMAL \| 256 \| True

PeterCorless / 01-try-cluster.java

Last active February 9, 2021 00:20

Reading CDC with Java and Go

	try (Cluster cluster = Cluster.builder().addContactPoint(source).build();
	Session session = cluster.connect()) {

PeterCorless / 01-sctool-suspend.sh

Created May 5, 2021 16:27

Scylla Manager 2.3

	$ sctool suspend -c prod
	$ sctool task list
	Cluster: prod (097351fe-3c28-4f13-bbac-213981513968)
	╭─────────────────────────────────────────────────────────────┬─────────────────┬───────────────────────────────────────────┬─────────╮
	│ Task │ Arguments │ Next run │ Status │
	├─────────────────────────────────────────────────────────────┼─────────────────┼───────────────────────────────────────────┼─────────┤
	│ healthcheck/b657ed84-0451-4c0c-ac4c-dacd704c1ff7 │ │ 29 Mar 21 13:39:05 CEST (+15s) │ DONE │
	│ healthcheck_alternator/7046049b-6ea8-4a58-9d60-c6c241354681 │ │ 29 Mar 21 13:39:05 CEST (+15s) │ DONE │
	│ healthcheck_rest/0303dda3-f417-4997-8d81-6a4936d6be56 │ │ 29 Mar 21 13:39:20 CEST (+1m) │ DONE │
	│ repair/7ddaa89e-d6ae-4292-8d6b-1ab8fa13d39b │ │ [SUSPENDED] 30 Mar 21 00:00:0

PeterCorless / 01-sctool-status.sh

Last active June 30, 2021 18:38

Scylla-Manager-Cloning

	$ sctool status
	Cluster: test (77472fd3-a85f-4c8e-bdf5-6c17696ab975)
	Datacenter: dc1
	╭────┬────────────┬──────────┬──────────┬────────────────┬──────────┬──────┬──────────┬────────┬──────────┬──────────────────────────────────────╮
	│ │ Alternator │ CQL │ REST │ Address │ Uptime │ CPUs │ Memory │ Scylla │ Agent │ Host ID │
	├────┼────────────┼──────────┼──────────┼────────────────┼──────────┼──────┼──────────┼────────┼──────────┼──────────────────────────────────────┤
	│ UN │ UP (13ms) │ UP (5ms) │ UP (2ms) │ 192.168.100.11 │ 7h26m34s │ 4 │ 31.12GiB │ 4.2.1 │ Snapshot │ 3827c1d1-b300-4093-9839-0cf01f1b9346 │
	│ UN │ UP (9ms) │ UP (3ms) │ UP (2ms) │ 192.168.100.12 │ 7h26m34s │ 4 │ 31.12GiB │ 4.2.1 │ Snapshot │ a4f20c78-0a64-490c-b7f4-f52a62667ff8 │
	│ UN │ UP (14ms) │ UP (4ms) │ UP (2ms) │ 192.168.100.13 │ 7h26m34s │ 4 │ 31.12GiB │ 4.2.1 │ Snapshot │ ffa39462-d3f1-46d9-875c-ef89044e951e │
	╰────┴────────────┴──────────┴──────────┴────────────────

Peter Corless PeterCorless