Database Limitation?

[wmcheung]

Hi,

FengOffice is a nice document management system, however, for long term use, I have concerned about the database storage limitation. Any existing users could give me a sample of figure how much FengOffice can support?

How FengOffice store the data? Will the data and documents save separated in two different servers?

For the database, except MySQL. Any other databases supported by FengOffice?
e.g. MSSQL Server, PostgreSQL

[wmcheung]

anyone has experience about this?

[franponce87]

So far we have had used hundred of thousands records in some tables without experiencing issues, but I cannot say for sure a specific number as a top.

Regarding the SQL engine, right now Feng Office can only be used along MySQL.. If you happen to develop a compatibility with a new one, many people would appreciate a lot if you could share such contribution.

Best regards,
Francisco

[wmcheung]

thx for your reply, Francisco

By default, FengOffice stores the documents in database or saved in a specified folder?

[franponce87]

By default in folders, but you may change this setting in the Administration panel > Configuration > General

Best regards,
Francisco

[wmcheung]

thx, Francisco

If i choose "File System" as the file storage, can I change the location where the file to save at?

for example, install FengOffice in Machine A and set the file to save in Machine B
Can I do that?

[nicname]

not within FO
You could store the files on another machine by mounting the other machine into the FO Dir structure, but then the files would still be delivered by the machine hosting FO so this wouldn't make much sense.

[wmcheung]

I am designing a fail-over plan.

My plan is installing FengOffice in Machine A and Machine B and setup MySQL Cluster in both machines. Machine A is the master and Machine B is the backup in case of Machine A failure.

If the documents can store separately, I would like to store the documents in Machine C. Then, I can setup RAID 5 or sth. like that to backup those documents. No matter Machine A or Machine C also can retrieve the documents in Machine C.

As using MySQL Cluster can only protect the data stored in database, thus, I hope the documents can save in another location.

Is it possible?

[wmcheung]

Anyone can give me some hints, whether this approach would work or not?

[mmccarn]

As using MySQL Cluster can only protect the data stored in database, thus, I hope the documents can save in another location.

Why not set 'File Storage' to 'Database (MySQL)' (instead of 'File system') in Administration / Configuration / General?

As for moving file storage to serverC - simply mount <FENG>/upload to a share on serverC from both serverA and serverB.

[nicname]

Storing BLOBs in a Database is allways a bad idea, also, if he is mounting the directory from one server  on the other server its not failover anymore because if the first server is gone, the data is also gone,

i would reccomend a solution like unison to sync the directorys

[notifiedme]

I do agree. That would be a terrible if we put the storage on MySQL (db). the impact will go to performances.
In term of backing up system or data (failover/HA), it is recommend if it is can specify to specific folder as a file storage.

[RandySmich]

 
You said it perfectly..
<a href="https://englishessayhelp.com/">best essay writing service</a> writing help <a href="https://essaywritinghelperonline.com/">help me write my essay</a> essay helper online
buy a research paper online proposal custom research paper writing services buy term papers online
essay competitions for college students https://essaywritingservicelinked.com