Ilya Rogojin ijin82

Create the directory for the new instance

$ sudo install -o redis -g redis -d /var/lib/redis2

Create a new configuration file

$ sudo cp -p /etc/redis/redis.conf /etc/redis/redis2.conf

Config Telegrambot for grafana's alerts.

1. Create bot

Open Telegram and search for @BotFather user and message them the following:

You
/newbot 

BotFather

VirtualBox, additional disk for MySQL

Open VirtualBox
File - Virtual Media Manager
Create - VDI - Dynamically Allocated - set path & size (60Gb good enough for us) - close
Stop your target VM
Go to VM settings (right click on VM)
Storage - Controller SATA - press plus icon "Add new storage attachment" - Hard disk
Choose your pre-created VDI disk - that have to appear as attached after addition
Start your target VM - Login to your VM (vagrant up - vagrant ssh)

Fix broken colors in screen (screen-256color $TERM)

Original solution

https://bbs.archlinux.org/viewtopic.php?id=67464

Fix

# use "term xterm-256color" in .screenrc
> infocmp -L xterm-256color > temp.terminfo
> vim temp.terminfo
# remove "back_color_erase," from second or third line

	#!/bin/bash

	# Optional variables for a backup script
	MYSQL_USER="root"
	MYSQL_PASS="secret"
	BACKUP_DIR=./$(date +%Y-%m-%d_%H%M%S);
	test -d "$BACKUP_DIR" \|\| mkdir -p "$BACKUP_DIR"

	# Get the database list
	for db in $(mysql -B -s -u $MYSQL_USER --password=$MYSQL_PASS -e 'show databases')

	#!/bin/bash

	## config
	backupFoldersList="
	/home/user/projects/project-name
	"
	backupDstFolder="/home/user/projects-dump"
	## /config

	targetFolder="dump-$(date +%Y-%m-%d_%H%M%S)"

	package main

	import (
	"github.com/elazarl/goproxy"
	"github.com/elazarl/goproxy/ext/auth"
	"log"
	"net/http"
	"flag"
	)

	### Requires 7-zip https://www.7-zip.org/
	###
	### Windows scheduler task (as hidden daily job):
	### Execute: powershell.exe
	### Argument: -WindowStyle Hidden "L:\Backups\Backup-7z.PS1"

	##########################################################
	####################### Config ###########################

	### 7-zip exe file path

	## Administrator powershell console needed

	##
	## Install choco: https://chocolatey.org/install
	## Packages: https://chocolatey.org/packages
	## List all installed: choco list --local-only
	## Upgrade all installed: choco upgrade all
	##

	##

	extension=php_pdo_sqlsrv_73_nts.so
	extension=php_sqlsrv_73_nts.so