'Open Source' Tag

  • Solving the non-atomic table swap, Take III: making it atomic

    July 7, 2016

    With the unintended impression of becoming live blogging, we now follow up on Solving the non-atomic table swap, Take II and Solving the Facebook-OSC non-atomic table swap problem with a safe, blocking, atomic solution Why yet another iteration? The solution presented in Solving the non-atomic table swap, Take II was good, in that it was […]

  • Solving the non-atomic table swap, Take II

    June 20, 2016

    Following up and improving on Solving the Facebook-OSC non-atomic table swap problem, we present a better, safe solution. Quick, quickest recap: We are working on a triggerless online schema migration solution. It is based on an asynchronous approach, similarly to the FB osc and as opposed to the synchronous solution as used by pt-online-schema-change. We asynchronously synchronize […]

  • Solving the Facebook-OSC non-atomic table swap problem

    May 3, 2016

    We present a way to use an atomic, blocking table swap in the Facebook Online-Schema-Change solution, as well as in a rumored, other Online-Schema-rumored-Change solution. Update: also a caveat. Quick recap (really quick) pt-online-schema-change and facebook-osc are two popular online-schema-change solutions for MySQL. They both use triggers, but in different ways. While the Percona tool […]

  • Orchestrator progress

    December 23, 2015

    This comes mostly to reassure, having moved into GitHub: orchestrator development continues. I will have the privilege of working on this open source solution in GitHub. There are a few directions we can take orchestrator to, and we will be looking into the possibilities. We will continue to strengthen the crash recovery process, and in […]

  • Joining GitHub

    November 30, 2015

    Today was my last day at Booking.com, and shortly I will be joining the team at GitHub. I'd like to thank the many kind, friendly & smart people I've worked with at Booking.com! The challenges at Booking.com are big. There is such a diversity within the technology stack; even within the database range. A solution that […]

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

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

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

 
Powered by Wordpress and MySQL. Theme by openark.org