Skip to content

Instantly share code, notes, and snippets.

View shan27nov's full-sized avatar

Shan Abdiel J shan27nov

2 followers · 1 following
View GitHub Profile
@shan27nov
shan27nov / PG HA on GCE.md
Created March 21, 2022 09:27 — forked from akhdaniel/PG HA on GCE.md

Objectives

  • Set up two Compute Engine instances running Postgres.
  • Create a new table for a guestbook app.
  • Configure the primary server.
  • Back up the primary server to the standby server.
  • Configure the standby server to run in Hot Standby mode.
  • Start the standby server and test it.

Creating the guestbook table on Primary Server

@shan27nov
shan27nov / PostgreSQL HA on Kubernetes.md
Created March 21, 2022 09:26 — forked from akhdaniel/PostgreSQL HA on Kubernetes.md
PostgreSQL HA on Kubernetes

PostgreSQL High Availibility on Kubernetes

  • Installation
  • Create PostgreSQL Cluster
  • Connect to a PostgreSQL Cluster
    • psql
    • pgAdmin
  • Updating PostgreSQL Cluster
  • High Availability
@shan27nov
shan27nov / PostgreSQL Clustering CITUS.md
Created March 21, 2022 09:23 — forked from akhdaniel/PostgreSQL Clustering CITUS.md
PostgreSQL Clustering CITUS

Install Steps on Worker:

curl https://install.citusdata.com/community/deb.sh | sudo bash

sudo apt-get -y install postgresql-13-citus-10.0

sudo pg_conftool 13 main set shared_preload_libraries citus
@shan27nov
shan27nov / nginx-tuning.md
Created March 18, 2021 09:38 — forked from denji/nginx-tuning.md
NGINX tuning for best performance

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.