FUDforum: FUDforum Suggestions

Home » FUDforum » FUDforum Suggestions » disk files

Show: Today's Messages :: Polls :: Message Navigator

disk files [message #10940]

Fri, 13 June 2003 23:09

gbjbaanb

Messages: 41
Registered: February 2003
Location: UK

Karma: 0

Member

this may be a dim question, but I read the following forum topic and thought - why don't you store all the data currently stored in MySQL in disk files?

http://fud.prohost.org/forum/index.php?t=msg&th=120&start=0&rid =730

Reasons I think this might be a good thing:
it'd make the system more reliable - a backup is just a zip of the forum directories (and if you grab only changed files... much, much smaller backups).

it'd stop all the MySQL installation and permissions problems people have been having.

it'd be even faster?

anyway, just a thought - I wouldn't expect this to actually happen Smile

Report message to a moderator

Re: disk files [message #10941 is a reply to message #10940]

Fri, 13 June 2003 23:16

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I won't go into full details (you can find those if you search the forum archives). But storing the messages outside of the MySQL or PostgreSQL was a performance oriented solution.

FUDforum Core Developer

Report message to a moderator

Re: disk files [message #11093 is a reply to message #10941]

Tue, 17 June 2003 18:41

gbjbaanb

Messages: 41
Registered: February 2003
Location: UK

Karma: 0

Member

sorry, perhaps I should have made myself clearer..

I read all about the performance issues, and agree that placing all the files outside the DB is a good thing. However.. there are a few bits and pieces still left inside the DB. My query is: why not take those bits and put them in flat files as well.

EG. I see from a post today ( http://fud.prohost.org/forum/index.php?t=post&reply_to=11089&quote= true&rid=730) that the location of file attachments is stored inside the DB, which causes problems when moving the forum to a different server (or even simply reinstalling to a different location).

MySQL seems to be a source of a lot of problems that are reported, which is 1 reason I think removing it completely is worthwhile suggesting. (2nd reason is for backups).

cheers.

Report message to a moderator

Re: disk files [message #11096 is a reply to message #11093]

Tue, 17 June 2003 19:01

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Majority of the FUDforum's information is kept in the database, this includes a variety of caches such as the file location field etc...
The datadump script will do exactly what you ask and that is being take all of the forum's SQL data & all the static file data and generate a single (optionally compressed) archive that you can use as a means to backup the forum.
This dump utility even support http authentication to allow simple scripting for forum dumps via a cron or any other utility.

The file location problem is not a problem at all because it came up as a result of incomplete manual forum move.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Text Size Picker....
Next Topic:	SEARCH: suggestion to only show threads once in search results

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 01:46:59 GMT 2024

Total time taken to generate the page: 0.01886 seconds