That depends on how remote it is and how much traffic you expect. You might want to look into MySQL replication at a certain point. That way for most of your queries you can do them locally (on the box), and only upatable queries will make their way to the main server. That's what I do.. MySQL replication is quite simple to setup. And if you notice there are two entires in the mysql.h file, one for the read server and one for the update server.
-Clayton -----Original Message----- From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 1:49 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] switching database servers Ok, this raises for me an interesting questions....should vpopmail only ever use a local db? Or is it reasonable to try using a remote (obviously not too terribly remote) db? > -----Original Message----- > From: Clayton Weise [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 2:47 PM > To: 'Benjamin Tomhave'; [EMAIL PROTECTED] > Subject: RE: [vchkpw] switching database servers > > > That might be feasable.. if vpopmail ran as a daemon. But vpopmail > gets called on by qmail. So if vpopmail had a config file it could > damper it's performance (on slower systems, quite heavily) because > every single time vpopmail was run it would have to read that config > file. Remember that vpopmail is called on upon every message > delivery, password check, etc etc. > > -Clayton > > -----Original Message----- > From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 1:40 PM > To: [EMAIL PROTECTED] > Subject: RE: [vchkpw] switching database servers > > > What would it take for this to be a configurable parameter instead of > a compiled-in parameter? In other words, would it be possible to add > a config file, read at startup, from, say vpopmail/etc or > qmail/control or similar? It seems to me that this would make a lot > more sense than requiring the server, user and password to be compiled > into the program itself. > > > -----Original Message----- > > From: Clayton Weise [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 14, 2003 1:47 PM > > To: 'Benjamin Tomhave'; [EMAIL PROTECTED] > > Subject: RE: [vchkpw] switching database servers > > > > > > Recompile. And do it from fresh source, don't just do a make clean > > and reconfigure it. > > > > -Clayton > > > > -----Original Message----- > > From: Benjamin Tomhave [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 14, 2003 10:41 AM > > To: [EMAIL PROTECTED] > > Subject: [vchkpw] switching database servers > > > > > > Hello, > > > > If I want to switch from using localhost to another remote host for > > my vpopmail, does that require a rebuild/recompile, or is there a > > configurable parameter somewhere that can be modified to make that > > adjustment? My notes seem to imply that the only way to change this > > is by editting the proper values in the vmysql.h file. > > > > Thank you, > > > > -ben > > > > -------------------------------------------- > > Benjamin Tomhave, Senior Systems Engineer [EMAIL PROTECTED] > > Sofast Communications www.sofast.net > > > > > > > > > > > > > > > > > >
