Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 1162 10 Older Entries

Displaying posts with tag: Open Source (reset)

orchestrator 1.1.18: new features, support for orchestrator-agent
+0 Vote Up -0Vote Down

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:

  [Read more...]
Announcing orchestrator-agent
+0 Vote Up -0Vote Down

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 it as open source, only a small part of its functionality will appeal to the public (this is why it's not strictly part of the orchestrator project, which is a general purpose, wide-audience solution). Nevertheless, it is a simple implementation of a daemon, such that can be easily extended by

  [Read more...]
Tracing down a problem, finding sloppy code
+0 Vote Up -0Vote Down

Daniel was tracking down what appeared to be a networking problem….

  • server reported 113 (No route to host)
  • However, an strace did not reveal the networking stack ever returning that.
  • On the other side, IP packets were actually received.
  • When confronted with mysteries like this, I get suspicious – mainly of (fellow) programmers.
  • I suggested a grep through the source code, which revealed  return -EHOSTUNREACH;
  • Mystery solved, which allowed us to find what was actually going on.

Lessons:

  • Don’t just believe or presume the supposed origin of an error.
  • Programmers often take shortcuts that cause grief later. I fully appreciate how the above code came about, but I still think it was wrong. Mapping a
  •   [Read more...]
    Workbench 6.2, CakePHP’s new ORM, and OKC Meetup on Wednesday
    Employee +1 Vote Up -0Vote Down

    In the beginning was the MySQL command line and it was good. Verbose yes, error prone yes, and even tedious. But it was good. The UPDATE USER set SELECT_PRIV=’Y’, DROP_PRIV_’Y”, UPDATE_PRIV=’Y’,……,LAST_BLOODY_PRIV=’Y”; type errors have caught of us old timers. But it was still good.

    Then came some GUI tools that were okay. Not great but they had their uses.

    And then came MySQL Workbench. And it was very good.

    Now there is MySQL Workbench 6.2 and it is excellent. It came out in Beta last week and has built on the proven success of its predecessors. All the usual stuff is there – Server Status, Users & Privileges, Startup/Shutdown, logs, Dashboard, Performance Reports and more. But there area whole bunch of subtle little tweaks that make it easier

      [Read more...]
    Orchestrator 1.0.5: refactoring masters, multi-master replication
    +0 Vote Up -0Vote Down

    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:

      [Read more...]
    Orchestrator 1.0.4 released
    +1 Vote Up -0Vote Down

    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:

      [Read more...]
    On PostgreSQL. Interview with Bruce Momjian.
    +0 Vote Up -0Vote Down

    “There are four things that motivate open source development teams:
    1. The challenge/puzzle of programming, 2. Need for the software, 3. Personal advancement, 4. Belief in open source”
    — Bruce Momjian.

    On PostgreSQL and the challenges of motivating and managing open source teams, I have interviewed Bruce Momjian, Senior Database Architect at EnterpriseDB, and Co-founder of the PostgreSQL Global Development Group and Core Contributor.

    RVZ

    Q1. How did you manage to transform PostgreSQL from an abandoned academic project into a commercially viable, now enterprise relational database?


      [Read more...]
    Introducing Orchestrator: manage and visualize your MySQL replication topologies and get home for dinner
    +1 Vote Up -0Vote Down

    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 an up to date topology map.
    • It visualizes the topology in a clear and slick D3 tree.
    • It allows you
      [Read more...]
    "Anemomaster": DML visibility. Your must-do for tomorrow
    +0 Vote Up -0Vote Down

    Here's our take of master DML query monitoring at Outbrain (presented April 2014). It took a half-day to code, implement, automate and deploy, and within the first hour of work we managed to catch multiple ill-doing services and scripts. You might want to try this out for yourself.

    What's this about?

    What queries do you monitor on your MySQL servers? Many don't monitor queries at all, and only look up slow queries on occasion, using pt-query-digest. Some monitor slow queries, where Anemometer (relying on pt-query-digest) is a very good tool. To the extreme, some monitor TCP traffic

      [Read more...]
    Open Source Appreciation Day at Percona Live
    +0 Vote Up -0Vote Down

    I wrote previously about Percona Live Santa Clara 2014, and I want to bring to your attention something Percona has done that is very nice to open source communities: have an open source appreciation day.

    Its before the conference (so on Monday), and you get a choice between the CentOS Dojo (great lineup there including many from Red Hat, Monty from MariaDB, and PeterZ from Percona) or the OpenStack

      [Read more...]
    Showing entries 1 to 10 of 1162 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.