Facebook: embedding extra information in to the MySQL replication stream

[Brian Aker]

Hi!

On Apr 2, 2008, at 12:35 PM, Gabriel Laden wrote:
> Quote:
> Fortunately MySQL is open source software, meaning we can actually  
> change the way it works by modifying the code. We did just that— 
> embedding extra information in to the MySQL replication stream that  
> allows us to properly update memcached in Virginia. This ensures  
> that the cache and the database are always in sync.
>
>
> Was this code change released by Facebook ? We have exactly such a  
> need for this type of setup.

No, it was not. You can emulate this behavior by using the MySQL UDF  
in your queries, which is a better route to go for supportability.
http://tangent.org/586/Memcached_Functions_for_MySQL.html

Cheers,
	-Brian

--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/                     <-- Me
http://tangent.org/                <-- Software
_______________________________________________________
You can't grep a dead tree.