Transparent failover and restore?

[Kevin A. Burton]

Brad Fitzpatrick wrote:

>Guys,
>
>If you want to use memcached as a data store instead of a /cache/, then
>use MySQL Cluster:
>
>   http://www.mysql.com/cluster/
>
>It was designed for that, doing the whole redundant storage and two-phase
>commit thing, while memcached was designed to be a cache.
>  
>
I've also thought of using MySQLs memory tables as an LRU cache as a 
memcached replacement. It would support btree indexing, hash indexing, 
replicated data, etc. The client would have to route storage of the keys 
via hash() % Nservers but this isn't hard. The big downside is that (at 
least in Java) the MySQL JDBC driver is about 1ms where it seems that an 
optimized memcached could perform 500 gets() per 1ms.

Of course that argument is negated a bit if the mysql driver could be 
made more efficient.

Theres also the added benefit that (maybe) MySQL would have better 
memory storage since it knows the exact object size due to schema and 
coudl serialize correctly espcially if you use an OR layer. Though my 
recent patches to java-memcached make it use a LOT less memory so this 
might be irrelevant.

Kevin

-- 

Use Rojo (RSS/Atom aggregator).  Visit http://rojo.com. Ask me for an 
invite!  Also see irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html

If you're interested in RSS, Weblogs, Social Networking, etc... then you 
should work for Rojo!  If you recommend someone and we hire them you'll 
get a free iPod!
    
Kevin A. Burton, Location - San Francisco, CA
       AIM/YIM - sfburtonator,  Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412