Possible to migrate to RDBMS during...

[baiki]

Hello community,

1. Is it possible to change from the default OKM installations database (BTW: Which one is it?) to MySQL or Postgres? Even though the server is already "productive"?
1.1 If a change is possible, which RDBMS does OpenKM team recommend?
1.2 If the standard DB will be used in the future, which drawbacks to I have to expect? Where is a magical threshold of documents with the built-in DB?
3. Since the documentation/manuals/howto's about all the possibilities of OKM aren't free, did anyone try this already? Any experiences to share?

Thanks a lot.

Regards,
Baiki

[jllort]

1 - Not possible. We'll must doing some special migration process in that case.

[baiki]

1 - Not possible. We'll must doing some special migration process in that case.

Thank you. For how many documents would the built-in DB be reasonable? Anyone with some figures about how much are in use and whether there is a remarkable performance issue once you reached a critical amount of documents?

Regards,
Baiki

[jllort]

Which repository size do you have in mind ?

[baiki]

Which repository size do you have in mind ?

Kind a hard to predict, but I guess 100-200k (300-400 TB) within 3 years. As I said, just a prediction.

[jllort]

ufff, 300 Tera is a high repository.

You can not mount with version 4.x you need version 5.0 where are solved the some clustering problems. You can not mount in a single server ... it must be a distributed configuration, in that scenario mysql, postgresql or other database could be good options.