'MySQL' Category

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

  • State of automated recovery via Pseudo-GTID & Orchestrator @ Booking.com

    November 20, 2015

    This post sums up some of my work on MySQL resilience and high availability at Booking.com by presenting the current state of automated master and intermediate master recoveries via Pseudo-GTID & Orchestrator. Booking.com uses many different MySQL topologies, of varying vendors, configurations and workloads: Oracle MySQL, MariaDB, statement based replication, row based replication, hybrid, OLTP, […]

  • Orchestrator & Pseudo-GTID for binlog reader failover

    November 19, 2015

    One of our internal apps at Booking.com audits changes to our tables on various clusters. We used to use tungsten replicator, but have since migrated onto our own solution. We have a binlog reader (uses open-replicator) running on a slave. It expects Row Based Replication, hence our slave runs with log-slave-updates, binlog-format='ROW', to translate from the […]

  • Thoughts on MaxScale automated failover (and Orchestrator)

    November 18, 2015

    Having attended a talk (as part of the MariaDB Developer Meeting in Amsterdam) about recent developments of MaxScale in executing automated failovers, here are some (late) observations of mine. I will begin by noting that the project is stated to be pre-production, and so of course none of the below are complaints, but rather food […]

  • SQL mini hack of the day, inverted IN clause

    November 13, 2015

    We are used to issue queries with an IN clause of the form: However I've had a few cases where I used an inverted format. Here's one use case followed by an inverted IN clause. Dynamic query building Say we have this function: Which, based on whether given clusterName is empty or not, would return […]

 
Powered by Wordpress and MySQL. Theme by openark.org