YouSysAdmin

#!/bin/sh
# you might want to add some user authentication here
mysql -e "show variables; show status" | awk '  
{
VAR[$1]=$2  
}
END {  
MAX_CONN = VAR["max_connections"]  
MAX_USED_CONN = VAR["Max_used_connections"]  
BASE_MEM=VAR["key_buffer_size"] + VAR["query_cache_size"] + VAR["innodb_buffer_pool_size"] + VAR["innodb_additional_mem_pool_size"] + VAR["innodb_log_buffer_size"]  

YouSysAdmin

// Database Information about RDS instance
type Database struct {
	// Database identifier
	Identifier string
	// Database ARN
	Arn string
	// Database engine (mysql2, postgres, etc.)
	Engine string
	// Database engine version
	EngineVersion string

YouSysAdmin

/**
* Find the amount of auto-increment "space" has been used. This may can help identify
* tables that are running out of available ID values.
*/
SELECT
	t.table_name,
	t.column_name,
	-- The highest possible ID that can be created with this data-type.
	t.max_value,
	-- The last ID created in this table.

YouSysAdmin

colors:
  # Default colors
  primary:
    background: '0x1e2127'
    foreground: '0xabb2bf'

    # Bright and dim foreground colors
    #
    # The dimmed foreground color is calculated automatically if it is not present.

YouSysAdmin

# Context: 
# make sure the URL is valid, and Docker 18.09 or later is installed on the remote host.
# zsh:1: command not found: docker

# Add /usr/local/bin to PATH for SSH session
echo 'PATH=/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin' >> ~/.ssh/environment

# Permit set user environment for SSH session
sudo sh -c 'echo "PermitUserEnvironment PATH" >> /private/etc/ssh/sshd_config'

YouSysAdmin

YubiKey 4 series GPG and SSH setup guide

Written for fairly adept technical users, preferably of Debian GNU/Linux, not for absolute beginners.

You'll probably be working with a single smartcard, so you'll want only one primary key (1. Sign & Certify) and two associated subkeys (2. Encrypt, 3. Authenticate). I've published a Bash function which automates this slightly special key generation process.

YouSysAdmin

#!/bin/sh

# Author: YouSysAdmin

awk '
BEGIN{
  Y1="\033[93m"       # light yellow
  Y2="\033[33m"       # dark yellow
  B1="\033[94m"       # dark blue
  B2="\033[96m"       # blue

YouSysAdmin

Installing Arch Linux with Full Disk Encryption

If you're aiming for a seamless Arch Linux installation in UEFI mode, follow along as this guide will walk you through the process step by step. We'll be using LUKS (Linux Unified Key Setup) and LVM (Logical Volume Manager) partitions on LUKS to achieve full disk encryption.

Note: I have updated this doc for UEFI mode. For those with BIOS/MBR systems, you can refer to the previous version, but keep in mind that it might be outdated and no longer accurate.

If you're only interested in installing Linux and not setting up dual boot with Windows, feel free to skip the Windows-related sections.

YouSysAdmin

Install ARCH Linux with encrypted file-system and UEFI

---

This guide was originally taken from: https://gist.github.com/mattiaslundberg/8620837 and updated to markdown as well as adding desktop and wireless setup

Download the archiso image from https://www.archlinux.org/ Use etcher to create USB drive: https://etcher.io/

YouSysAdmin

Arrows

→ ← ↑ ↓ ↔ ↕ ⇒ ⇐ ⇄ ⇆ ↩ ↪ ⤴ ⤵ ➜ ➔ ▸ ◂ ▴ ▾ » « › ‹

Chevrons / triangles (toggles, menus)

▶ ▼ ◀ ▲ ▷ ▽ ◁ △ ⌃ ⌄ ⌅ ⌆ ⏵ ⏷

Status / check / cross