No description, website, or topics provided.
Go Shell
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.gitignore
README.md
cockroach.go
lib.go
pg-jsonb.go
pg.go
run_all.sh
scylla.go

README.md

simple-db-benchmark

Preparation

# test1: postgresql
sudo su - postgres <<EOF
createuser test1
createdb test1
psql -c 'GRANT ALL PRIVILEGES ON DATABASE test1 TO test1;'
EOF

# test2: postgresql jsonb
sudo su - postgres <<EOF
createuser test2
createdb test2
psql -c 'GRANT ALL PRIVILEGES ON DATABASE test2 TO test2;'
EOF

# test3: cockroachdb
cockroach start --insecure
cockroach sql --insecure
CREATE DATABASE test3;

# test4: scylladb (under docker)
dir=`pwd`
x=1
mkdir -p $dir/scylla$x/commitlog $dir/scylla$x/data
docker stop scylla$x
docker rm scylla$x
docker run --volume $dir/scylla$x:/var/lib/scylla --name scylla$x \
  -d scylladb/scylla --developer-mode 1 --memory 4G --smp 4
docker logs scylla$x | tail
sleep 2;
docker exec -it scylla$x nodetool status
docker exec -it scylla$x cqlsh 
CREATE KEYSPACE test4 WITH REPLICATION = {'class':'SimpleStrategy', 'replication_factor':1};

# test4: scylladb (supported: ubuntu 17.04+xfs)
sudo wget -O /etc/apt/sources.list.d/scylla.list http://downloads.scylladb.com/deb/ubuntu/scylla-1.7-xenial.list
sudo apt-get update
sudo systemctl enable scylla-server
sudo scylla_setup
sudo sed -i 's|/usr/bin/scylla $SCYLLA_ARGS|/usr/bin/scylla -m 8G -c 8 $SCYLLA_ARGS|g' /lib/systemd/system/scylla-server.service
sudo systemctl daemon-reload
sudo systemctl start scylla-server # cqlsh 127.0.0.1
CREATE KEYSPACE test4 WITH REPLICATION = {'class':'SimpleStrategy', 'replication_factor':1};