'MySQL' Category

  • MySQL Community Awards 2015: Call for Nominations!

    February 6, 2015

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

  • Speaking at FOSDEM: Pseudo GTID and easy replication management

    January 29, 2015

    This coming Sunday I'll be presenting Pseudo GTID and easy replication management at FOSDEM, Brussels. There's been a lot of development on Pseudo GTID these last few weeks. In this talk I'll show you how you can use Pseudo GTID instead of "normal" GTID to easily repoint your slaves, recover from intermediate master failure, promote slaves to […]

  • Reading RBR binary logs with pt-query-digest

    January 26, 2015

    For purposes of auditing anything that goes on our servers we're looking to parse the binary logs of all servers (masters), as with "Anemomaster". With Row Based Replication this is problematic since pt-query-digest does not support parsing RBR binary logs (true for 2.2.12, latest at this time). I've written a simple script that translates RBR […]

  • Orchestrator 1.2.9 GA released

    December 18, 2014

    Orchestrator 1.2.9 GA has been released. Noteworthy: Added "ReadOnly" (true/false) configuration param. You can have orchestrator completely read-only Added "AuthenticationMethod": "multi": works like BasicAuth (your normal HTTP user+password) only it also accepts the special user called "readonly", which, surprise, can only view and not modify Centralized/serialized most backend database writes (with hundreds/thousands monitored servers it […]

  • Joining Booking.com

    November 14, 2014

    I'm excited to be joining Booking.com at the Netherlands in a couple weeks I'm looking forward to be working with a great team and friendly people! I hope to contribute from my experience and of course be challenged by difficult problems. Booking.com is a supporter of open source in multiple aspects, and I am looking […]

  • Semi-automatic slave/master promotion via Pseudo GTID

    November 10, 2014

    Orchestrator release 1.2.7-beta now supports semi-automatic slave promotion to master upon master death, via Pseudo GTID. When the master is dead, orchestrator automatically picks the most up-to-date slaves and marks them as "Master candidates". It allows a /api/make-master call on such a slave (S), in which case it uses Pseudo GTID to enslave its siblings, […]

  • Percona Live 2015: Call for Papers is open

    October 31, 2014

    And not for long! The Call for Papers for Percona Live MySQL Conference and Expo, to be held at Santa Clara in April 2015, is open. The dead line for submissions is Nov. 16th; that's just around the corner. As with previous years, we will hold a 4 day conference, the first being a tutorials […]

  • Refactoring replication topologies with Pseudo GTID: a visual tour

    October 27, 2014

    Orchestrator 1.2.1-beta supports Pseudo GTID (read announcement): a means to refactor the replication topology and connect slaves even without direct relationship; even across failed servers. This post illustrates two such scenarios and shows the visual way of mathcing/re-synching slaves. Of course, orchestrator is not just a GUI tool; anything done with drag-and-drop is also done […]

  • Orchestrator 1.2.1 BETA: Pseudo GTID support, reconnect slaves even after master failure

    October 27, 2014

    orchestrator 1.2.1 BETA is released. This version supports Pseudo GTID, and provides one with powerful refactoring of one's replication topologies, even across failed instances. Depicted: moving a slave up the topology even though its local master is inaccessible Enabling Pseudo-GTID You will need to: Inject a periodic unique entry onto your binary logs Configure orchestrator […]

  • Refactoring replication topology with Pseudo GTID

    October 23, 2014

    This post describes in detail the method of using Pseudo GTID to achieve unplanned replication topology changes, i.e. connecting two arbitrary slaves, or recovering from a master failure even as all its slaves are hanging in different positions. Please read Pseudo GTID and Pseudo GTID, RBR as introduction. Consider the following case: the master dies unexpectedly, […]

 
Powered by Wordpress and MySQL. Theme by openark.org