<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;">Hi,</div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;"> </div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;">I would like to store all the persistentID stuff in a database, but using one with an easy clustering structure (active/passive nodes) and light footprint.</div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;"> </div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;">RQLite looks interresting (used for totally different projects), but it doesn't offer any JDBC driver. Fortunately,  a REST API is available and according to my quick and dirty tests (retrieving/inserting datas with cURL in a three nodes cluster, containing a dump of our production MySQL database) it does the job.</div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;"> </div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;">According to what I have read here <a href="https://shibboleth.atlassian.net/wiki/spaces/KB/pages/3032940563/Moving+away+from+StoredID">https://shibboleth.atlassian.net/wiki/spaces/KB/pages/3032940563/Moving+away+from+StoredID</a> , I could use an HTTP <span class="prismjs css-1g7m763" data-code-lang="xml" data-ds--code--code-block=""><code class="language-xml" style="white-space: pre;"><span class="token tag">DataConnector</span></code></span> instead of a <span class="prismjs css-1g7m763" data-code-lang="xml" data-ds--code--code-block=""><code class="language-xml" style="white-space: pre;"><span class="token tag attr-value">RelationalDatabase</span></code></span>.</div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;"> </div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;">It seems doable, but I was still not able to figure out where and how the write operations are defined/configured at the DataConnector level. Maybe there are limitations ?</div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;"> </div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;">Thanks for any help or suggestions.</div>
<div style="font-family: arial, helvetica,sans-serif; font-size: 10pt; color: #000000;"> </div>
                    <br/><hr>FreeMail powered by <a href="https://mail.fr" target="_blank">mail.fr</a>