'MySQL' Category

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

  • Announcing orchestrator-agent

    October 13, 2014

    orchestrator-agent is a side-kick, complementary project of orchestrator, implementing a daemon service on one's MySQL hosts which communicates with and accepts commands from orchestrator, built with the original purpose of providing an automated solution for provisioning new or corrupted slaves. It was built by Outbrain, with Outbrain's specific use case in mind. While we release […]

  • Get per-object grants via common_schema

    September 29, 2014

    Did you know common_schema supports a complete breakdown of all accounts on your database server? It can provide you with the GRANT statements required to set up an account, the REVOKE statements to undo the former, and this can be broken down on a per-object & per-object-type basis. Consider the sql_grants view: Find who has […]

  • Three wishes for a new year

    September 23, 2014

    Another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Multi-core execution for queries After having evaluated a few columnar databases, and having seen how a single query gets 24 cores busy, I can't look at MySQL the same way again. The fact that a […]

  • Orchestrator 1.0.5: refactoring masters, multi-master replication

    August 6, 2014

    Outbrain's orchestrator Version 1.0.5 is released. Quick links: Orchestrator Manual, FAQ, Downloads Orchestrator now supports refactoring of masters via master-master topologies. It now allows promoting slaves as co-masters and detachment of instances from a co-master topology, effectively allowing for replacing an active master. Like this Drag a master: Onto one of its slaves:

  • Orchestrator 1.0.4 released

    July 29, 2014

    Outbrain's orchestrator Version 1.0.4 is released. Quick links: Orchestrator Manual, FAQ, Downloads What's new? Co-masters orchestrator now does a much better visualization of Master-Master replication:

  • Some MySQL security tips

    July 28, 2014

    This is a brief list of security tips for MySQL. It is by no means complete. Follow the sudo example. Don't let all you DBAs and Ops have the password for the root account. Have each and every one of them have their own personal super-duper account, with their own personal and private password. This […]

  • Introducing Orchestrator: manage and visualize your MySQL replication topologies and get home for dinner

    June 9, 2014

    I'm happy to announce the availability of Outbrain's Orchestrator: MySQL replication management & visualization tool. Orchestrator reads your replication topologies (give it one server - be it master or slave - in each topology, and it will reveal the rest). It keeps a state of this topology. It can continuously poll your servers to get […]

 
Powered by Wordpress and MySQL. Theme by openark.org