'MySQL' Category

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

  • MySQL vs. PostgreSQL, gh-ost perspective

    August 11, 2016

    Last week we released gh-ost, GitHub's online schema migration tool for MySQL. As with other open source releases in the MySQL ecosystem, this release was echoed by several "Why not PostgreSQL?" comments. Having been active in open source since many years now, I'm familiar with these responses, and I find this is a good time […]

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

 
Powered by Wordpress and MySQL. Theme by openark.org