dsp-api icon indicating copy to clipboard operation
dsp-api copied to clipboard

Online-upgrade of GraphDB (or whatever we use in the future)

Open subotic opened this issue 4 years ago • 1 comments

There is a strong possibility that we will need to host around 150 new projects each year, so our current strategy of shutting down knora-api (or the planned one with read-only mode) will not work. With these project numbers and the accompanied triplestore size, this strategy would probably shut us down for a few days.

So, either triplestore upgrades are an exceptional occurrence ( e.g., once a year), or we need to find a way to accomplish them while upholding normal operation.

Any suggestions are welcome.

subotic avatar Dec 10 '19 10:12 subotic

An online upgrade would have to be done in a transaction. But GraphDB only allows one update transaction at a time. So, while an update is occurring, you are effectively in read-only mode in any case, because all other updates have to wait.

benjamingeer avatar Dec 10 '19 11:12 benjamingeer