Friday, September 16, 2011

MHA for MySQL 0.52 released

 I'm happy to announce that MHA for MySQL (Master High Availability Manager and tools for MySQL) version 0.52 has been released. Downloads are available here.
 This is a stable release. I have been using MHA on our(DeNA's) cross-datacenter environments. We had tens of failover opportunities and MHA worked successfully in all cases.

 Here are release notes.

* multi-master configuration is supported
 See my previous blog entry for details.

* Package name changed
 To avoid potential trademark issues, I decided to change MHA package names (downloadable file names and GitHub repository name) from "MySQL-MasterHA-Manager" to "mha4mysql-manager", and from "MySQL-MasterHA-Node" to "mha4mysql-node".

 - URLs of MHA development repositories on GitHub changed as below.
 If you currently follow previous branches, please modify .git/config and point to new URLs to pull newer versions.

 - If you installed MHA node rpm packages (version 0.50) provided from our download site, when upgrading to newer versions, please explicitly uninstall the current rpm package (rpm -e MySQL-MasterHA-Node-0.50-...) and install newer version.

 All source codes, test cases, command line programs (i.e. masterha_manager), parameters etc are not changed. So product quality of MHA should not be affected by this change.

* rpm and deb packages are now provided
 Prior to 0.52, rpm package for MHA Manager was not provided, and deb package was not provided at all. Now both rpm and deb packages are provided for both Manager and Node(running on MySQL server).
 See how to install page for details.

MHA for MySQL, project Info

Project top page:


Source tarball, deb and rpm packages (stable release):

The latest source repository (development tree, url changed): (Manager source) and (Per-MySQL server source)

Commercial support for MHA is available from SkySQL.


André said...

I'm testing now! =D

Great work man!


André Michi

Anonymous said...


I'm confused about the recovery process.

Let's say you have 3 boxes, 1 master, 2 slaves. Master box goes away, 1 of the slaves gets promoted using MHA and the other slave starts to replicate from the new master.

So far so good

At this point mha-manager exists because it has completed the failover. And it you re-run it, it will fail to start because it cannot connect to the old server.

If you bring up back the original master, mha manager refuses to start because it sees that the original master is not configured to be a slave.

Is it up to the user to manually reconfigure the original master to point to a new master or is mha-manager supposed to be the one doing that?

I saw the "--remove_dead_master_conf" option which would allow mha manager to start when the original master is down, but that would again require user intervention to re-add it again.

Yoshinori Matsunobu said...


--remove_dead_master_conf is helpful for MHA to continue to monitor master availability without changing configuration file manually.

Right now MHA does not rebuild the crashed master as a new slave automatically. The crashed master's database may be lost (i.e. disk failure), or has consistency problems (i.e. latest relay log events are not written to disk or vise versa). It is generally recommended re-creating the database as a slave (from backups, or other slaves). MHA has a utility command masterha_conf_host ( so that you can add a new host(maybe original master) to the config file easily so this may be helpful.

George said...

Hi Yoshinori

Thanks for all the hard work on MHA. I've been playing with different replication methods including Tungsten Replicator and now it's time to try out MHA. But was wondering

1. Has MHA been tested against MariaDB 5.2 and Percona 5.5 forks ?

2. If I was to test master/slave setup where slave resides on same master (different port/socket), would I only need to install the 1x MHA Node rpm package for both master and local slave ?


riftplat said...

buy wow gold
cheap wow gold

RS Gold said...

I am just unclear about this process of healing.

Suppose you've got Several boxes, A single get good at, Only two slaves. Learn box disappears, This is the slaves gets marketed using MHA as well as additional servant begins to replicate through the completely new get good at.

At this point so excellent

At this point mha-manager is out there because doing so features accomplished your failover. Plus it you re-run the idea, it can do not start out because doing so can't get connected to the actual remote computer.

When you mention rear the original grasp, mha manager will not start out given it is aware that the original grasp isn't configured becoming a servant.

Do you find it up to the user to manually reconfigure the original get better at to point out completely to another get better at or perhaps mha-manager said to be the main one carrying out that will?

My spouse and i saw your "--remove_dead_master_conf" option which will permit mha supervisor to get started once the authentic get good at is usually along, however that may once again demand user intervention to help re-add this all over again.

Buy Cheap RS Gold
Cheap Runescape Gold
Cheap Eden Gold

Anonymous said...

This is the world of fashion and style hermes replica where we see competition,

rivalry and challenges IdolReplicas among the fashion designers and artists everywhere around

us. That is why everyone has certainly replica watches become keen about his or her style

nowadays. More importantly, people are nowadays paying a close attention to their styles from top to bottom.

gold wow said...

Most of the particular Mmo currency Cheapest WOW Gold retail outlets will Purchasing Sidesplitter Aureate carry the percent from the RS your own previous(a) wristwatches, when your clench could possibly be huge, then you need to wait for an inadequate objet d'art (ordinarily more or less all day and in some cases numerous days) until such time as masses collect your current Gold WOW stock-taking for you Bribe Aion Kinah personally. You'll want to be affected person from time to time if they're offered-come out of the closet at that moment,Grease one's palms Tera Gilt it's very criterion internet Buying WOW Gold promotion purchased-emerge for you actually, simply because Old watches is successful victimization the majority of oceans.

lili said...

I just discovered your post and have already been reading together. I want to convey my affection of the producing ability along with ability to help make audience read in the first place on the finish. I'd like to examine newer content and share our feelings along.

RS Gold said...

I think your blog makeover looks really nice!!/RSGoldfzf

gamefan said...

This can be a great inspiring article. We are basically satisfied with your good work. You'd put really very useful information.

Cheap RS Gold said...

The headline was an eyecatcher and I love the way you write. I also doubt at some time. Thank you for this wonderful experience.!/2012/01/brainstorm-new-wardrobe-combinations.html,looking-good-boosts-your-confidence.html

Anonymous said...

I wish to convey my affection within the generating Subing
capability together with capability to support make market study

cheap cambridge satchel said...

The sun glasses--best picture frame is colour diversity, to accord with professional cambridge satchel company characteristics, blue or red wine is right choice.

In fact, see a brand of punk small days and "material girl" avril model Hilton, very understand the so-called tide female, also is that the high-profile self dress up.
Needless to say, even Classic Cambridge Satchel is this year's fashion trend. Even the body skirt, even the body pants, and even on his hat, as long as it can even give it to connect the right, one piece will a man united packing up, so clean or with simple white T and accessories, the effect also is very outstanding.

hugginss jetterees said...

Have you ever been Ripped off on Runescape? - Signifying, it's possible you've been cheated? Nicely, for anyone who is rs gold like most males and females than your solution is potentially of course to that dilemma. Properly don't allow for it occur as soon as much more! The following are a few tricks, that will enable you to steer clear of getting cheated.

Emily said...

Finden Sie wow gold kaufen vier oder mehr Spieler heraus, um einen Kerker mit Ihnen zu führen. Kerker können völlig relevant schneller sein und Ihnen erlauben, sich in einen Teil des Goldes zu teilen, das jeder Spieler ergreift. Machen Sie eine Gruppe. Der beste Weg, um Quests zu tun ist, Gruppe mit anderen Spielern in der Nähe. Angenommen, dass Ihre Situation vielleicht nicht beständig ist, wow items kaufen würden Ihr Gilde-Begleiter oder Ihre Freunde Ihnen gern ein kleines Darlehen leihen, bis Sie veranlassen, dass das genug Gold sie zurückgibt. Sie können das Zahnrad an einen Verkäufer für Extragold verkaufen, wenn Sie die Rolle für einen Zahnrad-Fall gewinnen. Indem Sie Hilfe herausfinden, um Suchen zu beenden, können Sie WoW Gold schneller verdienen und beenden schwierigere wow shop Suchen brauchen mehr als einen Spieler.

geetha said...

wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again, Regards, MySql online trainingamong the MySql in Hyderabad. Classroom Training in Hyderabad India

GuildWars2Items said...

Being happy doesn't mean that everything is perfect. It means that you've decided to look beyond the imperfections cheap c9 gold, don't go around saying the world owes you a living. The world owes you nothing. It was here first c9 money, I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches c9 gold.

GuildWars2Items said...

Diablo 3 Gold someone who makes you believe that there really is good in the world, someone who makes you laugh until you can't stop Buy Diablo 3 Gold, someone who changes your life just by being part of it Cheap Diablo 3 Gold, this is Forever Friendship

Maria Arredondo said...

The consequences of today are determined by the actions of the past scarlet blade gold. To change your future, alter your decisions today scarlet blade gold, Experience is a hard teacher because she gives the test first, the lesson afterwards scarlet blade gold, but it takes character to keep you there.

buyGuildwars2gold said...

You have a forever friend for life, and forever has no end D3 Gold Sale, and if you find such a friend, you feel happy and complete, because you need not worry Diablo iii Gold, your forever friend holds your hand and tells you that everything is going to be okay Buy Diablo iii Gold.

buyGuildwars2gold said...

One meets its destiny on the road he takes to avoid it Cheap C9 Gold, If I could rearrange the alphabet, I'd put Y and I together c9 gold, People who are serious about the relation are moody as they have devoted a lot that makes them worry about gains and losses c9 online gold.

de wo said...

WOW cooking skills not only comes back to the value of magic life, but some food can be added up the effect of buff to enhance the rs gold player's survival.

Cahaya Mandiri said...

It is amazing posting and incredible work, It has suitable information, I presently wanted to say that you have really so motivating and very informative post. Thanks for wonderful posting
tips cara agar cepat hamil l CARA BELAJAR BAHASA INGGRIS l the best acne treatment l how to lose weight fast easy
margahayuland l BELAJAR BISNIS ONLINE l tips cepat hamil l how to get rid of acne home remedies l
home remedies for acne l how to cure acne fast l
baju batik modern l toko sepatu online l grosir jam tangan online l
jual jam tangan l toko jam tangan murah peluang usaha online l is acne no more for you l how to get rid of acne naturally
how to clear acne l cure acne naturally
best natural remedies for acne l acne no more l tempat belajar bisnis online
peluang usaha rumahan l cara mendapatkan uang dari internet
makanan sehat agar cepat hamil l penyebab tidak bisa hamil lcara agar cepat hamil

dveeeeeee said...

If you installed MHA node rpm packages (version 0.50) provided from our download site, when upgrading safeeveisk to newer versions, please explicitly uninstall the current rpm package (rpm -e MySQL-MasterHA-Node-0.50-...) and install newer version.

All source codes, test cases, command line programs (i.e. masterha_manager), parameters etc are not changed. So product buy eve isk quality of MHA should not be affected by this change.

Grosir Pulsa Online said...

makan khas jawa barat

daftar makanan tradisional

kue dr tepung beras

jual oleh oleh padang

Pagkain Tenjo Dodol ay matamis na topi-tulad ng matamis, popular sa Indonesia, Malaysia, sa Pilipinas (lalo na sa Ilocos rehiyon sa lalawigan ng Lanao Luzon at Matamis Dodol ay mula sa Indonesia. Lunkhead mataas na kalidad na pagmamanupaktura proseso tumatagal ng isang mahabang panahon at nangangailangan ng kadalubhasaan khusus.4 araw na nakalipas - Smartphone "pagbabagong-anyo" proyekto - ang launcher launcher Dodol dodolnya nagpapahintulot sa mga user upang palamutihan home screen ng iyong Android telepono at ...

Lisa Parkar said...

The post contains really precious information that will convince readers and can clarify things upon. It's so logically written buy coffee table online

Lisa Parkar said...

interesting piece to read, giving every subject enlightenment for us to gain knowledge Rent an Office in NYC

jimmy wilson said...

Superb post I adore ones post; really like the way you defined things, you do a fantastic work a lot of others like you by way of which sort of informative websites supply consciousness for you to us all relevant to lots of things. When i study other sorts of fascinating websites out of your sites as well as I am so much curious along with your blogging abilities, My spouse and i also begun to write content this also form debate genuinely support us available. My spouse and i currently book marked the page and shared your current internet websites in order to the co-workers not merely me but them all similar to ones blogs abilities, desire you produce more fascinating websites such as this 1 in addition to all the best for ones potential information sites.

Jimmy Wilson from Superman Leather Jacket for Adults

Jess said...

Experience points can be gained after you complete one quest. old school runescape gold map can be of great use when you do quests. You can follow the map and get to the quest runescape 07 gold destination. Every quest has unique requirements. You should meet the requirements of the quests and then you can complete it. The more quests you complete the more experience points you get. This is a way to level up fast in RS. You can get your lol riot points skill practiced.

sadia sulaman said...

I would like to thank you for your nicely written content,its useful and your writing style helped me to read it without any difficulty.Your blogs and information attracts me to come back again n | | | | | | | | | |

sadia sulaman said...

Thank you for this blog. That's all i can say..useful information shared... i am very happy to read this article.. thanks for giving us nice info. fantastic walk-through.aspextechnology |

qrgl-technology |

accessibletechnology |

istechnology |

su2technology |

computersforfutures |

gtscomputers |

computerisfun |

solocomputerservices |

computeroutlets |

sextoy terbaru said...

Father mother or sister I love what I see with this, is very interesting content that led me curious to go to your website is. our greetings alat bantu pria.

panca-samudera said...

The article posted was very informative and useful
thanks for sharing.
jaring futsal , jaring futsal murah , jual jaring futsal , jaring golf , jual jaring golf , jaring golf murah ,
jaring polynet , tangga darurat , jaring truk , jaring cargo , jaring outbound , jual rumput futsal murah ,
jual rumput sintetis murah , tali tambang , cargo net , jaring tanaman , jaring kassa , jaring proyek , jaring bangunan ,
jaring gedung , jaring pengaman proyek , jaring pengaman bangunan , jaring pengaman gedung , jaring peneduh , jaring waring , kasa hijau , tangga darurat , jaring gawang futsal ,
jual jaring gawang futsal murah , jaring peneduh , jaring truk , tali tambang nylon , jaring safety , safety net , jaring , waring , polynet

Leana Vanwyhe said...

I was looking for more information about the Lyft rideshare brand. I was able to find a lot of good material for a free ride: 2015 Free Ride Code from Lyft

Tahir Bahi said...

Thanks for sharing, nice blog and your article. plese visit me
IDM 6.5 Build 5 kegan
Trend Micro Antivirus
Windows 7 Product Key
Adobe Illustrator CC 2016 Crack

Specto Pvt said...

very useful really good information thanks for posting such a good information it will hepls the people a lot keep it up , Regards
sap sd training
sap mm training

Healthy Colors said...

Nice blog ..! I really loved reading through this article..

Thanks for sharing such a amazing post with us and

keep blogging...

treatment in hyderabad

Magnific Online Training said...

Found your site from a friends Facebook link, it seems that you have growing fanbase and I now undertsand why Super informative article, thanks a million.

Oracle Apps Financials Functional Online Training

microsoft dynamics ax 2012 T&L online Training

Master Taufan said...

Thanks for Sharing That…. Sucses for You….



epson printer driver

Deny Games said...

Thanks for taking the time to discuss this, I feel about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more information? It is extremely helpful for me. ,

Анна Фрейт said...

I hope to see more posts from you :) It's really interesting to know these information

Devi.Angularjs said...

JavaScript Training in Chennai | Ecmascript 6 Training in Chennai | ES6 Training in Chennai | Angular 2 Training in Chennai | HTML5 Training in Chennai

Yeoman Training | D3 Training | ReactJS Training | Gulp Training | CommonJS Training

HTML5 Training in Chennai | Angular 2 Training in Chennai | Node.js Training in chennai

Devi.Angularjs said...

JMS Training Institutes in Chennai | JSP Training Institutes in Chennai | Java Spring Hibernate Training Institutes in Chennai | EJB Training Institutes in Chennai | Hibernate Training Institutes in Chennai |

JSF Training Institutes in Chennai | Java EE Training Institutes in Chennai | J2EE Training Institutes in Chennai | Core Java Training Institutes in Chennai | Java Training Institutes

| Struts2 Training Institutes in Chennai | Spring Training Institutes in Chennai | Java MicroServices Training Institutes In Chennai

lina sexshop said...

Berikut kami akan membahas tentang bagai mana cara memperbesar penis dengan hasil cepat dan aman tanpa operasi
jika anda ingin memperbesar penis dengan hasil cepat,aman tanpa operasi itu mudah anda bisa pilih cara memperbesar penis dengan obat pembesar penis herbal
seperti Pembesar Penis Obat Good Man

jika anda riskan konsumsi obat pembesar penis anda bisa pilih jalan lain seperti metode trapi ( pemakaian luar ) kami juga punya solusinya anda harus punya Alat Pembesar Penis sejenis Pro Extender atau Vimax Extender

Berikut penjelasan kami :

Apa Obat Good Man itu : Obat Good Man
Apa Vimax Extender itu : Vimax Extender Asli
Apa Pro Extender itu : Pro Extender Asli

Sekarang anda bisa tau rahasia cara memperbesar penis dengan aman tanpa operasi.selamat mencoba.

Thank you for the information , I wait for more information and I ask for a return visit our new website
>> Obat Pembesar penis <<

lina sexshop said...

Thank you for the information , I wait for more information and I ask for a return visit our new website
>> Hammer Of Thor Asli <<

Hammer Of Thor Asli Bali | Hammer Of Thor Asli Jakarta
Hammer Of Thor Asli Batam | Hammer Of Thor Asli Jogja
Hammer Of Thor Asli Bogor | Hammer Of Thor Asli Bandung
Hammer Of Thor Asli Medan | Hammer Of Thor Asli Surabaya

Adlearning Technologies said...

Thank You for sharing your article. I like it. We provide TIBCO Online Training in Hyderabad.

Jason Borne said...

Avast Support | Avast Help
Norton Support | Norton Help
Gmail Customer Support

Jon Don said...

Office Setup
Office Com Setup
Printer Tech Support

KarlDeville said...

Thank you for taking the time and sharing this information with us. It was indeed very helpful and insightful while being straight forward and to the point. | |

Post a Comment