Hi, On Fri, 2002-05-31 at 17:16, Henri Bergius wrote: > Which one of the methods of using a remote MySQL database > with Midgard is the preferable one at the moment: > > * Tweak midgard-lib/src/defaults.h to > #define MGD_MYSQL_HOST "my.database.host" > and recompile Midgard > > * Use the new MidgardDatabase directive: > MidgardDatabase my.database.host:database user password
I prefer the first method, because repligard picks this up easily. Using the latter method I had to install repligard on the database host as well. > BTW. Any usage experiences from using a remote DB? How does this > affect performance? Depends strongly on your machine's of course. But basically the performance-loss is what MySQL states in their manual for the difference between socket connects and tcp/ip connects. I have found this loss to be very acceptable if: 1) you make sure you have a good network connection (use a dedicated nic) 2) you make sure your db machine is up to the load you want to give it. 3) make sure you have compiled mysql for performance. I have found that the pointers mysql themselves give are very valuable in scaling a remote DB solution. wkr, -- Envida http://www.envida.net/ Armand A. Verstappen Graadt van Roggenweg 328 [EMAIL PROTECTED] 3531 AH Utrecht tel: +31 (0)30 298 2255 Postbus 19127 fax: +31 (0)30 298 2111 3501 DC Utrecht
signature.asc
Description: This is a digitally signed message part
