https://www.gravatar.com/avatar/e2eb2a78a67a1736e656f716f2cb5e65?s=240&d=mp

Postgres

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: https://github.com/batazor/shortlink/tree/main/ops/Helm/tooling $> kubectl proxy Starting to serve on 127.0.0.1:8001 $> 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 http://127.0.0.1:8001/api/v1/namespaces/istio-system/finalize Helm upgraid-faild $> kubectl -n app-namespace patch secret release-name.v123 --type=merge -p '{"metadata":{"labels":{"status":"deployed"}}}'

Codeowner

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

Csi

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