'MySQL' Category

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

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

  • MySQL Community Awards 2016: the Winners

    April 22, 2016

    The MySQL Community Awards initiative is an effort to acknowledge and thank individuals and corporates for their contributions to the MySQL ecosystem. It is a from-the-community, by-the-community and for-the-community effort. The committee is composed of an independent group of community members of different orientation and opinion, themselves past winners or known contributors to the community. […]

  • MySQL Community Awards 2016: Call for Nominations!

    February 5, 2016

    The 2016 MySQL Community Awards event will take place, as usual, in Santa Clara, during the Percona Live Data Performance Conference, April 2016. 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 group […]

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

Powered by Wordpress and MySQL. Theme by openark.org