GedowFather’s gists

GedowFather / lockwait_counter.py

Last active September 17, 2021 03:34

GedowFather / SqlLogger.py

Last active September 3, 2024 02:49

Python scirpt for counting slow query log and sort it.

GedowFather / general_log_dump.py

Created March 2, 2018 01:51

	#!/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.
	#

GedowFather / apt_package_update.py

Last active March 8, 2016 02:52

S3にDEBがアップロードされたらレポジトリを更新するLambdaスクリプト

	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'

GedowFather / yum_package_update.py

Created March 7, 2016 03:24

S3にRPMがアップロードされたらレポジトリを更新するLambdaスクリプト

	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'

GedowFather / CollectdClient.py

Last active April 30, 2016 05:05

AWS Lambda python script for sending metric value to collectd server.

	#
	# 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)
	#

GedowFather / ZabbixSender.py

Created December 7, 2015 06:13

AWS Lambda python script for sending metric value to zabbix.

	#
	# 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

GedowFather / ZabbixClient.py

Last active December 7, 2015 06:52

AWS Lambda python script for running zabbix api.

	#
	# Zabbix API Client.
	#
	# Usage:
	# from modules.ZabbixClient import ZabbixClient
	# ZABBIX_HOST = "zabbix.example.com"
	# ZABBIX_PORT = 80
	# ZABBIX_USER = 'Admin'
	# ZABBIX_PASS = 'zabbix'
	# ZABBIX_PATH = '/api_jsonrpc.php'

GedowFather / aws_vpn_between_vpcgw_and_debian_with_monit_for_non_nat.sh

Last active January 4, 2016 08:19

BashScript for connecting VPN between VPC G/W and Debian Linux. operating HA by monit.

	#!/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

GedowFather / aws_vpn_between_vpcgw_and_debian_with_nat.sh

Created January 24, 2014 03:17

BashScript for connecting VPN between VPC G/W and Debian Linux. Connecting from Client to EC2, using NAT on VPN.

	#!/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

GedowFather GedowFather