# sudo add-apt-repository ppa:wireguard/wireguard
# sudo apt-get update
# sudo apt-get install wireguard
| This is a quick brain dump to hopefully help explain the other files here. | |
| /etc/network/interfaces is from my working proxmox install with an overly complicated VLAN setup. All configuration is | |
| based off a forum post by x307 which I have copied here for reference. | |
| My server has 2 sets of NICs hooked up to 2 seperate switches, my main switch runs traffic for management, applications, | |
| and general home devices. I have a seperate swtich for SAN and Corosync traffic. | |
| eno1 & eno2 are onboard NICs that are teamed in a LAG to the main switch. Proxmox has an IP address on VLAN 10 for | |
| management, VMs can then access VLANs 1, 10, 20 and 999 through the LAG as needed (home, management, applications and |
| #!/bin/sh -eu | |
| # | |
| # Delete a VPC and its dependencies | |
| if [ -z "$1" ] then | |
| echo "usage: $0 <vpcid>" | |
| exit 64 | |
| fi | |
| vpcid="$1" |
| #!/usr/bin/env bash | |
| # Purpose: batch image resizer | |
| # Source: https://guides.wp-bullet.com | |
| # Author: Mike | |
| # absolute path to image folder | |
| FOLDER="images" | |
| # max height | |
| HEIGHT=800 |
| fajok = { | |
| '1': {'name': 'bogarak', 'value': []}, | |
| '2': {'name': 'emberek', 'value': ["Arpi", "Berni"]}, | |
| '3': {'name': 'allatok', 'value': ["Hamu", "Negro"]}, | |
| '4': {'name': 'emlosok', 'value': []}, | |
| } | |
| for f in fajok: | |
| print(f, '----', fajok[f]['name']) |
| import os | |
| def create_dir(path): | |
| if not os.path.exists(path): | |
| os.makedirs(path) |
| #!/bin/bash | |
| PHP_VERSION=$1 | |
| WORKDIR=$(pwd) | |
| DOWNLOAD_FILE="php-$PHP_VERSION.tar.gz" | |
| TAR_OUT_DIR="$WORKDIR/php-src-php-$PHP_VERSION" | |
| curl -O -L https://github.com/php/php-src/archive/$DOWNLOAD_FILE | |
| tar -zxvf "$WORKDIR/$DOWNLOAD_FILE" |
| class User: | |
| def __init__(self, name): | |
| self.name = name | |
| class Position: | |
| def __init__(self): | |
| self._position = [] | |
| def __getitem__(self, item) -> User: |
This focuses on generating the certificates for loading local virtual hosts hosted on your computer, for development only.
Do not use self-signed certificates in production ! For online certificates, use Let's Encrypt instead (tutorial).
Each query in MySQL is running as its own transaction, assuming you didn't change this default configuration, and unless you're starting a transaction manually and running multiple deletes in that one transaction.
Because every query is a transaction, MySQL has to save the data being deleted in case of a rollback. Large deletes means saving a TON of data for that potential case.
Additionally, deletes cause a LOT of writes to the binary log. When the delete completes, the query/results of the delete are committed to the binary log,