[geeklog-devel] Re: Input From PJ of Groklaw

Tony Bibbs tony at tonybibbs.com
Fri Aug 20 13:50:44 EDT 2004


Peter Roozemaal wrote:

> PHP session variables create a load on the central file server. We can
> not store them locally on the webserver as the loadbalancer will move
> sessions from machine to machine. (rethinks) It might be possible if the
> session variable only serves as cache for database data.

Using files versus a DB is the admin's decision.  In your case you'd 
clearly need the DB.

> We need a bit of help from your side in separating read-only database
> operations from operations that modify the database. The config files
> would need two database names, etc.

Hrm, haven't thought about this much.  Deserves some more thought from 
all of us.  Also, have you turned on query caching in MySQL.  I'm 
guessing you have but that would help a lot.

> I can give you a sanitized version of the database if there is a place
> where I can upload a 45 Mbyte of compressed data. I need a few hours to
> clean it from personal data.

k, Let me know when you get it ready and I'll let you SCP it to one of 
our servers.

--Tony



More information about the geeklog-devel mailing list