Davor Ocelic wrote: > Yes, but our databases, installed on Deleuze, will be the only > clients accessing the database files, and will not lose connection > as they are on the same machine as the AFS server. > >
The problem that I foresee is that Apache (I believe) will act not as a single, but as multiple clients, depending on the number of database connections that each web application leaves open. With our multi-threaded Apache (or even using the prefork model), most applications that remain in memory will have multiple threads open to the database, therefore running into the problem mentioned on the listserv. On the other hand, if the applications are really opening up and closing a connection each time they are accessed, we are doing things in an incredibly inefficient manner and our architecture likely won't scale the way we want it to. It sounds like the only way to do things "safely" with a DB on an AFS filesystem is to throttle the number of database threads to one for each database server, which will almost surely cause bottlenecks with even a moderately loaded site. Unfortunately, I still think that we should cut down the size of the data partition and leave an ext3 partition for the databases to start out, or figure out somewhere else to put the database files before migration. Justin _______________________________________________ HCoop-SysAdmin mailing list [email protected] http://hcoop.net/cgi-bin/mailman/listinfo/hcoop-sysadmin
