Pinned Loading

1. getting count of 4xx and 5xx logs fr... getting count of 4xx and 5xx logs from the logs file

   1

   # logs-generate

   2

   3

   For generating apache logs used https://github.com/mingrammer/flog

   4

   5

   ```

2. prometheus needed disk space calcula... prometheus needed disk space calculation based on number of samples ingested and calculating bytes per sample alongwith retention period

   1

   ### query to calculate the storage space required for Prometheus

   2

   ```

   3

   1296000 * (rate(prometheus_tsdb_head_samples_appended_total[1d]) *

   4

   (rate(prometheus_tsdb_compaction_chunk_size_bytes_sum[1d]) / rate(prometheus_tsdb_compaction_chunk_samples_sum[1d])))

   5

   ```

3. Commands for backup and restore of m... Commands for backup and restore of mysql database

   1

   ##### For backup of all databases,

   2

   ```bash

   3

   mysqldump -u <DB_USER> -p --all-databases --host <DB_HOST> -P <DB_PORT> > <PATH_FOR_FILE>.sql

   4

   ```

   5

4. Commands for backup and restore of p... Commands for backup and restore of postgresql database

   1

   ##### For backup,

   2

   ```bash

   3

   pg_dump -W -U <DB_USERNAME> <DB_NAME> -h <DB_HOST> -p <DB_PORT> --no-owner > <PATH_FOR_FILE>.sql

   4

   ```

   5

5. Safely cordon, drain and delete nodes Safely cordon, drain and delete nodes

   1

   To cordon a node,

   2

   ```bash

   3

   kc cordon <node-name>

   4

   ```

   5