Complicated article system for multiple sites

[hdpt00]

Alright, I have a dedicated server for this running CPanel and want some opinions on the best way of handling this:

I want my employees (writers) to be able to upload their pieces on one central site where they can track their pay (per article), article status (accepted or rejected), etc. Now the thing is for SEO purposes I want to use multiple IPs for the many sites, mixing it up as much as I can, yet for the above reasons probably need all the info in one database. Here is what I could do:

1) Use the same IP
2) Run a CRON job and make a text file for each article or something and do a readfile() or something.
3) Have the data sent out to other databases on each account (may get more a lot more complicated).
4) Connect remotely to the database (may effect speed?)

Any other suggestions or how I may go about this?

Thanks!

[jatar_k]

you can use a central db and then 'publish' each site from there on a regular basis. The time increment may need to be increased as sites got larger and the cron/script for publishing the sites gets slower.

remote connect to db would also work but you are right, I would worry about slow downs.

I don't quite get th actual scenario so it is hard to say what the best way would be. You could break the sites up and instead of pushing to each of them you could pull to the central db as well.

[hundredly]

You might have your CMS setup a full text RSS/Atom feed for each topic that your authors are running. Then, for each site where the article would be published, setup a server site feed reader tool to read in the latest content, and record it into your database.

That would be a very simple way of doing it, since there are already plenty of tools available for creating feeds and capturing feeds.

If all the sites are on the same server (where your cpanel account is), you might just use a master database account from each of your sub-site accounts, to access the newest article content.

As a 3rd option, you might setup a web service type of system for distributing articles to your satellite sites. This option takes the most forthought, but would prbbly be the cleanest technique overall.