I want to cache mysql tables (key: id, value: row in serialized bytes) into redis. The cache must support TTL and size limit in bytes for each table.
For example: table user
can use 100MB cache, table device
can use 100MB cache.
I tried to implement TTL and size limit in application layer but there is too much overhead in managing and monitoring key expiration.
Anyone know any idea or open source that has done it?