Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 12

Displaying posts with tag: MHA (reset)

MHA 0.56 is now available
+2 Vote Up -0Vote Down
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


  [Read more...]
High-availability options for MySQL, October 2013 update
+1 Vote Up -0Vote Down

The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a regular basis (hopefully, this is the first), an update on the most common technologies and their state, with a focus on what type of workloads suite them best. We restricted ourselves to the open source solutions that provide automatic failover. Of course, don’t simply look at the number of Positives/Negatives items, they don’t have the same values. Should you pick any of these technologies, heavy testing is mandatory, HA is never beyond scenario that have been tested.

Percona XtraDB  [Read more...]

Choosing a MySQL HA Solution – MySQL Webinar: June 5
+1 Vote Up -0Vote Down

Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives.  When too much attention is paid to one of these aspects at the cost of the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal.

On Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution, in

  [Read more...]
MHA & MariaDB Cassandra Interoperability talks
+1 Vote Up -0Vote Down

Together with Sergei Petrunia, we talked about MariaDB Cassandra Interoperability. Sergei has done wonderful work here and I plan to showcase more Cassandra integration going forward. It’s worth noting that Elena came up with the benchmarks for this talk as well.

MariaDB Cassandra Interoperability from Colin Charles

Later, I gave a talk on MHA. Competing in a timeslot with

  [Read more...]
MHA 0.54 & 0.55 – continually active development
+4 Vote Up -0Vote Down

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), one in time for my Percona Live London 2012 talk. Thanks Yoshi! Totally download MHA 0.55 which is still be actively developed & used in production at multiple locations.

Related posts:

  • Once again, a split in events
  • More MariaDB after Percona Live Santa
  •   [Read more...]
    New MySQL & MariaDB Instructional Videos from SkySQL
    +3 Vote Up -0Vote Down

    Are you looking to expand your knowledge about MySQL and MariaDB database solutions?

    Well, you’re in luck! SkySQL is introducing an exclusive collection of educational videos featuring some of the industry’s leading experts on the MySQL database and related technologies. View informative, technical talks on a variety of topics, from the experts at SkySQL, MariaDB, Calpont InfiniDB, Continuent, ScaleDB, Severalnines, Sphinx, Webyog, and others.

    read more

    The best MySQL multi-master solution gets even better
    +1 Vote Up -4Vote Down
    The best (and truly the only) MySQL multi-master, multi-site solution on the market gets even better! Continuent is happy to announce immediate availability of Continuent Tungsten 1.5.New Continuent Tungsten 1.5 allows you to build multi-site, disaster recovery (DR) and multi-master solutions with ease: Multi-Master Operations - Tungsten can support your multi-master operations today by linking
    New Continuent Tungsten 1.5 now available
    +0 Vote Up -0Vote Down
    The best MySQL high availability solution on the market gets even better! We are happy to announce immediate availability of Continuent Tungsten 1.5.New Continuent Tungsten 1.5 offers significant improvements that help you to deploy cost effective HA clusters fast include: Easy Installation - One-step command to deploy an entire Tungsten cluster in minutes, either in your data center or in
    MHA for MySQL 0.53 released
    +5 Vote Up -0Vote Down
     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











      [Read more...]
    Vote for MySQL[plus] awards 2011 !
    +5 Vote Up -0Vote Down

    First of all, I wish you a happy new year.
    Many things happened last year, it was really exciting to be involved in the MySQL ecosystem.
    I hope this enthusiasm will be increased this year, up to you !

    To start the year, I propose the MySQL[plus] Awards 2011
    It will only take 5 minutes to fill out these polls.
    Answer with your heart first and then with your experience with some of these tools or services.

    Polls will be closed January 31, so, vote now !
    For “other” answers, please,  let me a comment with details.

    Don’t hesitate to submit proposal for tools or services in the comments.






      [Read more...]
    MHA for MySQL 0.52 released
    +5 Vote Up -0Vote Down
     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







      [Read more...]
    MySQL tools article
    +1 Vote Up -0Vote Down

    Although I no longer maintain hackmysql.com, I still actively develop MySQL tools. An article I wrote, 10 essential MySQL tools for admin, was published today. I hope no one’s feelings are hurt if their tool isn’t in the list, but it was rather difficult to compile the list given that so many tools are either not actively developed, not tested, or not well documented. Given lag time between writing and publishing, I was not able to write about Yoshinori’s MHA or newer tools. And given length constraints, I was not able to write about more tools. In any case, the world of MySQL tools is alive and well.

    Showing entries 1 to 12

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.