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.
  Manager: https://github.com/yoshinorim/mha4mysql-manager
  Node: https://github.com/yoshinorim/mha4mysql-node
 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: http://code.google.com/p/mysql-master-ha/

Documentation: http://code.google.com/p/mysql-master-ha/wiki/TableOfContents?tm=6

Source tarball, deb and rpm packages (stable release): http://code.google.com/p/mysql-master-ha/downloads/list

The latest source repository (development tree, url changed): https://github.com/yoshinorim/mha4mysql-manager (Manager source) and https://github.com/yoshinorim/mha4mysql-node (Per-MySQL server source)

Commercial support for MHA is available from SkySQL.

31 comments:

André said...

I'm testing now! =D

Great work man!

Regards,

André Michi

Anonymous said...

Hiya

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...

@Anonymous

--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 (http://code.google.com/p/mysql-master-ha/wiki/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 ?

Thanks

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.
gameonlineonly.com

RS Gold said...

I think your blog makeover looks really nice! http://twitter.com/#!/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.
http://www.4rsgold.com/christmas/active.html
http://www.fzf.com/christmas/christmas.html

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.
http://www.mojatu.com/maplestoryuna/blog/never-go-wrong-items-include-the-pea-coat/
http://maplestoryuna.onsugar.com/way-dressing-so-linked-identity-way-life-American-21280859
http://wowuna.bloguje.cz/916780-it-is-important-to-know-how-to-layer-clothes-for-fashion.php
http://unarsgold.blogspot.com/2012/01/brainstorm-new-wardrobe-combinations.html#!/2012/01/brainstorm-new-wardrobe-combinations.html
http://maplestoryuna.fiftiz.fr/blog/55193,looking-good-boosts-your-confidence.html
http://blog.palungjit.com/edengold/remember-always-for-buying-clothes-that-how-you-look-naturally.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 again.crystalapartment.co.uk |

neveschambers.co.uk |

aikosolutions.co.uk |

lewishickey.co.uk |

stadiumcreative.co.uk |

salsagrande.co.uk |

butlerbag.co.uk |

thewatchavenue.co.uk |

artofbrand.co.uk |

bowdennursery.co.uk |

Post a Comment