hi guys, today i have a single case where i have a table with one integer primary key column, and many fields
i have a cache in my memcache daemond with key = integer column, and value= json of the row
in other words....
could we provide a GET like memcache return with a JSON interpretation?
for example....
connect via memcached on mariadb server memcache port
GET database.table.primary_key_value
it return a JSON of the row
SET database.table.primary_key_value = JSON
it set the fields inside JSON at the right row
it´s just a idea, since i have a very good boost of performace when implementing a cache, but i have a very bad performace when i have many writes since i need to invalidade the cache and write the database after it put the new value to cache, or wait the next read to update the cache
ok we have the HANDLER protocol, but i have some apps with memcache interface, could be nice to implement it direct on mariadb...
thanks guys!
hi guys, today i have a single case where i have a table with one integer primary key column, and many fields
i have a cache in my memcache daemond with key = integer column, and value= json of the row
in other words....
could we provide a GET like memcache return with a JSON interpretation?
for example....
connect via memcached on mariadb server memcache port
GET database.table.primary_key_value
it return a JSON of the row
SET database.table.primary_key_value = JSON
it set the fields inside JSON at the right row
it´s just a idea, since i have a very good boost of performace when implementing a cache, but i have a very bad performace when i have many writes since i need to invalidade the cache and write the database after it put the new value to cache, or wait the next read to update the cache
ok we have the HANDLER protocol, but i have some apps with memcache interface, could be nice to implement it direct on mariadb...
thanks guys!