'Replication' Tag

  • 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:

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

  • Using deep nested replication topologies

    June 2, 2014

    If you're running more than a few slaves in a replication topology, you might choose to use deeply nested replication: slaves replicating from other slaves at 2, 3 or even 4 levels. There are pros and cons to such topologies, discussed below. A simple, small deep nested topology is depicted below (it is also a […]

  • From Percona Server to MySQL and back to Percona Server: beware of crash safe replication info

    May 27, 2014

    We're migrating some of our "vanilla" MySQL 5.5 servers to Percona Server 5.5. One of the major incentives is the crash-safe replication feature, allowing slaves to die (power failure) and resume replication without losing position in relay logs. Whether or not we will migrate all our servers depends on further benchmarking; so far we've noticed […]

  • When you cannot replicate from master M to slave S

    April 28, 2014

    Working on some replication topology automation, here are some rules that will prevent you from replicating from a MySQL server M to a slave S: M does not have binary logs (log_bin) enabled M is itself a slave and does not have log_slave_updates enabled M has a higher major version than S (e.g. M is […]

  • The mystery of MySQL 5.6 excessive buffer pool flushing

    April 20, 2014

    I'm experimenting with upgrading to MySQL 5.6 and am experiencing an unexplained increase in disk I/O utilization. After discussing this with several people I'm publishing in the hope that someone has an enlightenment on this. We have a few dozens servers in a normal replication topology. On this particular replication topology we've already evaluated that […]

  • "Anemomaster": DML visibility. Your must-do for tomorrow

    April 18, 2014

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

  • The "once and for all" SHOW SLAVE STATUS log files & positions explained

    March 6, 2014

    True, GTID is upon us whether via MySQL 5.6 or Tungsten Replicator (and wasn't it in Google Patches since 2009?). But some of us are still using standard replication with MySQL 5.5, and the "what's with all these binary log files and positions" question is ever erupting. The output of SHOW SLAVE STATUS confuses people […]

  • Seconds_behind_master vs. Absolute slave lag

    January 24, 2014

    I am unable to bring myself to trust the Seconds_behind_master value on SHOW SLAVE STATUS. Even with MySQL 5.5's CHANGE MASTER TO ... MASTER_HEARTBEAT_PERIOD (good thing, applied when no traffic goes from master to slave) it's easy and common to find fluctuations in¬†Seconds_behind_master value. And, when sampled by your favourite monitoring tool, this often leads […]

 
Powered by Wordpress and MySQL. Theme by openark.org