GedowFather GedowFather

## SqlLogger.py
#
# スロークエリログをユニーク化整理します
#
import re
import hashlib

class counterSlowQuery:
    init_keep_info = {
        'unix_time' : None,
        'src_ip'    : None,

## ZabbixSender.py
#
# For sending metric value to zabbix server.
#
# You must create item as "zabbix trapper" on server.
# Because the server must be connected to agent:10050, if it is selected "zabbix agent".
#
# Usage:
#    from modules.ZabbixSender import ZabbixSender
#    ZABBIX_HOST = "zabbix.example.com"
#    ZABBIX_PORT = 10051

## percona_backup.sh
#!/bin/bash
#
# ============================================================
#
# @license        This program is free software.
#
# @category	Script for Percona Server
# @project	Gedow Software
# @package	Gedow Percona Utils
# @author	GedowFather http://blog.father.gedow.net/

## lockwait_counter.py
#!/usr/bin/env python3
import os
import json
import hashlib
import glob

#
# Config
#

## capacity-scheduler.xml
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>

  <!-- Setting up queues -->

  <property>
    <name>yarn.scheduler.capacity.root.queues</name>
    <value>default,tree</value>

## general_log_dump.py
#!/bin/env python
#
# Usage:
#   ./dump.py
#   - It will stop after period specified seconds or after getting max size.
#   - log is sent to s3 bucket.
#   - notification
#     > EC2 needed profile (s3 put)
#     > You need edit INFRA s3 bucket policy.
#

## CollectdClient.py
#
# For sending metric value to collectd server.
#
# Usage:
#    from modules.CollectdClient import CollectdClient
#    COLLECTD_HOST = "collectd.example.com"
#    COLLECTD_PORT = 25826
#    client = CollectdClient(COLLECTD_HOST, COLLECTD_PORT)
#    client.putval('example-web-01', 'service', 'gauge', 'metric', 300, 1.2345)
#

## apt_package_update.py
import json
import urllib
import boto3
import os
import re

# constants
image_id = 'ami-a21529cc' # ubuntu-trusty-14.04-amd64-server-20160114.5
subnet_id = 'subnet-example'
instance_profile_name = 'InstanceProfileName'

## yum_package_update.py
import json
import urllib
import boto3
import os
import re

# constants
image_id = 'ami-59bdb937' # Amazon Linux AMI 2015.09.2 x86_64 HVM GP2
subnet_id = 'subnet-example'
instance_profile_name = 'InstanceProfileName'

## aws_vpn_between_vpcgw_and_debian_with_monit_for_non_nat.sh
#!/bin/bash
#
# Setup VPN between Debian Linux and VPC G/W.
#   How to use : ./this_script.sh Generic.txt
#
# For connecting IPsec VPN, you need to allow these connections.
# If VPN has global address, you change FORWARD to OUTPUT.
#
#   ex) iptables -A FORWARD -p udp --dport 500 -j ACCEPT
#       iptables -A FORWARD -p tcp --dport 500 -j ACCEPT
	#
	# スロークエリログをユニーク化整理します
	#
	import re
	import hashlib

	class counterSlowQuery:
	init_keep_info = {
	'unix_time' : None,
	'src_ip' : None,
	#
	# For sending metric value to zabbix server.
	#
	# You must create item as "zabbix trapper" on server.
	# Because the server must be connected to agent:10050, if it is selected "zabbix agent".
	#
	# Usage:
	# from modules.ZabbixSender import ZabbixSender
	# ZABBIX_HOST = "zabbix.example.com"
	# ZABBIX_PORT = 10051
	#!/bin/bash
	#
	# ============================================================
	#
	# @license This program is free software.
	#
	# @category Script for Percona Server
	# @project Gedow Software
	# @package Gedow Percona Utils
	# @author GedowFather http://blog.father.gedow.net/
	#!/usr/bin/env python3
	import os
	import json
	import hashlib
	import glob

	#
	# Config
	#
	<?xml version="1.0"?>
	<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

	<configuration>

	<!-- Setting up queues -->

	<property>
	<name>yarn.scheduler.capacity.root.queues</name>
	<value>default,tree</value>
	#!/bin/env python
	#
	# Usage:
	# ./dump.py
	# - It will stop after period specified seconds or after getting max size.
	# - log is sent to s3 bucket.
	# - notification
	# > EC2 needed profile (s3 put)
	# > You need edit INFRA s3 bucket policy.
	#
	#
	# For sending metric value to collectd server.
	#
	# Usage:
	# from modules.CollectdClient import CollectdClient
	# COLLECTD_HOST = "collectd.example.com"
	# COLLECTD_PORT = 25826
	# client = CollectdClient(COLLECTD_HOST, COLLECTD_PORT)
	# client.putval('example-web-01', 'service', 'gauge', 'metric', 300, 1.2345)
	#
	import json
	import urllib
	import boto3
	import os
	import re

	# constants
	image_id = 'ami-a21529cc' # ubuntu-trusty-14.04-amd64-server-20160114.5
	subnet_id = 'subnet-example'
	instance_profile_name = 'InstanceProfileName'
	#!/bin/bash
	#
	# Setup VPN between Debian Linux and VPC G/W.
	# How to use : ./this_script.sh Generic.txt
	#
	# For connecting IPsec VPN, you need to allow these connections.
	# If VPN has global address, you change FORWARD to OUTPUT.
	#
	# ex) iptables -A FORWARD -p udp --dport 500 -j ACCEPT
	# iptables -A FORWARD -p tcp --dport 500 -j ACCEPT