'Open Source' Tag

  • gh-ost 1.0.42 released: JSON support, optimizations

    September 14, 2017

    gh-ost 1.0.42 is released and available for download. JSON MySQL 5.7's JSON data type is now supported. There is a soft-limitation, that your JSON may not be part of your PRIMARY KEY. Currently this isn't even supported by MySQL anyhow. Performance Two noteworthy changes are: Client side prepared statements reduce network traffic and round trips […]

  • Speaking at Percona Live Dublin: keynote, orchestrator tutorial, MySQL testing automation

    September 13, 2017

    I'm looking forward to a busy Percona Live Dublin conference, delivering three talks. Chronologically, these are: Practical orchestrator tutorial Attend this 3 hour tutorial for a thorough overview on orchestrator: what, why, how to configure, best advice, deployments, failovers, security, high availability, common operations, ... We will of course discuss the new orchestrator/raft setup and […]

  • orchestrator 3.0.2 GA released: raft consensus, SQLite

    September 12, 2017

    orchestrator 3.0.2 GA is released and available for download (see also packagecloud repository). 3.0.2 is the first stable release in the 3.0* series, introducing (recap from 3.0 pre-release announcement): orchestrator/raft Raft is a consensus protocol, supporting leader election and consensus across a distributed system.  In an orchestrator/raft setup orchestrator nodes talk to each other via raft protocol, form consensus and […]

  • Speaking at August Penguin, MySQL Track, GitHub sponsored

    September 3, 2017

    This Thursday I'll be presenting at August Penguin, conveniently taking place September 7th, 8th, Ramat Gan, Israel. I will be speaking as part of the MySQL track, 2nd half of Thursday. The (Hebrew) schedule is here. My talk is titled Reliable failovers, safe schema migrations: open source solutions to MySQL problems. I will describe some […]

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

  • gh-ost 1.0.17: Hooks, Sub-second lag control, Amazon RDS and more

    September 6, 2016

    gh-ost version 1.0.17 is now released, with various additions and fixes. Here are some notes of interest: Hooks gh-ost now supports hooks. These are your own executables that gh-ost will invoke at particular points of interest (validation pass, about to cut-over, success, failure, status, etc.) gh-ost will set various environment variables for your executables to […]

  • Introducing gh-ost: triggerless online schema migrations

    August 1, 2016

    I'm thoroughly happy to introduce gh-ost: triggerless, controllable, auditable, testable, trusted online schema change tool released today by GitHub. gh-ost now powers our production schema migrations. We hit some serious limitations using pt-online-schema-change on our large volume, high traffic tables, to the effect of driving our database to a near grinding halt or even to the extent […]

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

 
Powered by Wordpress and MySQL. Theme by openark.org