shyamvyas5

For backup,

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

For backup of database with INSERT statements in the dump file instead of COPY statements,

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

shyamvyas5

For backup of all databases,

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

For backup of a specific database,

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

shyamvyas5

To cordon a node,

kc cordon <node-name>

To drain a node,

kc drain --force --ignore-daemonsets --delete-emptydir-data --grace-period=30 <node-name>

shyamvyas5

logs-generate

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

flog > apache.log

For generating nginx logs used https://github.com:kscarlett/nginx-log-generator

shyamvyas5

query to calculate the storage space required for Prometheus

1296000 * (rate(prometheus_tsdb_head_samples_appended_total[1d]) *
(rate(prometheus_tsdb_compaction_chunk_size_bytes_sum[1d]) / rate(prometheus_tsdb_compaction_chunk_samples_sum[1d])))

1296000 = retention period in seconds(15 days here)

shyamvyas5

# config file for ansible -- http://ansible.com/
# ==============================================

# nearly all parameters can be overridden in ansible-playbook 
# or with command line flags. ansible will read ANSIBLE_CONFIG,
# ansible.cfg in the current working directory, .ansible.cfg in
# the home directory or /etc/ansible/ansible.cfg, whichever it
# finds first

[defaults]