trongnghia203

NGINX 1.10 + APACHE 2.4 real IP for reverse proxy

Edit nginx conf

default.conf or what you want

vim /etc/nginx/conf.d/default.conf

add proxy_set_header for php files

trongnghia203

List of sites with free tier limits

• Docker Hub - One private repo/image spot for free
• Three Scale - Very generous free tier 50GB of space, 500 Pulls a month etc..
• Canister - 20 private repos with almost no limits on free tier
• Code Fresh - Free tier for developers

Setup your own private registry

• Setup Private Docker Registry - Digital Ocean hosted Tutorial

trongnghia203

/**
 * Retrieves all the rows in the active spreadsheet that contain data and logs the
 * values for each row.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function readRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

trongnghia203

Electron apps

• Marp: Markdown presentation ecosystem.

• muryoimpl/slippr: markdown presentation app by Electron

• joe-re/cafe-pitch Markdown-driven presentation tool built on Electron.

Slide deck frameworks supporting Markdown source

trongnghia203

LInux

Three system configuration parameters must be set to support a large number of open files and TCP connections with large bursts of messages. Changes can be made using the /etc/rc.d/rc.local or /etc/sysctl.conf script to preserve changes after reboot.

1. /proc/sys/fs/file-max: The maximum number of concurrently open files.

fs.file-max = 1000000

2. /proc/sys/net/ipv4/tcp_max_syn_backlog: Maximum number of remembered connection requests, which are still did not receive an acknowledgment from connecting client. The default value is 1024 for systems with more than 128Mb of memory, and 128 for low memory machines.

net.ipv4.tcp_max_syn_backlog = 3240000

3. /proc/sys/net/core/somaxconn: Limit of socket listen() backlog, known in userspace as SOMAXCONN. Defaults to 128.

net.core.somaxconn = 3240000

trongnghia203

#!/bin/bash

DATE=`date +"%Y%m%d_%H%M"`
BK_DEST="/onedrive/"
NUMBER_OF_BACKUPS=30

DATABASES=$(mysql -sN -e 'show databases' | grep db_)

cd /tmp

trongnghia203

SSH agent forwarding and screen

When connecting to a remote server via SSH it is often convenient to use SSH agent forwarding so that you don't need a separate keypair on that server for connecting to further servers.

This is enabled by adding the

ForwardAgent yes

option to any of your Host entries in ~/.ssh/config (or alternatively with the -A option). Don't set this option in a wildcard Host * section since any user on the remote server that can bypass file permissions can now als use keys loaded in your SSH agent. So only use this with hosts you trust.

trongnghia203

Setup a Masterless Puppet Environment

Setup Puppet Masterless

trongnghia203

Backup mysql

Usage:

Create a cron job

crontab -e

Add following lines

trongnghia203

Pyenv

Install Multiple Python Versions for Specific Project

• Home project: https://github.com/pyenv/pyenv

• Reference to: https://www.tecmint.com/pyenv-install-and-manage-multiple-python-versions-in-linux/

1. Install pyenv in Linux