GoFuckYourself.com - Adult Webmaster Forum - View Single Post - [BIZ] Database designers.. what's the best way to.....

Tempest · 10-21-2007, 06:09 PM

Set up multiple databases and scripts to use some common data. For example, let's say I have a bunch of different scripts (that should/could be standalone), but they all need some of the same data.. plus they can all add to that data... eg: let's say I'm storing a bunch of domains.. Multiple scripts (Traffic trading, TGP, Thumb etc.) on multiple sites need to read and write to "a" list of domains. Ideally I want it to be the same list so I have one central comprehensive listing.

Should that data be in it's own DB and all the scripts take the extra connection hit to access it and write to it and also lose the ability to perform queries by joining that data with other data in the script specific DB?

Should each script have it's own copy of the data and when a particular script adds a new piece of data it does it to all of the other DBs at the same time?

Is there a better option? Any ways to make these options more efficient?

I'm using MySQL.

10-21-2007, 06:09 PM
Tempest Too lazy to set a custom title Industry Role: Join Date: May 2004 Location: West Coast, Canada. Posts: 10,217	[BIZ] Database designers.. what's the best way to..... Set up multiple databases and scripts to use some common data. For example, let's say I have a bunch of different scripts (that should/could be standalone), but they all need some of the same data.. plus they can all add to that data... eg: let's say I'm storing a bunch of domains.. Multiple scripts (Traffic trading, TGP, Thumb etc.) on multiple sites need to read and write to "a" list of domains. Ideally I want it to be the same list so I have one central comprehensive listing. Should that data be in it's own DB and all the scripts take the extra connection hit to access it and write to it and also lose the ability to perform queries by joining that data with other data in the script specific DB? Should each script have it's own copy of the data and when a particular script adds a new piece of data it does it to all of the other DBs at the same time? Is there a better option? Any ways to make these options more efficient? I'm using MySQL.