Page 1 of 1

Possible to migrate to RDBMS during...

PostPosted:Wed Jun 09, 2010 7:08 pm
by 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

Re: Possible to migrate to RDBMS during...

PostPosted:Thu Jun 10, 2010 8:59 am
by jllort
1 - Not possible. We'll must doing some special migration process in that case.

Re: Possible to migrate to RDBMS during...

PostPosted:Thu Jun 10, 2010 3:38 pm
by baiki
jllort wrote: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

Re: Possible to migrate to RDBMS during...

PostPosted:Thu Jun 10, 2010 9:31 pm
by jllort
Which repository size do you have in mind ?

Re: Possible to migrate to RDBMS during...

PostPosted:Fri Jun 11, 2010 9:19 am
by baiki
jllort wrote: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.

Re: Possible to migrate to RDBMS during...

PostPosted:Fri Jun 11, 2010 4:20 pm
by 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.