[HN Gopher] The Wonders of Postgres Logical Decoding Messages
       ___________________________________________________________________
        
       The Wonders of Postgres Logical Decoding Messages
        
       Author : rbanffy
       Score  : 11 points
       Date   : 2023-03-31 20:21 UTC (2 hours ago)
        
 (HTM) web link (www.infoq.com)
 (TXT) w3m dump (www.infoq.com)
        
       | simonw wrote:
       | I remember hearing years ago that Facebook used a trick like this
       | for cache invalidation: they would write custom "invalidate cache
       | X" messages (maybe even as SQL comments?) into their MySQL
       | replication streams that fanned out to multiple data centers,
       | such that a data center would know to clear a cached record out
       | of its local memcached cluster when the relevant MySQL rows were
       | updated.
        
       ___________________________________________________________________
       (page generated 2023-03-31 23:01 UTC)