khanhtran3005

pt-kill user must have SUPER PROCESS permission.

The following command intends to kill queries which have execute time greater than 30s and save terminated queries to database.

pt-kill --host=localhost --user=pt_kill_user --password=pt_kill_pass \
--busy-time=30 --interval=5s \
--log-dsn=h=localhost,D=pt_kill,t=kill_log,P=3306,u=root,p=root \
--kill --daemonize --ignore-user=backup

NigelEarle

Migrations & Seeding

What are migrations??

Migrations are a way to make database changes or updates, like creating or dropping tables, as well as updating a table with new columns with constraints via generated scripts. We can build these scripts via the command line using knex command line tool.

To learn more about migrations, check out this article on the different types of database migrations!

Creating/Dropping Tables

hmain

/* Create a database in Athena */
CREATE DATABASE s3_AccessLogsDB;

/*
Create a table within the Athena database
Replace s3://MY_S3_BUCKET/ with your S3 bucket 
which has the access logs you want to query
*/ 
CREATE EXTERNAL TABLE IF NOT EXISTS s3_AccessLogs.Accesslogs(
  BucketOwner string,

a7madgamal

FINALLY no need for tricks!

bonus tip: for more darkness > https://darkreader.org/

tdsymonds

// For the below to work with the escape key
// I needed to add data-keyboard="false" to the modal
// in the HTML so that the standard bootstrap function
// doesn't fire, the below fires instead

$('div.modal').on('show.bs.modal', function() {
    var modal = this;
    var hash = modal.id;
    window.location.hash = hash;
    window.onhashchange = function() {

caraboides

#!/bin/sh
set -e
HOST=localhost
DB=test-entd-products
COL=asimproducts

S3PATH="s3://mongodb-backups-test1-entd/$DB/$COL/"
S3BACKUP=$S3PATH`date +"%Y%m%d_%H%M%S"`.dump.gz
S3LATEST=$S3PATH"latest".dump.gz
/usr/bin/aws s3 mb $S3PATH

justjanne

Server Price Breakdown: DigitalOcean, Amazon AWS LightSail, Vultr, Linode, OVH, Hetzner, Scaleway/Online.net:

Permalink: git.io/vps

$5/mo

Provider	Type	RAM	Cores	Storage	Transfer	Network	Price

charity

#!/bin/bash

# Usage: ./init.sh once to initialize remote storage for this environment.
# Subsequent tf actions in this environment don't require re-initialization, 
# unless you have completely cleared your .terraform cache.
#
# terraform plan  -var-file=./production.tfvars 
# terraform apply -var-file=./production.tfvars 

tf_env="production"

Epigene

Inspired by jubalm's version

Index

1. Setting up the app for dokku deploys

2. Setting up Dokku Droplet configuration

3. Deploying

4. Post-deploy configuration

5. Troubleshooting

bsingr

daemon off;

error_log /dev/stderr warn;

worker_processes 4;

events {
  worker_connections 1024;
  multi_accept on;
}