Rich Lafferty's LiveJournal (mendel) wrote,
Rich Lafferty's LiveJournal

  • Mood:

mysql replication

brad's mysqlcon presentation has me thinking out some of the ways we (mis)use MySQL replication at Mitel. Most of it comes down to working on elegance -- in a lot of places I think I'm doing things that work as intended, but are pretty far away from the Right Way. So now I'm trying a whole bunch of things to build confidence in the Right Way of doing things.

In doing so I have come to the following conclusions:

  • For databases of non-trivial size and indices, mysqldump is not useful, because rebuilding the indices takes ridiculously long compared to any solutions that involve copying around raw data (replication, mysqlhotcopy, stop/cp/start).
  • For replication over a WAN rather than a LAN, LOAD DATA FROM MASTER is not useful because it takes so long and so much bandwidth compared to locking, taking a local snapshot, unlocking, rsyncing to the slave, and resetting master and slave binlogs.
Thoughts? For the record, we're still all MyISAM, with our largest tables about 1.5GB (and the whole database about 5GB) and sites connected via a ~2Mb VPN over the Internet.

  • New Year's resolution

    I'm going to post this on my zen blog later this week, but right now I want to post it somewhere and I'm too tired to compose a post over…

  • how's this work again

    So uh hi there everyone, long time no see? So I've got this theory where I think it'd be good for me to just write about stuff that's going on here,…

  • o hai lj.

    I should totally start using this again.

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded