Tag Archives: replication

On binlogs and datacenters

Posted on 2012/06/06 by

Once MySQL is deployed inside a datacenter environment (i.e. forms a cloud ;-), major feature in it becomes replication. It is used to maintain hot copies, standby copies, read-only copies, invalidate external systems, replicate to external systems, etc. If this … Continue reading →

Posted in mysql | Tagged , | 1 Comment

on MySQL replication prefetching

Posted on 2011/12/03 by

For the impatient ones, or ones that prefer code to narrative, go here. This is long overdue anyway, and Yoshinori already beat me, hehe… Our database environment is quite busy – there’re millions of row changes a second, millions of … Continue reading →

Posted in facebook, mysql | Tagged , | 4 Comments

On database write workload profiling

Posted on 2011/05/10 by

I always have difficulties with complex analysis schemes, so fall back to something that is somewhat easier. Or much easier. Here I will explain the super-powerful method of database write workload analysis. Doing any analysis on master servers is already … Continue reading →

Posted in facebook, mysql | Tagged , , | 5 Comments

On MySQL replication, again…

Posted on 2010/06/30 by

There are few things one is supposed to know about MySQL replication in production, as manual doesn’t always discuss things openly. This is small set of rules and advices I compiled (some apply to statement based replication only, but row … Continue reading →

Posted in mysql | Tagged , , | 9 Comments

on replication compatibility

Posted on 2009/12/05 by

Dear MySQL, I will do this to rest of your code, if you continue breaking replication for me. – Domas

Posted in mysql | Tagged ,

Evil replication management

Posted on 2009/07/30 by

When one wants to script automated replication chain building, certain things are quite annoying, like immutable replication configuration variables. For example, at certain moments log_slave_updates is more than needed, and thats what the server says: mysql> show variables like ‘log_slave_updates’; … Continue reading →

Posted in mysql | Tagged , , | 5 Comments

5.0 journal: various issues, replication prefetching, our branch

Posted on 2008/06/07 by

First of all, I have to apologize about some of my previous remark on 5.0 performance. I passed ‘-g’ CFLAGS to my build, and that replaced default ‘-O2′. Compiling MySQL without -O2 or -O3 makes it slower. Apparently, much slower. … Continue reading →

Posted in mysql, wikipedia, wikitech | Tagged , , , , , | 8 Comments

Trainwreck: external MySQL replication agent

Posted on 2008/05/14 by

I wanted to work more on the actual project before writing about it, but I’m lazy, and dear community may be not. At Wikimedia we have one database server which replicates from multiple (like 15!) masters. It even splits replication … Continue reading →

Posted in mysql | Tagged , , | 1 Comment

Replication will live!

Posted on 2008/04/12 by

Brian exposed some of his internal letters about death of replication (caused by memcached). Back when he wrote this, I responded back a bit too. Now as quite a few people really want to burry replication, let me point out … Continue reading →

Posted in mysql | Tagged , | 1 Comment