April 8, 2014Summary 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 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...
September 6, 2013
3分で読めますHello. This is Komiya. A while ago, there was a demand to move VIP (Virtual IP address) on the AWS VPC, so I verified it, but I was just taking notes personally and I had several opportunities to ask questions, so I will post it briefly. When handling a cluster configuration on a VPC, it is necessary to change the PrivateIP address in the VPC、...
July 19, 20131分で読めますIt's been a long time since I've updated. This is Miyashita of the platform. I made a presentation in one of the events called July Tech Festa 2013 held the other day. I will upload the materials I used at that time, so if you are interested, please read it. \[slideshare id=24320385&doc=mysqlha-130716215401-phpapp02\]...
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. ...
