zinfeflalyday
New Member
I don't know if this is possible, or if it even makes sense. If one would have say 2 servers for a web application, and one does an update on Server 1, server 2 wouldn't know about the update. This is especially problematic for caching, as the Server 2 would have a 'stale' copy of the cached item. Is there any way to 'notify' both servers, whenever say a database row is updated? The database in use is MySQL. If not, any ideas / best practices on how one would go about this? We are looking to move to a server-farm, and this is currently one of the most problematic issues we are finding.