FUDforum: FUDforum Suggestions » Storing Forum Messages....

Home » FUDforum » FUDforum Suggestions » Storing Forum Messages....

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

Re: Storing Forum Messages.... [message #9342 is a reply to message #9335]

Mon, 24 March 2003 17:25

Ilia

Messages: 13241
Registered: January 2002

Karma:

Senior Member
Administrator
Core Developer

Disaster recovery is best accomplished via frequent (daily) backups using the forum datadump tool, which can be used via a crontab.
As far as data retrieval, I doubt replication would make it any faster since, network IO + MySQL overhead will exceed any benefits gained by you from replication in this case since data is fetched RAW and immidiately used as is. Replication will mostly help you when queries are CPU intensive and you can multiply performance by using multiple servers. Keep in mind that replication process also makes data insertion slow, since it needs to be duplicated across multiple servers.
For performance reasons the data is stored as is and internal offsets in MySQL are used to retrieve it, going via some manual mechanism would be infinately slower.

FUDforum Core Developer

Report message to a moderator

[Message index]

		Storing Forum Messages.... By: forrie on Wed, 19 March 2003 20:01
		Re: Storing Forum Messages.... By: Ilia on Mon, 24 March 2003 15:42
		Re: Storing Forum Messages.... By: Anonymous on Mon, 24 March 2003 16:14
		Re: Storing Forum Messages.... By: forrie on Mon, 24 March 2003 16:14
		Re: Storing Forum Messages.... By: Ilia on Mon, 24 March 2003 17:25

Previous Topic:	New statistic request
Next Topic:	Mailing List

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 10:49:05 GMT 2024

Total time taken to generate the page: 0.04387 seconds