Satoshi Tajima s-tajima
s-tajima
/ kibana-proxy.cfg
Created
February 19, 2014 03:30
Settings for ElasticSearch + Kibana3 Access Controll
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ProxyPass /es http://localhost:9200/ | |
| ProxyPassReverse /es http://localhost:9200/ | |
| <Location /> | |
| AuthType Basic | |
| AuthBasicProvider ldap | |
| AuthName "Authentication for Kibana3" | |
| AuthLDAPURL ldaps://HOST/LDAP_QUERY | |
| Require valid-user | |
| </Location> |
s-tajima
/ out_forward.rb
Last active
August 29, 2015 13:56
fluentd source code for explain dns cache behavior.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def resolved_host | |
| case @expire_dns_cache | |
| when 0 | |
| # cache is disabled | |
| return resolve_dns! | |
| when nil | |
| # persistent cache | |
| return @resolved_host ||= resolve_dns! |
s-tajima
/ td-agent.conf
Created
February 19, 2014 09:15
Fluentd source code for explain dns cache behavior.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <match stream.**> | |
| type forward | |
| flush_interval 10s | |
| buffer_type file | |
| buffer_path /var/log/td-agent/buffer/${tag} | |
| <server> | |
| host aggregator.ec2 | |
| </server> | |
| </match> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [server default] | |
| user=root | |
| password=mysqlrootpass | |
| manager_workdir=/var/log/mha4mysql/ | |
| manager_log=/var/log/mha4mysql/manager.log | |
| remote_workdir=/var/log/mha4mysql/ | |
| #enable later | |
| #master_ip_failover_script=/etc/mha4mysql/scripts/rewrite_haproxy_config.rb |
s-tajima
/ haproxy.cfg
Last active
August 29, 2015 13:57
main config and rewrite script for HAproxy.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| global | |
| log 127.0.0.1 local2 | |
| chroot /var/lib/haproxy | |
| pidfile /var/run/haproxy.pid | |
| maxconn 1000 | |
| user haproxy | |
| group haproxy | |
| daemon | |
| stats socket /var/lib/haproxy/stats |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Mon Mar 10 17:41:08 2014 - [warning] Got error on MySQL ping: 2006 (MySQL server has gone away) | |
| ssh: connect to host 10.0.0.1 port 22: Connection refused | |
| Mon Mar 10 17:41:08 2014 - [warning] HealthCheck: SSH to mysqlserver-a is NOT reachable. | |
| Mon Mar 10 17:41:11 2014 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111) | |
| Mon Mar 10 17:41:11 2014 - [warning] Connection failed 1 time(s).. | |
| Mon Mar 10 17:41:14 2014 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111) | |
| Mon Mar 10 17:41:14 2014 - [warning] Connection failed 2 time(s).. | |
| Mon Mar 10 17:41:17 2014 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111) | |
| Mon Mar 10 17:41:17 2014 - [warning] Connection failed 3 time(s).. | |
| Mon Mar 10 17:41:17 2014 - [warning] Master is not reachable from health checker! |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| = t1 ------------------------------------------------------------------------------------------------------------------------------------------- | |
| mysqlserver-a> select * from test_table01; | |
| +----+---------------------+---------------------------+ | |
| | id | time | text | | |
| +----+---------------------+---------------------------+ | |
| | 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 | | |
| | 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc | | |
| | 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo | | |
| +----+---------------------+---------------------------+ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@mysql-test01 fio1]# sysbench --test=fileio --file-total-size=20G --file-test-mode=rndrw --max-requests=100000 run | |
| sysbench 0.4.12: multi-threaded system evaluation benchmark | |
| Running the test with following options: | |
| Number of threads: 1 | |
| Extra file open flags: 0 | |
| 128 files, 160Mb each | |
| 20Gb total file size | |
| Block size 16Kb |
s-tajima
/ fio1_ext4_seq_01.txt
Created
May 29, 2014 13:31
Result of ioDrive benchmark. (sequential)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@mysql-test01 fio1]# sysbench --test=fileio --file-total-size=20G --file-test-mode=seqwr --max-requests=100000 run | |
| sysbench 0.4.12: multi-threaded system evaluation benchmark | |
| Running the test with following options: | |
| Number of threads: 1 | |
| Extra file open flags: 0 | |
| 128 files, 160Mb each | |
| 20Gb total file size | |
| Block size 16Kb |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| for DIR in "fio1" "fio2" "hdd1" "hdd2" | |
| do | |
| sync | |
| echo 3 > /proc/sys/vm/drop_caches | |
| sync | |
| sysbench \ | |
| --test=oltp \ |
OlderNewer