Tag Archives: replication

On MySQL replication, again…

Posted on June 30, 2010 by Domas Mituzas

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, some more

Posted on December 13, 2009 by Domas Mituzas

Dear MySQL, I feel ashamed that I ever wanted you to support 4.0->5.1 replication, and apologize for that. I really understand that it was really egoistic of me even to consider you should be involved in this. I even understand … Continue reading →

Posted in mysql | Tagged | 6 Comments

on replication compatibility

Posted on December 5, 2009 by Domas Mituzas

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

Posted in mysql | Tagged , | Comments Off

Evil replication management

Posted on July 30, 2009 by Domas Mituzas

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 June 7, 2008 by Domas Mituzas

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 | Tagged , , , , , | 8 Comments

Trainwreck: external MySQL replication agent

Posted on May 14, 2008 by Domas Mituzas

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 April 12, 2008 by Domas Mituzas

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