berkayunal’s gists

berkayunal / isimler.sql

Created November 25, 2011 04:50 — forked from ismailbaskin/turkce_isimler.sql

isim sözlüğü

	CREATE TABLE `isimler` (
	`id` int(10) NOT NULL AUTO_INCREMENT,
	`ad` varchar(255) COLLATE utf8_bin NOT NULL,
	`cinsiyet` varchar(50) COLLATE utf8_bin NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `ad` (`ad`),
	KEY `cinsiyet` (`cinsiyet`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

berkayunal / mavericks.bootable.iso.sh

Last active August 29, 2015 14:20

	#!/usr/bin/env bash

	# Original: http://thezinx.com/2013/10/29/create-bootable-dmg-iso-mavericks-app.html

	V_BUILD=/Volumes/install_build
	V_APP=/Volumes/install_app
	T_SI_B=/tmp/mavericks

	T_SI=$T_SI_B.sparseimage

berkayunal / .htaccess

Created August 15, 2016 21:40 — forked from THEtheChad/.htaccess

Access-Control-Allow-Origin for Subdomains

	SetEnvIf Origin "^(.*\.example\.com)$" ORIGIN_SUB_DOMAIN=$1
	Header set Access-Control-Allow-Origin "%{ORIGIN_SUB_DOMAIN}e" env=ORIGIN_SUB_DOMAIN

berkayunal / warm_varnish

Created October 13, 2016 21:37 — forked from jaseclamp/warm_varnish

Warm Varnish Cache

	#!/bin/bash

	# this script will
	# a. crawl the designated site X levels deep to generate a urls list
	# b. completely purge all urls on the desisgnated varnish servers for the designated url
	# c. clear cache on nginx / mod pagespeed for the designated app servers
	# d. individually warm all the listed urls on each designated varnish server
	# e. rewarm them in case pagespeed sent a purge request

	# define some variables

berkayunal / default.vcl

Created October 13, 2016 22:15 — forked from joshangell/default.vcl

Varnish config for Craft

	# Varnish 4.0 configuration for Craft
	#
	# Based on the following:
	# - https://github.com/mattiasgeniar/varnish-4.0-configuration-templates/blob/master/default.vcl
	# - https://gist.github.com/aelvan/eba03969f91c1bd51c40

	vcl 4.0;

	import std;
	import directors;

berkayunal / ubuntu_unattended_upgrades_gmail.markdown

Created November 4, 2016 13:34 — forked from dwilkie/ubuntu_unattended_upgrades_gmail.markdown

Setup unattended upgrades on Ubuntu with Gmail

Install the unattended-upgrades package

$ sudo apt-get install unattended-upgrades

$ sudo nano /etc/apt/apt.conf.d/10periodic

berkayunal / mysql_splitdump.sh

Created January 3, 2017 08:07 — forked from jasny/mysql_splitdump.sh

Split MySQL dump SQL file into one file per table or extract a single table

	#!/bin/bash

	####
	# Split MySQL dump SQL file into one file per table
	# based on http://blog.tty.nl/2011/12/28/splitting-a-database-dump
	####

	if [ $# -lt 1 ] ; then
	echo "USAGE $0 DUMP_FILE [TABLE]"
	exit

berkayunal / redis.service

Created February 10, 2017 01:19 — forked from ordoghl/redis.service

redis systemd unit file

	Description=Redis In-Memory Data Store
	After=network.target

	[Service]
	Type=forking
	User=redis
	Group=redis
	Environment=statedir=/run/redis
	PermissionsStartOnly=true
	PIDFile=/run/redis/redis.pid

berkayunal / migrate.sh

Created February 16, 2017 21:34 — forked from dj1020/migrate.sh

Upgrade MAMP to Mysql 5.7 tested by Ken Lin 2015/11/09

	#!/bin/sh

	wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.9-osx10.10-x86_64.tar.gz
	tar xfvz mysql-5.7*

	echo "stopping mamp"
	sudo /Applications/MAMP/bin/stop.sh
	sudo killall httpd mysqld

	echo "creating backup"

berkayunal / redis-server

Created March 28, 2017 12:11 — forked from sumodirjo/redis-server

redis-server init script

	#! /bin/sh
	### BEGIN INIT INFO
	# Provides: redis-server
	# Required-Start: $syslog $remote_fs
	# Required-Stop: $syslog $remote_fs
	# Should-Start: $local_fs
	# Should-Stop: $local_fs
	# Default-Start: 2 3 4 5
	# Default-Stop: 0 1 6
	# Short-Description: redis-server - Persistent key-value db