Discover gists

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

This emulate's vim's <C-e> and <C-y> for scrolling in VSCode using the macros extension.

add the following to settings.json

"macros": {
  "scrollLineDownFaster": [
 "scrollLineDown",

Complete Recent Discord Quest

Note

This no longer works in browser!

Note

This no longer works if you're alone in vc! Somebody else has to join you!

How to use this script:

Accept the quest under User Settings -> Gift Inventory

Linux System Metrics

CPU

system.cpu.idle: % Idle CPU
system.cpu.system: % System CPU
system.cpu.user: % User CPU

Disk

58 bytes of CSS to look great nearly everywhere

When making this website, i wanted a simple, reasonable way to make it look good on most displays. Not counting any minimization techniques, the following 58 bytes worked well for me:

main {
  max-width: 38rem;
  padding: 2rem;
  margin: auto;
}

Thunderbolt Networking

this gist is part of this series

NOTE FOR THIS TO BE RELIABLE ON NODE RESTARTS YOU WILL NEED PROXMOX KERNEL 6.2.16-14-pve OR HIGER

This fixes issues i bugged with the thunderbolt / thunderbolt-net maintainers (i will take everyones thanks now, lol)

Install LLDP - this is great to see what nodes can see which.

install lldpctl with apt install lldpd

This (and related gists) captures how i created my docker swarm architecture. This is intended mostly for my own notes incase i need to re-creeate anything later! As such expect some typos and possibly even an error...

Installation Step-by-Step

Each major task has its own gist, this is to help with maitainability long term.

Performance Mods

A list of performance-enhancing mods for 1.8.9 and below.

Any suggestions/complaints?
Join our discord or use the gist comments.

Mods marked as "Dangerous" might be unstable, and cause some unexpected behaviour.

	import React from 'react'

	type DropzoneContextValue = {
	isDragging: boolean
	}

	const DropzoneContext = React.createContext<DropzoneContextValue \| undefined>(
	undefined
	)

	MP4 TO MP4 (MEDIUM)
	ffmpeg -i input.mp4 -b 1000000 output.mp4

	M2TS TO MP4
	ffmpeg -i input.m2ts -vcodec libx264 -crf 20 -acodec ac3 -vf "yadif" output.mp4

	MP4 TO WEBM (HIGH)
	ffmpeg -i input.mp4 -aq 5 -ac 2 -qmax 25 -threads 2 output.webm
	ffmpeg -i input.mp4 -c:v libvpx-vp9 -crf 30 -b:v 0 -b:a 128k -c:a libopus output.webm