April 20, 2015
6分で読めますHello. This is Komiya. I felt like my seniors wanted it, so here is a note from the time of introducing gitlab. If you mess around, it will be long and the procedure will be complicated, and whether you can reproduce it as it is may depend on your environment, so we cannot guarantee it. The environment reproduced in this procedure was CentOS 6.5. If you can accept postgres, there is an omnibus version that can be automatically included, so I think it would be a good idea to use that. ...
February 20, 20154分で読めますHello. This is Komiya. One day, while I was revising the recipe for chef, a colleague said something like this. ''' "As soon as Mr. Okyaku clicked on the link of the phpmyadmin information_schema, the site became heavy and the disk space increased by tens of GB, and now it has gone down and calmed down. ```...
September 29, 20142分で読めますWhen processing Ruby + MySQL, I think there are many cases where 'ruby-mysql' or 'mysql2' is used in the MySQL operation system libraries, but since it was necessary to perform MySQL query operations in a raw Ruby environment without these libraries, I tried to generalize the source I wrote at that time and summarize it. Well... There may be almost no need, but I thought I'd share it as TIPS. ...
July 23, 20136分で読めますThank you. This is Komiya. Continuing from the previous article, I will write about dbserver recipes. The only thing I have to do is test with munin, zabbx and serverspec. It's a little patience already. Since it is a fixed version installation like the web, external recipes should not be used in the direction of basically using it ・Install mysql and enable startup and auto-start \[shell\]# cd...
June 3, 20132分で読めます**Try tuning MySQL for underpower. ** Good evening. This is Miyashita, who is in charge of the platform. In this article, I would like to improve the performance of the MySQL replication server that is running for backup and aggregation. We have taken several measures so far, but first we will review the environment. ◇ The running environment uses a large instance in AWS EC2. ...
April 26, 2013**MHA operation confirmation and switchover verification** This is the continuation of the previous article. Test to switch as shown in the following diagram. *This verification consists of 1 master, 2 slaves, and 1 manager. (Multi-stage configuration is avoided because it will be obscene to restore in the event of an intermediate node failure) If you put the manager in the slave, it seems that there is a possibility that it will not switch well if you put purge\_relay\_logs on it. ...
April 23, 2013**Introduction Settings of MHA (MasterHigh AvailabilityManager)** Versions used: mha4mysql-manager-0.53-0, MySQL-5.5 (1) Explanation of simple advantages and other benefits MHA is a product that uses the latest slave as the master in the event of a master failure in mysql to compensate for the differences of other slaves and change the direction of the master. ...
