'MySQL' Category

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

  • On SHOW BINLOG/RELAYLOG EVENTS

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

  • Pseudo GTID, ASCENDING

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

  • "awesome-mysql" curated list created, open for pull requests

    April 28, 2015

    Following up on popular "awesome-*" lists (e.g. awesome-python, awesome-golang etc.), I've created the awesome-mysql curated list. This is a list of technologies (and resources) in and around MySQL, and means to serve as a place to find reliable software and info. I recently happened to notice there are some tools I'm familiar with that are […]

  • Percona Live 2015: Reflections

    April 18, 2015

    Some personal reflections on PerconaLive 2015: Percona acquires Tokutek Well done! Tokutek develops the TokuDB storage engine for MySQL and TokuMX engine for MongoDB. I will discuss the MySQL aspect only. TokuDB was released as open source in 2013. It has attained a lot of traction and I have used it myself for some time. […]

  • Percona Live 2015: Reflections; the Apache CCLA offer

    April 18, 2015

    Facebook, Google, Twitter, LinkedIn, Alibaba, MariaDB, Percona team up and offer Oracle all public changes under the Apache CCLA Read again please. My one word summary of this is: Romantic. In the most positive sense. Disclaimer: I am not a lawyer; this is my understanding of the current status and of the offer. Summarizing the […]

 
Powered by Wordpress and MySQL. Theme by openark.org