• vote
    26
    0 starsderek | Shared With: Everyone - Aug 21 2008 | mysql, hacks, facebook, scaling, data center
    Facebook | Engineering @ Facebook's Notes

    Interesting writeup of hacking MySQL to dirty memcached entries after replication sync.

    Quoted: REPLACE INTO profile (`first_name`) VALUES ('Monkey') WHERE `user_id`='jsobel' MEMCACHE_DIRTY 'jsobel:first_name'

    Showing 1 - 2 of 2 comments
    • mohit - Aug 21 2008

      i also found it interesting that all their write operations happen in one location. adding this constraint does make it easier to build out a distributed data center so long as you are disciplined about minimizing writes in 'normal' conditions.

    • derek - Aug 21 2008

      Yeah -- well, database writes anyways ... I'm sure many gigabytes of log files are generated in the replicated environment with all sorts of interesting information.

    You must be Derek's friend before you can comment on this Fave.
    Send Derek a friend request or a personal message instead.

Related Faves from derek