[NXP-25604] Provide a KeyValueStore implementation in SQL - Nuxeo Issue Tracker

XML

Word

Printable

Epic Link:
No Redis deployment
Tags:
Impact type:

API change
Upgrade notes:
Hide

A new Key/Value Store based on SQL is available. To configure a server to use it, use:

<extension target="org.nuxeo.runtime.kv.KeyValueService" point="configuration"> <store name="default" class="org.nuxeo.ecm.core.storage.sql.kv.SQLKeyValueStore"> <property name="datasource">jdbc/nuxeo</property> <property name="table">kv</property> </store> </extension>

Note that the PostgreSQL implementation requires the use of a version of PostgreSQL >= 9.5 to implement the put operation (PostgreSQL 11.x is the supported version with Nuxeo 10.10 anyway).
Show
A new Key/Value Store based on SQL is available. To configure a server to use it, use: <extension target= "org.nuxeo.runtime.kv.KeyValueService" point= "configuration" > <store name= "default" class= "org.nuxeo.ecm.core.storage.sql.kv.SQLKeyValueStore" > <property name= "datasource" > jdbc/nuxeo </property> <property name= "table" > kv </property> </store> </extension> Note that the PostgreSQL implementation requires the use of a version of PostgreSQL >= 9.5 to implement the put operation (PostgreSQL 11.x is the supported version with Nuxeo 10.10 anyway).
Sprint:
nxFG 10.10.1
Story Points:
5

The default implementation of the KVStore is Redis, only MongoDB comes with alternative implementation.

It makes sense to have a KVStore in SQL as well so we don't need to deploy a Redis especially.

is related to

NXDOC-1629 Write a how-to to configure a Cluster without Redis

is required by

NXP-26596 Fix uploading files to webui

NXP-27023 JSF Bulk Import hangs on File Drop when SQLKeyValueStore enabled

NXP-26515 Use SQLKeyValueStore instead of MemKeyValueStore by default

NXP-26812 Backport SQLKeyValueStore from 10.10 to 9.10

Estimated:

Not Specified

Remaining:

Logged: