Backing up Docs in OpenKM to a Harddisk other than MySQL

[rmm]

Can I ask whether it is possible to back up or save the documents in a separate computer's harddisk other than the MySQL database?
What is the best implementation of OpenKM? Save the documents in db or harddisk? Thank you for your help!

[jllort]

OpenKM has tree polls.
1- One for repository structure -> that's good idea storing on dbms ( mysql is good option, until 100.000 docs could use hypersonic, default dbms that comes with openkm ).
2- One for binary files -> that's good idea storing on hard disk ( don't lose time getting from dbms, then store in temporary disk folder to expulse them from server if file is directly stored on dbms is expulsed directly), other advantage is doing incremental backups, if all is stored on dbms is not easy.
3- finally the lucene index, that might be stored on disk too.

[rmm]

Hello sir, thank you for your reply.
Basically, i have used OpenKM to work with MySQL and it is running smoothly.
What if I also want to store the documents uploaded in OpenKM in another computer? Is that possible?
Do i need to create another Datastore in repository.xml?

please guide me.. thank you.
RMM

[jllort]

Are several options, but I would like understanding what do you want to solve duplicating data ... after it I could suggest some solution. The way is not modifying repository.xml etc... that's not the solution.

[rmm]

Hello sir, I was thinking (sorry for this ignorant question--topic):
if the users of OpenKM would upload a document....it will be stored in MySQL.
now I also want to have a simultaneous way of storing the uploaded docs/files in the hard disk other than storing it in MySQL..

Is it possible to store the doc/files simultaneously in MySQL and in the hard disk?

[jllort]

you want a mirror of the repository than have on hard disk.

It's possible and are several ways for doing it:
1- real time -> then might be implemented as extension event ( minimal extension procedure must be implemented ) take a look here http://wiki.openkm.com/index.php/Extension_Guide and here http://wiki.openkm.com/index.php/Developer_Guide
2- crontab - > create some application on cron and regreshing new files ( simple query searching new files, and then reply on some server folder )

It can be done by you or if you want we can doing it, http://www.openkm.com/Contact ( refer to this post ).

[rmm]

Good day, thank you for your reply, I hope I can understand more the process on how to do it, please guide..

[jllort]

Simply read the developer guide and configure development environement, then make some example extension to understanding how running it, after it you only need handle create_document event and with it you will be able to starting save process locally. Must go step by step.

[rmm]

I am having a problem in checking out the source.. I have installed maven and eclipse as well as configured the plugins.. please guide. Thank you.

[pavila]

What problem do you have with the Developer Guide?

[rmm]

I was having a problem in running the configurations...http://wiki.openkm.com/index.php/Debugging_with_GWT
Eclipse was deploying this warning:

Code: Select all

java.lang.NoClassDefFoundError: com/google/gwt/dev/DevMode
Caused by: java.lang.ClassNotFoundException: com.google.gwt.dev.DevMode
	at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
Exception in thread "main" 

Thanks for the help.

[pavila]

Edit the pom.xml file and uncomment the gwt-dev dependency.

[rmm]

there's a change of story...

openkm resides in server1
The files will be coming from server2..
i will just link the files in server2 to openkm in server1.

is this possible? Thank you.

[jllort]

Change the story then add new post please.

[pavila]

if the users of OpenKM would upload a document....it will be stored in MySQL.
now I also want to have a simultaneous way of storing the uploaded docs/files in the hard disk other than storing it in MySQL.

Is it possible to store the doc/files simultaneously in MySQL and in the hard disk?

I always recommend the use of FileDataStore because offer the best performance and ease the incremental backup process. If you wan to store in both locations you have a couple of options:

1.- Implement a CustomDataStore which store every document in database and filesystem.

2.- Create a crontab (Administration > Crontab) script which call the RepositoryExporter.exportDocuments() method to export the actual document repository contents to the server filesystem.