'Replication' Tag

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


    August 4, 2015

    Some notes after working with SHOW BINLOG EVENTS and SHOW RELAYLOG EVENTS statements; there are a few gotchas and some interesting facts. My reflections also follow. I'm calling these commands from orchestrator when working with Pseudo-GTID (which I do alot). I prefer to work with agent-free design, where a single, remote service can do everything: examine […]


    July 29, 2015

    Pseudo GTID is a technique where we inject Globally Unique entries into MySQL, gaining GTID abilities without using GTID. It is supported by orchestrator and described in more detail here, here and here. Quick recap: we can join two slaves to replicate from one another even if they never were in parent-child relationship, based on our […]

  • What makes a MySQL server failure/recovery case?

    July 25, 2015

    Or: How do you reach the conclusion your MySQL master/intermediate-master is dead and must be recovered? This is an attempt at making a holistic diagnosis of our replication topologies. The aim is to cover obvious and not-so-obvious crash scenarios, and to be able to act accordingly and heal the topology. At Booking.com we are dealing with […]

  • Orchestrator visual cheatsheet

    June 5, 2015

    Orchestrator is growing. Supporting automatic detection of topologies, simple refactoring of topology trees, complex refactoring via Pseudo-GTID, failure detection and automated discovery, it is becoming larger and larger by the day. One of the problems with growign projects is hwo to properly document them. Orchestrator enjoys a comprehensive manual, but as these get more and […]

  • Speaking at Percona Live: Pseudo GTID and Easy Replication Topology Management

    March 31, 2015

    In two weeks time I will be presenting Pseudo GTID and Easy Replication Topology Management at Percona Live. From the time I submitted the proposal a LOT has been developed, experimented, deployed and used with both Pseudo GTID and with orchestrator. In my talk I will: Suggest that you skip the "to GTID or not to GTID" question […]

  • Speaking at FOSDEM: Pseudo GTID and easy replication management

    January 29, 2015

    This coming Sunday I'll be presenting Pseudo GTID and easy replication management at FOSDEM, Brussels. There's been a lot of development on Pseudo GTID these last few weeks. In this talk I'll show you how you can use Pseudo GTID instead of "normal" GTID to easily repoint your slaves, recover from intermediate master failure, promote slaves to […]

  • Reading RBR binary logs with pt-query-digest

    January 26, 2015

    For purposes of auditing anything that goes on our servers we're looking to parse the binary logs of all servers (masters), as with "Anemomaster". With Row Based Replication this is problematic since pt-query-digest does not support parsing RBR binary logs (true for 2.2.12, latest at this time). I've written a simple script that translates RBR […]

Powered by Wordpress and MySQL. Theme by openark.org