'MySQL' Category

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

  • "MySQL High Availability tools" followup, the missing piece: orchestrator

    April 6, 2017

    I read with interest MySQL High Availability tools - Comparing MHA, MRM and ClusterControl by SeveralNines. I thought there was a missing piece in the comparison: orchestrator, and that as result the comparion was missing scope and context. I'd like to add my thoughts on topics addressed in the post. I'm by no means an […]

  • MySQL Community Awards 2017: Call for Nominations!

    March 16, 2017

    The 2017 MySQL Community Awards event will take place, as usual, in Santa Clara, during the Percona Live Data Performance Conference, April 2017. The MySQL Community Awards is a community based initiative. The idea is to publicly recognize contributors to the MySQL ecosystem. The entire process of discussing, voting and awarding is controlled by an independent […]

  • orchestrator Puppet module now available

    February 1, 2017

    We have just open sourced and published an orchestrator puppet module. This module is authored by Tom Krouper of GitHub's database infrastructure team, and is what we use internally at GitHub for deploying orchestrator. The module manages the orchestrator service, the config file (inherit to override values), etc (pun intended). Check it out!    

  • Some observations on MySQL to sqlite migration & compatibility

    January 30, 2017

    I'm experimenting with sqlite as backend database for orchestrator. While orchestrator manages MySQL replication topologies, it also uses MySQL as backend. For some deployments, and I'm looking into such one, having MySQL as backend is a considerable overhead. This sent me to the route of looking into a self contained orchestrator binary + backend DB. I would […]

  • Discussing online schema migrations with Oracle's MySQL engineering managers

    November 23, 2016

    Last week I had the pleasant opportunity of introducing and discussing the operation of online schema migrations to MySQL's engineering managers, as part of their annual meeting, in London. Together with Simon J. Mudd of Booking.com, we discussed our perception of what it takes to run online schema migrations on a live, busy system. While […]

  • Three wishes for a new year

    September 28, 2016

    (Almost) another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Relaxed GTID constraints I'm still not using GTID, and still see operational issues with working with GTID. As a latest example, our new schema migration solution, gh-ost, allows us to test migrations in production, […]

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

 
Powered by Wordpress and MySQL. Theme by openark.org