'Replication' 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 […]

  • Discussing online schema migrations with Oracle's MySQL engineering managers

    November 23, 2016

    Last week I had the pleasant opportunity of introducing and discussing the operation of online schema migrations to MySQL's engineering managers, as part of their annual meeting, in London. Together with Simon J. Mudd of Booking.com, we discussed our perception of what it takes to run online schema migrations on a live, busy system. While […]

  • Three wishes for a new year

    September 28, 2016

    (Almost) another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Relaxed GTID constraints I'm still not using GTID, and still see operational issues with working with GTID. As a latest example, our new schema migration solution, gh-ost, allows us to test migrations in production, […]

  • 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, […]

  • Orchestrator & Pseudo-GTID for binlog reader failover

    November 19, 2015

    One of our internal apps at Booking.com audits changes to our tables on various clusters. We used to use tungsten replicator, but have since migrated onto our own solution. We have a binlog reader (uses open-replicator) running on a slave. It expects Row Based Replication, hence our slave runs with log-slave-updates, binlog-format='ROW', to translate from the […]

  • New features I'd like to see in MySQL 5.8

    October 7, 2015

    Following up on Morgan Tocker's What would you like to see in MySQL 5.8?, having attended and participated at the brainstorming at Percona Live Amsterdam, and publishing this post while failing to comply with any of Morgan's suggested media, these are the features I would like to see in MySQL 5.8: Dynamicly enable/disable log-bin and log-slave-updates Today, when […]

  • Orchestrator visual cheatsheet, TL;DR the "smart" way

    September 2, 2015

    Orchestrator is really growing. And the amount of users (DBAs, sys admins) using it is growing. Which gives me a lot of immediate feedback in the form of "Look, there's just too many options to move slaves around! Which ones should we use?" TL;DR look at the two visualized commands below They are enough The "smart" commands to […]

  • Orchestrator 1.4.340: GTID, binlog servers, Smart Mode, failovers and lots of goodies

    September 1, 2015

    Orchestrator 1.4.340 is released. Not quite competing with the MySQL latest changelog, and as I haven't blogged about orchestrator featureset in a while, this is a quick listing of orchestrator features available since my last publication: Supports GTID (Oracle & MariaDB) GTID still not being used in automated recovery -- in progress. enable-gtid, disable-gtid, skip-query for GTID commands […]

 
Powered by Wordpress and MySQL. Theme by openark.org