April 8, 2014 Summary of MySQL Replication related information Hello. This is Komiya. Nowadays, people often ask me about mysql, so I am trying to compile links that explain what people tend to ask so that they can copy and paste when asked. Please note that you will not know much just by reading this article. (It seems to be useful when you completely forget about it.) ・Basic detailed explanation of field-oriented replication...
April 8, 2014 
4 min readHello. This is Komiya. I received an article about the discovery of a major bug in OpenSSL, and it seems to have a big impact, so I will record the relevant information. A critical bug in OpenSSL has been discovered. Possible impact on a large part of the Internet | TechCrunch Japan JVNVU#94401838: Information Disclosure Vulnerability in OpenSSL heartbeat Extension...
April 1, 2014 **※ Please note this is an outdated article. ** Hello. This is Komiya. I'm not sure if anyone still wants to use it, but I've tested it and will share it here. This is a long article, so please read it when you have time. Starting mysqlfailover without --force and --daemon=start. When I tested it before, it didn't work unless --force, and there was no option to start it with daemon...
March 25, 2014 Hello. This is Komiya. Thanks to you, I had the opportunity to customize it, so I would like to quote some of them and introduce them. For basic things, I think you should also see the link below and "Introductory chef-solo" and its drop pickup. Chef Solo and Knife Solo Nico Server Construction (2) - Introduction - :d wango Engineer Bromaga chef-solo -...
March 14, 2014 Hello. This is Komiya from OPS. It seemed that there was a demand within the company, and I searched for Python tools faster than Java, but I couldn't find AWSCLI, so I made it. We do not use tags to automatically judge things that are not taken. Fixed to allow multiple generations to be obtained if you specify the number of generations in bkup\_num. It is a specification that specifies the instance ID in argument 1 and the hostname in argument 2. ...
January 21, 2014 3 min readHello. This is Komiya from OPS. I asked you to install the redis source and CHEF-SOLO, so I will record it. ★ Requirements Please use 2.8.4 for the version. (Latest source as of 2014/1) ★ The following work ・Check the version that enters at rpm (*Check with yum on the server in the same environment) redis.x86\_64 0:2.4.10-1.el6...
January 10, 2014 3 min readHello. This is Komiya from OPS. This is how to calculate the value to be put in RPS\_cpus according to the number of CPU cores. There is a request to distribute network interrupt processing across multiple cores. I relied on people who could do it and worked hard so far. \[shell\]# core=1 # echo "obase=16; ibase=10; $(( 2 \*\* ${core})) -1" |...
December 10, 2013 4 min readHello. This is Komiya on the OPS side. One morning, I suddenly received a consultation from the developer, so I will record it for later. Consultation: I did a production deployment on jenkins, but the process stopped midway. I tried to put an INDEX on the KEY column (deployed with Cake's DB migration script), but the DB did not respond and I couldn't connect. ...
November 27, 2013 Hello. This is Komiya from the platform. Even if I redundant the others, if I don't redundant the NAT instances, the servers that are HA in the private segment will not be able to communicate with the AWS API server and will be stuck, so I made the following with reference to the articles of my predecessors. **・Consider what to do somehow **...
November 12, 2013 3 min readHello. This is Komiya from the platform. When I tried to reject overseas with apache's mod\_geoip module, I responded by saying that the Facebook image was not displayed. ・I need whois, but it wasn't included, so I looked up the package name on another server and introduced \[shell\]$ which whois /usr/bin/whois # rpm -qf /usr/bin/whois...
November 12, 2013 ***Please note that this is an old article from more than a year ago. ※** Hello. This is Komiya from the platform. This time, ELB is high, so it is a record to the effect that it is a small start so let's build LVS. The first thing I wrote was that we were going to load balance both the WEB and the DB with LVS, but in the end, the WEB side was decided to ELB. ...
October 7, 2013 ***Please note that this is an old article*** Hello. This is Komiya. I would like to consult with you about an incident in which a backup with mysqldump failed and a cold backup was taken but it was inconsistent in a service that has mixed MyISAM tables in the company. (I remember telling it lightly in the past, so I thought everyone knew it, but the ease of understanding and the ability to convey、...
