Author Topic: Database Limitation?  (Read 11284 times)

wmcheung

  • Newbie
  • *
  • Posts: 28
    • View Profile
    • Email
Database Limitation?
« on: January 24, 2011, 01:13:42 AM »
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
« Last Edit: January 24, 2011, 01:15:23 AM by wmcheung »

wmcheung

  • Newbie
  • *
  • Posts: 28
    • View Profile
    • Email
Re: Database Limitation?
« Reply #1 on: January 24, 2011, 10:43:36 PM »
anyone has experience about this?

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Database Limitation?
« Reply #2 on: February 07, 2011, 10:33:31 AM »
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
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!

wmcheung

  • Newbie
  • *
  • Posts: 28
    • View Profile
    • Email
Re: Database Limitation?
« Reply #3 on: February 10, 2011, 10:21:20 PM »
thx for your reply, Francisco

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

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Database Limitation?
« Reply #4 on: February 11, 2011, 01:10:09 PM »
By default in folders, but you may change this setting in the Administration panel > Configuration > General

Best regards,
Francisco
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!

wmcheung

  • Newbie
  • *
  • Posts: 28
    • View Profile
    • Email
Re: Database Limitation?
« Reply #5 on: February 13, 2011, 10:10:31 PM »
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

  • Freshman
  • *
  • Posts: 35
    • View Profile
Re: Database Limitation?
« Reply #6 on: February 14, 2011, 10:44:31 AM »
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

  • Newbie
  • *
  • Posts: 28
    • View Profile
    • Email
Re: Database Limitation?
« Reply #7 on: February 14, 2011, 10:24:49 PM »
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

  • Newbie
  • *
  • Posts: 28
    • View Profile
    • Email
Re: Database Limitation?
« Reply #8 on: March 01, 2011, 01:21:09 AM »
Anyone can give me some hints, whether this approach would work or not?

mmccarn

  • Freshman
  • *
  • Posts: 33
    • View Profile
Re: Database Limitation?
« Reply #9 on: May 27, 2011, 07:54:28 AM »
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

  • Freshman
  • *
  • Posts: 35
    • View Profile
Re: Database Limitation?
« Reply #10 on: July 01, 2011, 05:43:39 AM »
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

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Database Limitation?
« Reply #11 on: February 04, 2012, 01:44:34 PM »
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.

 

anything