What about caching the database itself on the application server? Is there some kind of SQL client library that can somehow cache records from the DB, and P2P

What about caching the database itself on the application server? Is there some kind of SQL client library that can somehow cache records from the DB, and P2P cache with other application servers, but then make sure everything is synced with the main server? Wouldn't it be ideal to have just the parts of the DB that each user needed kept close to that user?