Tool LoadBalancer pgBouncer Optimization pgTune LoadTest Percona-Lab/sysbench-tpcc Tuning params max_connections shared_buffers - use for cache [15..25%] effective_cache_size [50%…75%] work_mem - RAM for request (WARNING: count_session * work_mem). For write checkpoint_segments [10-256] Links An Introduction to PostgreSQL Performance Tuning and Optimization

K8s Troubleshooting

Namespace deletion stuck Script: $> kubectl proxy Starting to serve on $> kubectl get namespace istio-system -o json > tmp.json # remove "spec.kubernetes" $> vim tmp.json $> curl -k -H "Content-Type: application/json" -X PUT --data-binary @tmp.json Helm upgraid-faild $> kubectl -n app-namespace patch secret release-name.v123 --type=merge -p '{"metadata":{"labels":{"status":"deployed"}}}'


CODEOWNER File for description of command responsibility areas Example from GitLab Structure - groupCompany - project-workspace-1 - project-1 - project-2 - project-3 - project-workspace-N - project-1 - project-N - maintainers - frontend - backend - database - etc... Link GitLab GitLab CODEOWNERS config


Container Storage Interface (CSI) Docs What is The Container Storage Interface (CSI)? Official docs [RU] Понимаем Container Storage Interface (в Kubernetes и не только) Example csi-driver-host-path - a sample (non-production) CSI Driver that creates a local directory as a volume on a single node csi-digitalocean - A Container Storage Interface (CSI) Driver for DigitalOcean Block Storage csi-digitalocean has a more friendly year.

Uuid as Kp

UUID as KP #762 Docs UUID or GUID as Primary Keys? Be Careful! Primary Keys: IDs versus GUIDs UUID vs. Sequences MySQL MySQL 8.0.13: Default Value as uuid PostgreSQL Default value for UUID column in Postgres

Awesome Tool

Agreement Semantic Versioning 2.0.0 Golang Queue ants is a high-performance and low-cost goroutine pool in Go, inspired by fasthttp Kubernetes Tool krew manager plugin for kubectl Monitoring Prometheus Thanos - Open source, highly available Prometheus setup with long term storage capabilities. gRPC grpc_cli - gRPC CLI Docs mkdocs material-theme