Monday, March 31, 2014

MHA 0.56 is now available

I released MHA version 0.56 today. Downloads are available here. MHA 0.56 includes below features.

  • Supporting MySQL 5.6 GTID. If GTID and auto position is enabled, MHA automatically does failover with GTID SQL syntax, not using traditional relay log based failover. You don't need any explicit configuration within MHA to use GTID based failover.
  • Supporting MySQL 5.6 Multi-Threaded slave
  • Supporting MySQL 5.6 binlog checksum
  • MHA supports new section [binlogN]. In binlog section, you can define mysqlbinlog streaming servers. When MHA does GTID based failover, MHA checks binlog servers, and if binlog servers are ahead of other slaves, MHA applies differential binlog events from the binlog server to the new master before recovery. When MHA does non-GTID based (traditional) failover, MHA ignores binlog servers. More details can be found on documentation.
  • Supporting custom mysql and mysqlbinlog location
  • Adding ping_type=INSERT for checking connectivity for the master. This is useful if master does not accept any writes (i.e. disk error)
  • Added --orig_master_is_new_slave, --orig_master_ssh_user and --new_master_ssh_user for master_ip_online_change_script 
  • Added --skip_change_master,  --skip_disable_read_only, --wait_until_gtid_in_sync on masterha_manager and masterha_master_switch (failover mode).

27 comments: said...

What about MariaDB GTID ?
Is it supported too ?

Mark Callaghan said...

When does it become MHA version 1.0?

eric said...

It would be cool if MHA could move around slaves as well as masters.
Something similar to maatkit's mk-slave-move

--sibling-of-master Make the server a slave of its grandparent, so it is a
sibling of its master
--slave-of-sibling Make the server a slave of one of its siblings
--slave-of-uncle Make the server a slave of one of its uncles (parent's

This would be useful when you want to re-organize your replication topology without disturbing the master that is taking in writes.

Frédéric Descamps said...

This new version supports 5.6 GTID and MariaDB GTID

Yoshinori Matsunobu said...

The new version of MHA supports MySQL 5.6 GTID but has not supported MariaDB GTID yet. MariaDB GTID syntax is different from MySQL 5.6. MHA will support if demand is high enough, or welcome patches.

I have not decided when to use version 1.0 yet:) Some well known large companies use MHA in production for more than two years, so I'm pretty sure we can rename to 1.0:)

Céd said...

Yes, I would love MHA supports MariaDB GTID!

deny andoid said...

Michael Kors Michael Gros is delighted to announce, vogue blogger Michelle dressed in Michael Kors 2014 summertime sequence navy white striped shorts as well as a windbreaker when using the exact same Goyard Tote Outlet paragraph typical Michael Kors Hamilton handbags, Haji Lane stroll the streets of Kazakhstan pose Lane Singapore. Michael Kors handbags scorching brands Sutton, delicate brown and white strike colour design and style, either hand, can shoulder, with Michael Kors wave position sleeveless dress and gold see, casual style devoid of getting rid of the arrogance of stylish Gucci Handbags Outlet Canada urban a lot of women temperament. Aid us express that Michael Kors Outlet Canada you've observed, Michael Kors has now become a ubiquitous model Longchamp Tote Bags Canada. Appears like Michael Kors manner market place has grown to be general public enemy. Lately, the American luxury brand Goyard Tote Outlet Canada introduced a quarterly light ended June 28 finished the reporting period of time the company's profits rose forty three per cent, this really is Michael Kors thirty third consecutive quarter of earnings expansion.

deny andoid said...

Brand turned his consideration towards East this time. Discovered from detailed define of classic Japanese inspiration, Karen Millen Karen Milian utilising potential factors, to show the impression of contemporary gals. Each and every Karen Millen Sale service or Japanese artwork of origami-style folds of ruffles, or from exaggerated metallic materials, or inspiration in the overall floral print, a unique ornamental topic from. Satin kimono material and Karen Millen Outlet construction fashion dresses and jackets, wide-sleeved shirt and double-breasted coat; exaggerated rosebuds rich black lace Mont Blanc Pens Sale UK overlaid on pale green, provides a solid female suit for ornamental skirts and trousers; temptation underwear the folds, dots and lightweight nude coloration in to the boudoir glamor Chrome Hearts Online; beautifully etched floral oriental ornament for promenade dresses included.

tasnuva lotika said...

Ask a friend, or even parents, to study your article to discover unclear words, reasoning, or spelling mistakes and write my essay for me. If there is someone else in your category, who is working on an assay, you may study through each others perform.

Minh Vương said...

Công ty vệ sinh 5 Sạch
Dịch vụ giặt thảm tại Hà Nội
Dịch vụ giặt ghế sofa tại Hà Nội
Vệ sinh nhà sau xây dựng

killer king said...

valentine day wishes
Valentine Day Quotes For Girlfriend
Valentine day Poems
Valentine day Messages

Naveen Chaudhary said...

valentine wish
valentine quotes for girlfriend
valentine day wishes for girlfriend
valentine day poems for girlfriend

Minh Vương said...

dịch vụ lau dọn nhà cửa,vệ sinh văn phòng,vệ sinh nhà cửa,giặt thảm,giặt ghế sofa,lau kính tòa nhà cao tầng ,dịch vụ vệ sinh sau xây dựng

Herry jonson said...

ARINET DBA Services is a Chicago, IL based organization established in 2013. Uniting more than 100+ years of combined involvement in giving quality Oracle database Support administrations to American organizations, we've given the diverse options about remote dba experts, remote dba organizations, remote dba reinforce, remote database, oracle remote, dba remote, database association, prophet dba reinforce, Oracle sponsorship and Oracle Consultants.

Sunita Yadav said...

Excellent Information
Target Discount Coupons

Zain Malik said...

350-018 braindumps - DumpsPortal assures you of exam success with money back guarantee. No need to bother of losing time and money. You are 100% safe with DumpsPortal.

sunny's said...

cinema box

blogger said...

Happy Friendship Day 2016 Whatsapp Status
Happy Friendship Day Images
Friendship Day Facebook Status

jon rai said...

Packers and movers in Bangalore @

Vi Chu said...

Thank you for such a sweet tutorial - all this time later, I've found it and love the end result. I appreciate the time you spent sharing your skills.
red ball 4 | ninjago games | swords and souls | strike force kitty 2 | run 2 | slitherio | | atari breakout

Bharath Gopalan said...

Very impressive and informative thanks for the great post.
size of skips

blogger said...

Happy Deepavali 2016
Diwali Festival Information & Wiki
Diwali Festival Information & Wiki
Happy Diwali 2016 Wallpapers
Happy Veterans Day 2016 Wallpapers
History of Veterans Day
History of Veterans Day
Happy Veterans Day Message for Cards
Happy Veterans Day Message for Cards
Happy Veterans Day 2016 Wallpapers

shahbaz said...

Hi! Thanks for the nice blog. The gift collection very good. Here is another site which contains a huge group of gift collection. We can buy them through online. Thanks for sharing, thanks for the

Aditya said...

I am very happy to discover your post as it will become on top in my collection of favorite blogs to visit.
imo beta
imo app
imo free video calls and text

Jai Bogle said...

Unique post! I have the similar thoughtful about this and I expectation you will segment additional post on this subject Dissertation Writers

rchandan said...

NEET 2017 Admit Card
NEET 2017 Results
neet cbse cutoff 2017CBSE NEET 2017 Counseling

sarah said...

I am really thankful to you, guys! I recommended you to my fellows. Hopefully, your service will stay that splendid.
Zoosk login

Post a Comment