You may want to look at mysql_proxy and write a LUA program that does this
update for you.
e.m.g.
On Tue, Nov 11, 2008 at 1:50 PM, Aaron Stone <[EMAIL PROTECTED]> wrote:
>
> Sean Chittenden once had a system for updating memcached from
> PostgreSQL (or maybe it wasn't updating values, only expiring them?)
> called pg_memcached. I don't believe it's been maintained in a long
> time, but the idea is very similar.
>
> Aaron
>
>
> On Tue, Nov 11, 2008 at 12:49 PM, Matt Erkkila <[EMAIL PROTECTED]> wrote:
> > A couple things popped into my mind when i read this, some may apply some
> > may not.
> > I remember hearing that Facebook actually changed the parsing of MySQL
> query
> > language to support passing memcache keys across data centers. This was
> to
> > prevent an object from being expired/reloaded before the data actually
> > replicated from one data center to another.
> > So the SQL would look something like: UPDATE users SET password =
> > ('somepass') EXPIRE memcachekey1, memcachekey2
> > Maybe someone can speak more to this, I think there was a blog post or a
> > presentation released from them regarding this.
> > Also something to look into would be the MySQL UDF functions for
> memcached.
> > Last I saw they were available http://www.tangent.org/, although the
> site
> > seems to be down for me right now.
> > Matt
> > On Nov 11, 2008, at 12:41 PM, Brad Fitzpatrick wrote:
> >
> > [+memcached list]
> >
> > On Tue, Nov 11, 2008 at 12:09 PM, Lei Gao <[EMAIL PROTECTED]> wrote:
> >>
> >> Hi Brad,
> >>
> >> I am considering integrating memcached tightly with a database, mysql or
> >> oracle. I.e. I want the database to actively send updates to the
> memcached
> >> server. One way to do this is to create a memcached client program that
> gets
> >> the data from the database and store them into the memcached server via
> the
> >> client set API.
> >>
> >> Some concerns with this approach are 1. the client API seems limited to
> >> what I want to do in terms of keeping memcached server in sync. with the
> >> database; 2. the client API might be less efficient for loading data
> onto
> >> the server if the in-coming rate is high.
> >>
> >> Is it possible to create a memcached server extension to interface
> >> directly with the database?
> >>
> >> Thanks in advance.
> >>
> >> Lei
> >>
> >> On Mon, Jun 23, 2008 at 4:00 PM, Brad Fitzpatrick <[EMAIL PROTECTED]>
> wrote:
> >>>
> >>> It doesn't.
> >>>
> >>> If that matters for you, don't cache that entity, or set a low
> expiration
> >>> timeout.
> >>>
> >>> On Mon, Jun 23, 2008 at 3:52 PM, Lei Gao <[EMAIL PROTECTED]> wrote:
> >>>>
> >>>> Hi Brad,
> >>>>
> >>>> I am an academic researcher in computer sciences at UT Austin. I have
> a
> >>>> simple question about memcached. (I got your email address at the end
> of one
> >>>> of your articles about memcached). How does the memcached handle the
> >>>> situation where the databased is updated from a non-memcached-aware
> party?
> >>>> For instance, my system admin updates the some database records that
> are
> >>>> cached in one or more memcached instance, how do those instances
> refresh
> >>>> themselves? (Another example is when the database is replicated and
> updates
> >>>> take place on all replicas.)
> >>>>
> >>>> Thanks,
> >>>>
> >>>> --
> >>>> Lei Gao
> >>
> >>
> >>
> >> --
> >> Lei Gao
> >
> >
> >
>
