Skip to content

Instantly share code, notes, and snippets.

View winebarrel's full-sized avatar

Genki Sugawara winebarrel

194 followers · 0 following
View GitHub Profile
@winebarrel
winebarrel / abstract_mysql_adapter.rb.diff
Created November 9, 2013 06:55
MHAのフェイルオーバー時に再接続するための修正
--- /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.15/lib/active_record/connection_adapters/abstract_mysql_adapter.rb.orig 2013-10-31 07:37:55.704402703 +0000
+++ /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.15/lib/active_record/connection_adapters/abstract_mysql_adapter.rb.reconnect 2013-10-31 09:18:52.061099228 +0000
@@ -239,11 +239,16 @@
# Executes the SQL statement in the context of this connection.
def execute(sql, name = nil)
+ begin
if name == :skip_logging
@connection.query(sql)
else
@winebarrel
winebarrel / consumer.rb
Created December 23, 2013 13:28
#!/usr/bin/env ruby
require 'aws-sdk'
require 'base64'
AWS.config(region: 'us-east-1')
client = AWS.kinesis.client
STREAM_NAME = 'hello'
SHARD_ID = 'shardId-000000000000'
# shard_idの取得
@winebarrel
winebarrel / xxx.xml
Created January 12, 2014 13:27
<Response><Say language="ja-jp" voice="woman">私こっくりさん。今あなたの後ろにいるよ。</Say></Respon
@winebarrel
winebarrel / cthulhu.old-master.sql
Created January 22, 2014 00:24
MHAによるオンライン切り換え時のクエリログ
140122 0:21:53 7 Connect mha@yog on
7 Query set autocommit=1
7 Query SELECT CONNECTION_ID() AS Value
8 Connect mha@yog on
8 Query set autocommit=1
8 Query SELECT CONNECTION_ID() AS Value
8 Query SET wait_timeout=86400
8 Query SELECT @@global.server_id As Value
8 Query SELECT VERSION() AS Value
8 Query SHOW GLOBAL VARIABLES LIKE 'log_bin'
@winebarrel
winebarrel / wrap.rb
Created February 7, 2016 06:20
Usage: wrap.rb any.txt 30
#!/usr/bin/env ruby
trap('PIPE', 'EXIT')
filnum = ARGV[0]
col = Integer(ARGV[1])
File.read(filnum).lines.each do |line|
state = 0
print line.split(//).slice_before {|ch|
@winebarrel
winebarrel / gist:7938971
Last active August 30, 2016 08:48
CREATE TABLE games (
author STRING HASH,
game_id NUMBER RANGE,
INDEX game-type-id-index (game_type_id NUMBER) ALL,
GLOBAL INDEX game-title-index (title STRING, version NUMBER) ALL
) read=4 write=4
@winebarrel
winebarrel / tiny_mysql.rb
Last active January 20, 2017 08:25
https://goo.gl/HPNOeb sha1: 3149baf94ad92fc4254e4864d5b4faa53dc191b0
require 'open3'
class TinyMysql
attr_reader :mysql_command
attr_reader :defaults_extra_file
attr_reader :host
attr_reader :port
attr_reader :username
attr_reader :database
@winebarrel
winebarrel / drone-template.rb
Created March 30, 2014 13:19
Drone on AWS
Parameters do
ImageId do
Type "String"
# http://cloud-images.ubuntu.com/precise/current/
# ap-northeast-1; 64-bit; ebs
Default "ami-1f334f1e"
end
InstanceType do
Type "String"
@winebarrel
winebarrel / db.r6g-test.md
Last active April 7, 2021 05:16
https://github.com/winebarrel/qlap を使ったdb.r6g.largeとdb.r5.largeの性能比較
@winebarrel
winebarrel / pg_show_grants.sql
Last active July 12, 2022 00:28
show grants for PostgreSQL
select
pg_user.usename,
t1.nspname,
t1.relname,
relacl.privilege_type,
relacl.is_grantable
from (
select
pg_namespace.nspname,
pg_class.relname,