implementing as immutable as possible data modelization and benchmarking it on different platforms.
the benchmark comparison is for very specific use case:
- Golang 1.8.3
- Containerized DBs, latest versions
- Specific schemas
- Used configurations
- GCP as cloud provider (or local, until docker for GCP is allowing experimental)
- n1-standard-1 as machine type
Hence, they can't be used to affirm that this or this db is better. The context matters!
Just check them here!
- MySQL
- MariaDB
- PerconaDB
- Postgres
- CockroachDB
- SQLite
- Microsoft SQL Server
- Oracle
- Reference hosted MySQL on GCP
- Reference hosted Postgres on GCP
- Vitess
- Cloud Spanner
- local swarm cluster - local solo db container
- swarm cluster - gcloud solo db container
- kubernetes cluster - gcloud solo db container
- swarm cluster - gcloud cluster db containers
- kubernetes cluster - gcloud cluster db containers
Download Oracle instant client for Oracle (basic and SDK) to the infra/build folder
./build-docker-cmd-status.sh
./status/run-test.sh
./bench/status/swarm/run-all.sh schematype (islatest or lateststatus)
./bench/status/kubernetes/run-all.sh (islatest or lateststatus)
- Bench 1000000 loops and get the best of 5 runs for each db
- Test different storage (mounted standard disk, mounted ssd, local ssd)
- Test High Availability
- Leverage new go 1.8 capabilities (named queries, remove sqlx?)
- Vendor deps (github.com/kardianos/govendor)