Sunday, January 8, 2012

MHA for MySQL 0.53 released

 MHA for MySQL (Master High Availability Manager and tools for MySQL) version 0.53 has been released. Downloads are available here.

 Here are release notes.

New features:
* Supporting RESET SLAVE ALL from MySQL 5.5.16
* Supporting "skip_reset_slave" parameter to avoid running CHANGE MASTER TO on the promoted slave
* Doing master's health checks optionally via MySQL CONNECT, in addition to SELECT
* Supporting "mysql --binary-mode" from MySQL 5.6.3
* Supporting ssh_host and ssh_port parameters
* Supporting ssh_options parameter
* Supporting --check_only for online master switch (dry-run)
* When doing online master switch, MHA checks whether long queries are running on the new master. This is important to reduce workloads on the new master. Query time limit can be controlled via --running_seconds_limit.
When executing SIGINT on online master switch, MHA tries to disconnect established connections via MHA.
* Additionally checking replication filtering rules on online master switch

Bug fixes:
* MHA Manager looks for relay-log.info in wrong location when setting relay_log_info_file
* Wrong option for master_ip_failover_script
* Timeout settings for SSH connection health check does not always work
* Modifying a rpm spec file to create valid rpm package for 64bit RHEL6
* Forcing more strict ssh checking. Originally MHA checks master's reachability by just connecting via SSH and exiting with return code 0. This in some cases does not work especially if SSH works but data files are not accessible. In this fix, MHA checks master's ssh reachability by executing save_binary_logs command (dry run). MHA Client also needs to be updated to 0.53.
* Zombie process remains on master ping timeout
* Do not execute SET GLOBAL read_only=(0|1) if not needed

How to upgrade


 Upgrading MHA from older version to 0.53 is easy. Simply stop masterha_manager program, replace all MHA Node and MHA Manager packages to 0.53, and restart masterha_manager. You do not need to stop mysqld or MySQL Replication.


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.

26 comments:

Viacheslav Biriukov said...

Goog job!

runescape gold said...

That is almost all extremely a novice to me which post actually popped our eye.Thank you for revealing along with us your perception.

WOW Gold
Cheap WOW Gold
World Of Warcraft Gold
Buy World Of Warcraft Gold
rsgold
cheapest runescape gold
cheapest rs gold
buy rs gold cheap
rs gold cheap

Coupon Code said...

I think your "New features" really good!

Coupon Code
Amazon promotional codes
uverse coupon codes
hp promo codes

Find sex said...

Its use will be off-limits for ordinary citizens, saving a million dollars a year and reducing greenhouse gas emissions in the region.

stephbul said...

Hello,
Your MHA project definitly looks like a very good project and I'm going to make some tests in order to get it into production soon!
I still have one question: I don't understand the new server insert process. In a classical master/slave configuration, you need to dump the master mysql database (with database locking) and to load it in your slave. What is the equivalent process with MHA?
Regards.

cheng binbin said...

Game gold and items, so you want to safely and quickly speed search MMOGGG.

welcome to http://www.mmoggg.de/
Abnormal favorite online games, such as PC
WoW Gold and Diablo 3 Gold and aion gold and Runescape Gold Are among the most popular game currencies, including the PC and web games.

soft said...

Upgrading MHA from older version to 0.53 is easy. Simply stop masterha_manager program, replace all MHA Node and MHA Manager packages to 0.53, and restart masterha_manager. You do not need to stop mysqld or MySQL Replication.

cheap GW2 Gold

GuildWars2Items said...

It takes strength to resist temptations and distractions Diablo iii Power Leveling, it takes strength to do what is right D3 PowerLeveling, it takes strength to do al these things. And all the while, these are the very things that build even more strength D3 Power Leveling.

GuildWars2Items said...

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

Maria Arredondo said...

Life is not measured by the number of breaths we take scarlet blade gold, but by the moments that take our breath away scarlet blade gold. I have a simple philosophy: Fill what's empty scarlet blade gold.

Maria Arredondo said...

The bravery of each bull is then rated with care according to the number of times he demonstrates his willingness to charge in spite of the sting of the blade Runescape gp, Henceforth will I recognize that each day I am tested by life in like manner. If I persist, if I continue to try, if I continue to charge forward, I will succeed rs gp, Your future depends on your dreams Runescape2 Gold. So go to sleep. Do not keep anything for a special occasion..

buyGuildwars2gold said...

Experience is a hard teacher because she gives the test first, the lesson afterwards cheap c9 gold, being happy doesn't mean that everything is perfect. It means that you've decided to look beyond the imperfections c9 money, Life is like a hot bath. It feels good while you're in it, but the longer you stay in, the more wrinkled you get WOW Power Leveling.

buyGuildwars2gold said...

It takes strength to resist temptations and distractions Diablo iii Power Leveling, it takes strength to do what is right D3 PowerLeveling, it takes strength to do al these things. And all the while, these are the very things that build even more strength D3 Power Leveling.

My Family said...

Norton 360 new edition of Norton Antivirus is very good from finding and taking good care of malware.

Xiaoyi Li said...

Empfohlene Links:Diablo 3 Gold;Guild Wars 2 GoldDiablo 3 Gold KaufenAion Kinah

Lisa Parkar said...

I have been getting a bundle of useful and informative matter in your blog post buy coffee table online

Lisa Parkar said...

I get a lot of great information here and this is what I am searching for. Thank you for your sharing such a great blog with everyone discount dining room sets

wow9gamer said...

being happy doesn't mean that everything is perfect. It means that you've decided to look beyond the imperfectionscheap elo boost
Cheap League of Legends Coaching

alastair trot said...

I think it’s worth noting that since January 2012 there was no changes to MHA (0.53). Yoshinori Matsunobu made two releases in December (release notes) & used in production at multiple locations.
writing kingdom

Saha William said...

it is really good to see MHA for MySQL. now we can easily Downloads from here.
www.essayavenue.co.uk/descriptive-essay-help/
www.essayavenue.co.uk/expository-essay-help
/www.essayavenue.co.uk/high-school-essay-help/
www.essayavenue.co.uk/law-essay-help/
www.essayavenue.co.uk/narrative-essay-help/

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.jpburnside.co.uk |

rhinomoto.co.uk |

ebayshopdesigner.co.uk |

vegan-candles.co.uk |

oxygenediving.co.uk |

montagupe.co.uk |

ne7es.co.uk |

happymondayscomedy.co.uk |

mmmmh.co.uk |

eskyhobby.co.uk |

Pan Norbert said...

Then the aspiring trader starts to play around on the practice account treating trading as a game. There is no set plan, and the trader will take trades left right and center at the slightest whim. forex practice

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

provitalhealth |

northernhealthplan |

oralhealthexam |

cwyzehealth |

cwyzehealthcare |

healthykskids |

biohealthchip |

meridianwomenhealth |

heroeshealthproject |

Brenda Palmeri said...

Your post is really very nice and useful for everyone business for sale uk birmingham

Essay Writing Papers said...

Ask and ye shall not receive. Life Experience Degree | Company Logo Design

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

obat kemaluan keluar nanah | obat kelamin keluar nanah | obat kutil di penis | obat keluar nanah dari kemaluan pria | menghilangkan kutil di vagina | Obat kutil di kelamin pria | obat kutil kelamin pada wanita | obat menghilangkan kutil di kelamin | Obat kutil di kelamin pria | obat kutil kelamin pada wanita | obat menghilangkan kutil di kelamin | Obat kutil di kelamin pria | obat kutil kelamin pada wanita

Post a Comment