kvoli

div[data-line-number]:not([data-line-number="0"]):before {
  content:attr(data-line-number);
  position:absolute;
  color: #444; /* line number text color */
  padding: 1px 3px 3px;
  font-size: x-small;
  display: block;
  width: 20px;
  text-align: right;
}

kvoli

# crdb ycsb n3cpu8
export gce_project=cockroach-ephemeral
export cluster=austen-ycsb-crdb

roachprod create $cluster -n 4 --gce-machine-type=n1-standard-8 --local-ssd=false --gce-pd-volume-size=1000
roachprod extend $cluster --lifetime 24h

# recent commit off master 22/12/05

kvoli

# crdb ycsb n3cpu8
export gce_project=cockroach-ephemeral
export cluster=austen-ycsb-crdb

roachprod create $cluster -n 4 --gce-machine-type=n1-standard-8 --local-ssd=false --gce-pd-volume-size=1000
roachprod extend $cluster --lifetime 24h

# recent commit off master 22/12/05

kvoli

export gce_project=cockroach-ephemeral
export cluster=austen-taobench-tidb
roachprod create $cluster -n 4 --gce-machine-type=n1-standard-16 --local-ssd=false --gce-pd-volume-size=5000 --gce-image=ubuntu-1804-bionic-v20221018
roachprod extend $cluster --lifetime 72h

curl --proto '=https' -tlsv1.2 -sSf  https://gist.githubusercontent.com/kvoli/79e73e8e95d80064f6074751802253c7/raw/60ff1995b05c2fcc97131e4ecee085bbe104d92d/tiup.sh | sh


roachprod ssh $cluster:1 <<'EOF'
    sudo apt-get update

kvoli

export gce_project=cockroach-ephemeral
export cluster=austen-taobench
roachprod create $cluster -n 4 --gce-machine-type=n1-standard-16 --local-ssd=false --gce-pd-volume-size=5000
roachprod stage $cluster cockroach 803d7f5ea75e9d28b9d7ec641173751d65b2db1f #recent commit off v22.2.0
roachprod extend $cluster --lifetime 72h
roachprod start $cluster:1-3
roachprod grafana-start $cluster
roachprod run $cluster:4 -- "./cockroach gen haproxy --insecure --host=`roachprod ip $cluster:1`"

roachprod ssh $cluster:4 <<'EOF'

kvoli

1000,600000,1000
1000,1800000,3000
1000,3600000,6000
1000,5400000,9000
1000,7200000,12000

kvoli

crdb.connectionstring=postgresql://root@austen-taobench-0004:26257/defaultdb?sslmode=disable

kvoli

{
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "grafana",
          "uid": "-- Grafana --"
        },
        "enable": true,

kvoli

#!/bin/sh

# Setup script for TiDB on roachprod.

# create the cluster topology file 
curl --proto '=https' -tlsv1.2 -ssf https://gist.githubusercontent.com/kvoli/a2850070bc1a3c38da87f855b21a0251/raw/02c40214fbf32e9a445f3f94838b75752fb7a2b9/topology.yaml > topology.yaml
curl --proto '=https' -tlsv1.2 -sSf https://gist.githubusercontent.com/kvoli/c1f3dfa80e22d9e342f19f91a2fc12c4/raw/b83945c79f1034c1efa694d67758fe020bd18dab/format_tidb_topology.py > format_tidb_topology.py

python3 format_tidb_haproxy.py $(roachprod ip $cluster)

kvoli

import yaml
import sys

TOPOLOGY_FILENAME = "topology.yaml"
HA_FILENAME = "haproxy.cfg"

ha_cfg = """
global                                     # Global configuration.
   log         127.0.0.1 local2            # Global syslog servers (up to two).
   chroot      /var/lib/haproxy            # Changes the current directory and sets superuser privileges for the startup process to improve security.