'MySQL' Category

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

  • Pseudo GTID, Row Based Replication

    October 23, 2014

    This post continues Pseudo GTID, in a series of posts describing an alternative to using MySQL GTIDs. The solution offered in the last post does not work too well for row based replication. The binary log entries for the INSERT statement look like this: # at 1020 # at 1074 #141020 12:36:21 server id 1¬† […]

  • Pseudo GTID

    October 22, 2014

    Pseudo GTID is a method to implement a GTID-like solution where slaves are easily connected to one another. This blog post and the following ones will describe work in progress (some 80% completed), where simulation of GTID makes for a good enough basis for refactoring replication topologies. I'm coding this in orchestrator, which already provides […]

  • Making UUID() and RAND() replication safe

    October 20, 2014

    MySQL's UUID() and RAND() functions both provide with (pseudo) indeterministic result. UUID()'s result is moreover bound to the host on which it executes. For this reason, both are unsafe to replicate with STATEMENT binlog format. As an example, consider: master> create table test.uuid_test (id int, u varchar(64)); master> insert into test.uuid_test values (1, UUID()); Query […]

  • orchestrator 1.1.18: new features, support for orchestrator-agent

    October 13, 2014

    Outbrain's orchestrator 1.1.18 is released: Support for orchestrator-agent (see announcement): agent pages, support for agent actions, initiation of seeds (provisioning of new/corrupted servers), auditing of seeds. Clusters dashboard Support for long query auditing SSL Proxy authentication (e.g. apache2 serving as reverse-proxy with LDAP) User control Better slave moving rules. Quick links: Get orchestrator 1.1.18 Read […]

 
Powered by Wordpress and MySQL. Theme by openark.org