MattHealy

To kill stuck processes

select group_concat(concat('KILL ',id,';') separator ' ')
from information_schema.processlist
where Time>'100' and Info like 'select %';

To kill sleeping processes and allow alter table to occur

select group_concat(concat('KILL ',id,';') separator ' ')
from information_schema.processlist

MattHealy

import boto3
import csv
import calendar
from datetime import date, datetime, timedelta
from collections import OrderedDict

client = boto3.client('apigateway')


endDate = date(year=2023, month=3, day=31)

MattHealy

import boto3
import csv

client = boto3.client('route53domains', region_name='us-east-1')

fieldnames = [
    'Domain Name',
    'Domain Registrar',
    'Expiration Date',
    'Auto-Renewal',

MattHealy

import boto3
import csv


client = boto3.client('ec2')
regions = [region['RegionName'] for region in client.describe_regions()['Regions']]

fieldnames = [
    'Certificate',
    'Common Name',

MattHealy

import boto3
import argparse

parser = argparse.ArgumentParser()

parser.add_argument(
    '--repo', metavar='repo', type=str,
    help='Optionally filter by repository')

args = parser.parse_args()

MattHealy

#!/bin/sh
PORT=80
HP=:$PORT
echo 'Checking to see if Apache is up...'
if ( /usr/sbin/lsof -Pni $HP | grep "$PORT (LISTEN)" 2>&1 >/dev/null ); then
  echo 'Apache is up';
else
  echo 'Apache is down, restarting...';
  /sbin/service httpd restart
  logger -p mail.info apache_check_restart.sh restarting Apache

MattHealy

import boto3
from datetime import date, timedelta

endDate = date.today()
startDate = endDate - timedelta(days=7)
tempDate = startDate

days = []
while tempDate <= endDate:
    days.append(tempDate)

MattHealy

#!/bin/bash

oldconfigname="$1"
newconfigname="$2"
ami="$3"

KEYNAME="my_keypair_name"
ASGROUP="my_autoscaling_group_name"
SECURITYGROUP="sg-1234"
INSTANCETYPE="t2.micro"

MattHealy

<?php

// HMAC-SHA512 signing

function get_signature($event, $orderid, $listing_id) {

    // Hashing algorithm to use
    $algo = 'sha512';

    // Shared key used for signing payloads

MattHealy

#!/bin/bash
ADDRESS=`aws ec2 describe-instances --filters 'Name=tag:Name,Values=WebServer' --output text --query 'Reservations[*].Instances[*].PrivateIpAddress'`
ssh ec2-user@$ADDRESS