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.
13 comments:
I'm testing now! =D
Great work man!
Regards,
André Michi
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.
@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.
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
buy wow gold
cheap wow gold
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
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.
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.
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
I think your blog makeover looks really nice! http://twitter.com/#!/RSGoldfzf
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
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
I wish to convey my affection within the generating Subing
capability together with capability to support make market study
Post a Comment