Eduardo Ramos duderamos

duderamos / mysql_rename_db.sh

Created June 16, 2016 00:32

Rename MySQL database

	#!/bin/bash
	#
	# Source: http://serverfault.com/a/369430

	mysqlconn="mysql -u XXX -p XXX"
	olddb=XXX
	newdb=XXX

	table_names=$($mysqlconn -N -e "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='${olddb}'")

duderamos / unicorn.service

Last active January 1, 2017 22:20

Unit file for unicorn

	[Unit]
	Description=Unicorn Server
	Requires=redis.service
	Wants=mysqld.service postgresql.service
	After=redis.service mysqld.service postgresql.service

	[Service]
	Type=forking
	User=netengine
	WorkingDirectory=/var/www/unicorn/current

duderamos / delayed_job.service

Created January 1, 2017 19:38

Systemd unit file for delayed_job

	[Unit]
	Description=delayed_job
	After=syslog.target
	After=postgresql.service

	[Service]
	Type=forking
	User=netengine
	Environment=RAILS_ENV=production
	WorkingDirectory=/var/www/unicorn/current

duderamos / puma.service

Created February 12, 2017 22:50

	[Unit]
	Description=Puma Server

	[Service]
	Type=forking
	User=netengine
	WorkingDirectory=/var/www/puma/current
	Environment=RAILS_ENV=staging
	SyslogIdentifier=puma
	PIDFile=/var/www/puma/current/tmp/pids/puma.pid

duderamos / mysql-commands.md

Last active July 26, 2021 05:16

MySQL commands

show table status from <database>;

duderamos / letsencrypt-renewal-systemd-units

Created May 23, 2017 23:39

	# letsencrypt.service
	[Unit]
	Description=Renew Letsencrypt certificates

	[Service]
	Type=simple
	ExecStart=/usr/bin/letsencrypt renew -n --no-self-upgrade

	# letsencrypt.timer
	[Unit]

duderamos / font-autosizing.html

Created July 2, 2017 17:45

	<!DOCTYPE html>
	<head>
	<title>autosizing</title>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
	<style>
	div { border: 1px solid #aaa; }
	.w70 { width: 70%; }
	.w20 { width: 20%; }
	</style>
	</head>

duderamos / single-process.sh

Last active September 27, 2017 01:20

	# If a second instance of this script starts, it won't run the command and exit with 1.
	flock -n /tmp/.process-name.lock <long command with args here>

duderamos / get-mysql-table-sizes.sql

Created October 12, 2017 01:02

	SELECT
	table_name AS `Table`,
	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
	FROM information_schema.TABLES
	WHERE table_schema = "$DB_NAME"
	AND table_name = "$TABLE_NAME";

duderamos / auth0-rule

Created January 23, 2018 07:14

	function (user, context, callback) {
	var namespace = 'https://example.com/';
	context.idToken[namespace + 'first_name'] = user.user_metadata.first_name;
	context.idToken[namespace + 'last_name'] = user.user_metadata.last_name;
	context.idToken[namespace + 'mobile_number'] = user.user_metadata.mobile_number;
	context.idToken[namespace + 'organizations_name'] = user.user_metadata.organizations_name;
	callback(null, user, context);
	}