'MySQL' Category

  • Percona Live Amsterdam: Community Dinner, last updates

    September 18, 2015

    Registration for the Percona Live Amsterdam conference community dinner at Booking.com is ongoing. Please note the following: By Monday noon the kitchen will make the necessary purchasing. At this time we will have to give them a number, which we will not exceed. The number we will give them is $(number of registrants Monday 12:00) + […]

  • Speaking at Percona Live Amsterdam: Orchestrator

    September 15, 2015

    In a week's time I'll be speaking at Percona Live Amsterdam. I will be presenting: Managing and Visualizing your replication topologies with Orchestrator 23 September 4:20PM This talk will present orchestrator, on which I've been working for the last year and a half, originally at Outbrain and now at Booking.com. I will show off what orchestrator can […]

  • Three wishes for a new year

    September 14, 2015

    Another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Decent, operations friendly built in online table refactoring The existing online ALTER TABLE solution is still not there. It does not take into consideration the load on the server. In replication stream it's serialized just […]

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

  • Percona Live Amsterdam: Community Dinner, Sep. 22nd

    August 13, 2015

    Keeping up with tradition, there will be a community event held at the upcoming Percona Live Europe: Amsterdam 2015 conference. This year, Booking.com will be hosting the event at the company's headquarters in the heart of Amsterdam. We will hold a community dinner (dish selection, includes vegetarian; beverages will be served) in our caffeteria and hope […]

  • Baffling 5.7 global/status variables issues, unclean migration path

    August 7, 2015

    MySQL 5.7 introduces a change in the way we query for global variables and status variables: the INFORMATION_SCHEMA.(GLOBAL|SESSION)_(VARIABLES|STATUS) tables are now deprecated and empty. Instead, we are to use the respective performance_schema.(global|session)_(variables|status) tables. But the change goes farther than that; there is also a security change. Oracle created a pitfall of 2 changes at the same time: […]


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

Powered by Wordpress and MySQL. Theme by openark.org