Skip to content

Instantly share code, notes, and snippets.

View adeubank's full-sized avatar
🌳

Allen Eubank adeubank

🌳
View GitHub Profile
@adeubank
adeubank / wordpress-wp-super-cache.conf
Created August 17, 2015 20:03
Wordpress Super Cache nginx configuration
# WP Super Cache rules.
# Designed to be included from a 'wordpress-ms-...' configuration file.
set $cache_uri $request_uri;
# POST requests and urls with a query string should always go to PHP
if ($request_method = POST) {
set $cache_uri 'null cache';
}
@adeubank
adeubank / ffmpg_gen_thumb.sh
Created November 27, 2021 20:31
Generate 1 thumbnail from a video at timestamp
ffmpeg -i input.mp4 -ss 00:00:00.000 -vframes 1 output.png
@adeubank
adeubank / aws-autoscaling-ec2-ssh-and-command.sh
Last active October 20, 2021 14:38
Boilerplate for running an ssh command across EC2 instances in an AutoScalingGroup. Check disk status on EC2 instances in an Autoscaling group name.
ASG_NAME=myautoscalinggroup
for ID in $(aws autoscaling describe-auto-scaling-instances --query 'AutoScalingInstances[?AutoScalingGroupName==`$ASG_NAME`].InstanceId' --output text);
do
IP=$(aws ec2 describe-instances --instance-ids $ID --query 'Reservations[].Instances[].PublicIpAddress' --output text)
ssh -q -o "StrictHostKeyChecking no" -i ec2.pem ec2-user@$IP 'echo $(hostname): $(df -h | grep /dev/nvme1n1)'
done
@adeubank
adeubank / mount_nvme1n1.sh
Created May 28, 2021 18:51
This script will make a filesystem and mount a nvme1n1 device and modify the /etc/fstab for remounts on reboot -
# This script will make a filesystem and mount the device and modify the /etc/fstab for remounts on reboot -
#!/bin/bash
if ( lsblk | fgrep -q nvme1n1 ); then
mkfs.ext4 /dev/nvme1n1
mkdir -p /ephemeral1
mount /dev/nvme1n1 /ephemeral1
@adeubank
adeubank / PostAdLibertasAudienceReportingWebhook.http
Last active May 20, 2021 22:51
An example AdLibertas API request to import an event into Audience Reporting. Reach out to your account manager for your Webhook URL and Authentication Token.
POST http://publicapi.adlibertas.com/v1/webhooks/events/12345_your_webhook_id
Authorization: Basic you_adlibertas_auth_token
Content-Type: application/json
{
"event": {
"id": "your_unique_event_id",
"event_date": "20210519",
"event_timestamp": 1621459749000000,
"event_name": "event_name_b637",
@adeubank
adeubank / config.properties
Last active March 29, 2021 22:21
Trino worker properties for r5.4xlarge instance cluster. These should be the same on the coordinator and worker. https://trino.io/docs/current/admin/properties.html
-Dexchange.client-threads=50
-Dexchange.concurrent-request-multiplier=16
-Dexchange.max-buffer-size=4GB
-Dexchange.max-response-size=512MB
-Dnode-scheduler.max-splits-per-node=1000
-Dnode-scheduler.max-pending-splits-per-task=50
-Dquery.max-memory=140GB
-Dshutdown.grace-period=45s
-Dsink.max-broadcast-buffer-size=2GB
-Dsink.max-buffer-size=1GB
@adeubank
adeubank / Vagrantfile
Created December 21, 2015 23:49
Vagrantfile for setting up Ubuntu 14.04 with Java 8 and Tomcat 8
# -*- mode: ruby -*-
# vi: set ft=ruby :
# All Vagrant configuration is done below. The "2" in Vagrant.configure
# configures the configuration version (we support older styles for
# backwards compatibility). Please don't change it unless you know what
# you're doing.
Vagrant.configure(2) do |config|
# The most common configuration options are documented and commented below.
# For a complete reference, please see the online documentation at
ironsource inventory reports CSV file for 2020-01-14
can i process this file?
am i already processing an admob file?
am i processing a mopub config file?
download CSV file (FileImporter)
truncate stage table
@adeubank
adeubank / selenium
Last active August 1, 2019 17:25
Set up selenium on Ubuntu 16.04 as a service
#!/bin/bash
case "${1:-''}" in
'start')
if test -f /tmp/selenium.pid
then
echo "Selenium is already running."
else
export DISPLAY=localhost:99.0
java -Dwebdriver.gecko.driver="/usr/lib/geckodriver/geckodriver" -jar /usr/lib/selenium/selenium-server-standalone.jar -port 4444 > /var/log/selenium/output.log 2> /var/log/selenium/error.log & echo $! > /tmp/selenium.pid
@adeubank
adeubank / select_dates_between_two_dates.sql
Created September 4, 2018 15:32
Select all days between two dates
select * from
(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v
where selected_date between '2018-07-01' and curdate()