'High availability' Tag

  • orchestrator/raft: Pre-Release 3.0

    August 3, 2017

    orchestrator 3.0 Pre-Release is now available. Most notable are Raft consensus, SQLite backend support, orchestrator-client no-binary-required client script. TL;DR You may now set up high availability for orchestrator via raft consensus, without need to set up high availability for orchestrator's backend MySQL servers (such as Galera/InnoDB Cluster). In fact, you can run a orchestrator/raft setup […]

  • What's so complicated about a master failover?

    June 29, 2017

    The more work on orchestrator, the more user input and the more production experience, the more insights I get into MySQL master recoveries. I'd like to share the complexities in correctly running general-purpose master failovers; from picking up the right candidates to finalizing the promotion. The TL;DR is: we're often unaware of just how things […]

  • "MySQL High Availability tools" followup, the missing piece: orchestrator

    April 6, 2017

    I read with interest MySQL High Availability tools - Comparing MHA, MRM and ClusterControl by SeveralNines. I thought there was a missing piece in the comparison: orchestrator, and that as result the comparion was missing scope and context. I'd like to add my thoughts on topics addressed in the post. I'm by no means an […]

  • State of automated recovery via Pseudo-GTID & Orchestrator @ Booking.com

    November 20, 2015

    This post sums up some of my work on MySQL resilience and high availability at Booking.com by presenting the current state of automated master and intermediate master recoveries via Pseudo-GTID & Orchestrator. Booking.com uses many different MySQL topologies, of varying vendors, configurations and workloads: Oracle MySQL, MariaDB, statement based replication, row based replication, hybrid, OLTP, […]

  • Thoughts on MaxScale automated failover (and Orchestrator)

    November 18, 2015

    Having attended a talk (as part of the MariaDB Developer Meeting in Amsterdam) about recent developments of MaxScale in executing automated failovers, here are some (late) observations of mine. I will begin by noting that the project is stated to be pre-production, and so of course none of the below are complaints, but rather food […]

  • Problems with MMM for MySQL

    May 16, 2011

    I recently encountered troubling issues with MMM for MySQL deployments, leading me to the decision to cease using it on production. At the very same day I started writing about it, Baron published What's wrong with MMM?. I wish to present the problems I encountered and the reasons I find MMM is flawed. In a […]

  • MMM for MySQL single reader role

    August 12, 2010

    The standard documentation and tutorials on MMM for MySQL, for master-master replication setup, suggest one Virtual IP for the writer role, and two Virtual IPs for the reader role. It can be desired to only have a single virtual IP for the reader role, as explained below. The two IPs for the reader role A […]

 
Powered by Wordpress and MySQL. Theme by openark.org