'MySQL' Category

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

  • Leader election using MySQL

    October 14, 2015

    Being a stateful, centralized datastore, MySQL can serve in negotiating leadership: a mechanism to elect a single service out of multiple services; moreover, a mechanism to promote a new leader should the existing leader cease to function. What of Zookeeper? Zookeeper makes for an excellent leader election mechanism. This is one of the most recognized uses for […]

  • New statements I'd like to see in MySQL 5.8

    October 8, 2015

    Following up on New features I'd like to see in MySQL 5.8, here are statements I would like to see in MySQL 5.8: ENABLE EVENTS; When promoting a slave to master, I want to be able to enable all those events that are in SLAVESIDE_DISABLED state. Today I script an iteration over the events an constructing […]

  • New features I'd like to see in MySQL 5.8

    October 7, 2015

    Following up on Morgan Tocker's What would you like to see in MySQL 5.8?, having attended and participated at the brainstorming at Percona Live Amsterdam, and publishing this post while failing to comply with any of Morgan's suggested media, these are the features I would like to see in MySQL 5.8: Dynamicly enable/disable log-bin and log-slave-updates Today, when […]

  • Percona Live Amsterdam: Community Dinner, last updates

    September 18, 2015

    Registration for the Percona Live Amsterdam conference community dinner at Booking.com is ongoing. Please note the following: By Monday noon the kitchen will make the necessary purchasing. At this time we will have to give them a number, which we will not exceed. The number we will give them is $(number of registrants Monday 12:00) + […]

  • Speaking at Percona Live Amsterdam: Orchestrator

    September 15, 2015

    In a week's time I'll be speaking at Percona Live Amsterdam. I will be presenting: Managing and Visualizing your replication topologies with Orchestrator 23 September 4:20PM This talk will present orchestrator, on which I've been working for the last year and a half, originally at Outbrain and now at Booking.com. I will show off what orchestrator can […]

  • Three wishes for a new year

    September 14, 2015

    Another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Decent, operations friendly built in online table refactoring The existing online ALTER TABLE solution is still not there. It does not take into consideration the load on the server. In replication stream it's serialized just […]

Powered by Wordpress and MySQL. Theme by openark.org