Current Proxies clones Server behaviour:

• get value in buffer
• store value in database
• read value
• sync value
• delete value

The problem:

• DELETE .. IN () .. - happens with a housekeeper - making proxy stuck on receiving new values;

Feature request:

• get value in cache;
• sync value;
• drop value from cache if sync is successful;
• store value if sync failed up to offline buffer max;
• store value if online buffer is activated;
• backlog sync on network recovery with further drop of the database partitions used to store backlog;

Or even simplier - dump json files which can be uploaded back and removed as needed for offline buffer.