From: Martijn Tonies
Date: August 31 2004 10:45am
Subject: Re: db design for hosting site
List-Archive: http://lists.mysql.com/mysql/171818
Message-Id: <022101c48f47$aa665660$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> Since I want the ability to mirror, it seems that I'll probably want one
> single DB replicated across my hosts so that comments and so on stay up
> to date (I still haven't crossed the bridge of how to keep the library
> itself in sync thru something like unison or rsync, but I do know that I
> really don't want to keep the files in the DB itself).  I'm open to ideas
> of why I wouldn't, though.

Well, putting the files themselves in the database would solve
your replication problem :-)

All in one, one in all...

> My real question comes down to table layout.  Given the customer data as
> above (in much more detail, of course), I'm not sure whether I want a
> table structure for each customer (presumably instantiated as part of the
> site setup, but perhaps created by the code in a "check this first before
> you do anything" section) or a single large table structure.

IMO, a single table structure. Unless you want to give each customers
its own _database_ (not just tables in the same database).

>  The latter
> seems more straightforward to me, and since it's a DB it shouldn't matter
> if the 'pictures' table (or the like) gets to be a million rows, but what
> I don't know about DB design would fill a book :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com