4 or 5 tables is pretty small. We've got about 200 tables here, some containing over 100 million rows which still runs well on a simple PIII test server.
You are definitely better off having one database serve this data. If you want a backup, the MySQL replication stuff works very well. On Thu, 2004-06-17 at 14:55, David Blomstrom wrote: > I'm working on a rather large database - four or five > tables - that will power eight different websites. > There will also be a few additional supplemental > tables on various sites, but I'd speculate that 90% of > the data will be exactly the same on all eight sites. > > With that in mind, would you recommend creating and > publishing eight separate databases or just publishing > one database and linking all the websites to it? > Actually, I'd probably publish a minimum of two > databases, for security; if one goes down, I'll have a > back up. > > Thanks. > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail is new and improved - Check it out! > http://promotions.yahoo.com/new_mail -- . Garth Webb . [EMAIL PROTECTED] . . shoes * éå * schoenen * ëí * chaussures * zapatos . Schuhe * ÏÎÏÎÏÏÏÎÎ * pattini * é * sapatas * ÐÐÑÐÐÐÐ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]