'MySQL' Category

  • orchestrator 3.0.3: auto provisioning raft nodes, native Consul support and more

    November 16, 2017

    orchestrator 3.0.3 is released! There's been a lot going on since 3.0.2: orchestrator/raft: auto-provisioning nodes via lightweight snaphsots In an orchestrator/raft setup, we have n hosts forming a raft cluster. In a 3-node setup, for example, one node can go down, and still the remaining two will form a consensus, keeping the service operational. What […]

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

  • Remembering Jaakko Pesonen

    September 9, 2017

    I was sorrowed to hear that Jaakko Pesonen has passed away after battling cancer. I first met Jaakko a few years back, during a Percona Live conference, and as community goes, our paths crossed again a few times. He spoke at and attended conferences where we'd have casual chats. We were both expats in the Netherlands […]

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

  • What's so complicated about a master failover?

    June 29, 2017

    The more work on orchestrator, the more user input and the more production experience, the more insights I get into MySQL master recoveries. I'd like to share the complexities in correctly running general-purpose master failovers; from picking up the right candidates to finalizing the promotion. The TL;DR is: we're often unaware of just how things […]

  • Observations on the hashicorp/raft library, and notes on RDBMS

    June 20, 2017

    The hashicorp/raft library is a Go library to provide consensus via Raft protocol implementation. It is the underlying library behind Hashicorp's Consul. I've had the opportunity to work with this library a couple projects, namely freno and orchestrator. Here are a few observations on working with this library: TL;DR on Raft: a group communication protocol; […]

  • Practical Orchestrator, BoF, GitHub and other talks at Percona Live 2017

    April 19, 2017

    Next week I will be presenting Practical Orchestrator at Percona Live, Santa Clara. As opposed to previous orchestrator talks I gave, and which were either high level or algorithmic talks, Practical Orchestrator will be, well... practical. The objective for this talk is that attendees leave the classroom with a good grasp of orchestrator's powers, and […]

 
Powered by Wordpress and MySQL. Theme by openark.org