Skip to content

Instantly share code, notes, and snippets.

View sergeycherepanov's full-sized avatar
:bowtie:
Focusing

S.Cherepanov sergeycherepanov

:bowtie:
Focusing
View GitHub Profile
@sergeycherepanov
sergeycherepanov / ru_RU.lang
Last active August 14, 2017 17:46
cookingforblockheads
item.cookingforblockheads:recipeBookTier0.name=Кулинария для чайников
item.cookingforblockheads:recipeBookTier1.name=Кулинария для чайников I
item.cookingforblockheads:recipeBookTier2.name=Кулинария для чайников II
tooltip.cookingforblockheads:recipeBookTier0=#NoFilter Edition
tooltip.cookingforblockheads:recipeBookTier0.description=Показывает все рецепты продуктов.
tooltip.cookingforblockheads:recipeBookTier1=Книга рецептов
tooltip.cookingforblockheads:recipeBookTier1.description=Показывает еду, которую вы можете сделать из \nингредиентов, которые у вас есть в инвентаре.
tooltip.cookingforblockheads:recipeBookTier2=Ремесленная книга
tooltip.cookingforblockheads:recipeBookTier2.description=Можете создавать еду, используя то, \nчто у вас есть в вашем инвентаре.
@sergeycherepanov
sergeycherepanov / telegraf_pradam.com.conf
Last active July 31, 2017 12:51
http_response_alert.tick
stream
|from()
.database('telegraf')
.measurement('http_response')
.groupBy('server')
|where(lambda: "company" == 'pradam.com')
|alert()
.id('HTTPCHECK {{ index .Tags "server" }}')
.crit(lambda: "http_response_code" > 400)
.crit(lambda: "response_string_match" != 1)
@sergeycherepanov
sergeycherepanov / kubernetes.sh
Last active July 18, 2017 20:41
kubernetes on ubuntu xenial (16.04)
#!/bin/bash
# install tools
apt-get update && apt-get install -y apt-transport-https curl
# Setup kubernetes apt repository
curl -s https://packages.cloud.google.com/apt/doc/apt-key.gpg | apt-key add -
echo "deb http://apt.kubernetes.io/ kubernetes-xenial main" | tee /etc/apt/sources.list.d/kubernetes.list
# Install kubernetes
apt-get update
@sergeycherepanov
sergeycherepanov / dump.md
Last active January 26, 2017 15:58
full mysql dump without system db
MYSQLUSER='root' MYSQLPASSWORD='' MYSQLHOST='127.0.0.1' MYSQLPORT=3306; mysqldump -u$MYSQLUSER -p$MYSQLPASSWORD -h$MYSQLHOST -P$MYSQLPORT --databases `mysql --skip-column-names -u$MYSQLUSER -p$MYSQLPASSWORD -h$MYSQLHOST -P$MYSQLPORT -e "SELECT GROUP_CONCAT(schema_name SEPARATOR ' ') FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','performance_schema','information_schema');"` > dump.sql
@sergeycherepanov
sergeycherepanov / percona-server-5.7-armv7.md
Last active November 25, 2016 14:43
Percona Server 5.7 on ARM under Ubuntu 14.04 from source code

Percona Server 5.7 on ARM under Ubuntu 14.04 from source

Install dependencies

sudo apt-get -y install git wget cmake make dh-make gcc g++ \
libaio-dev libncurses5-dev libreadline-dev bison libboost-all-dev \
build-essential devscripts checkinstall

Install 1.59 libboost froum source

@sergeycherepanov
sergeycherepanov / elastic-stress-test.sh
Last active October 18, 2016 15:17
Elastic stress test script
#!/bin/bash
#
# Usage: bash <(curl https://gist.githubusercontent.com/SergeyCherepanov/a36b0f11c069070690505bc847950808/raw/57d4b6f1b30936be81f13f0200a9c015825da794/elastic-stress-test.sh)
#
python --version 2>&1 | grep '2.7' || {
apt-get update
apt-get install python2.7
}
pip --version || {
/usr/bin/python <(curl https://bootstrap.pypa.io/get-pip.py)
<domain type='kvm' xmlns:qemu='http://libvirt.org/schemas/domain/qemu/1.0'>
<!--
DONT FORGET TO ADD: /vm/osx-ovmf-bios-src-build/bios.bin IN APPARMOR PROFILE!
Host machine may need the following tweak for this to work, (it's will be reset after reboot)
echo 1 > /sys/module/kvm/parameters/ignore_msrs
Usb stick image with installer http://bit.ly/2dIhdy8
Archive with bioses: http://bit.ly/2djSmxR
qemu-system-x86_64 \
\
-rtc clock=vm,base=2016-01-01T16:01:21 \
\
-m 4096 \
-enable-kvm \
-name osxcapitan \
-cpu core2duo,vendor=GenuineIntel \
-rtc base=localtime \
-smbios type=2 \
@sergeycherepanov
sergeycherepanov / get_ssl_bundle.php
Last active September 30, 2016 17:01
Make ssl bundle from domain certificate
#!/usr/bin/env php
<?php
/**
* Usage: php ./get_ssl_bundle.php example.com.crt
*
* @param string $crtFile
* @return string
*/
function get_ssl_bundle($crtFile)
{