Multiple sites using same data

Hello,

Would be grateful for some guidance of how to best implement the following:

I have several sites NOT all on the same server, the sites are on dedicated servers under my control

I want to display the same data on all sites (or at least parts of it by using different detail pages)
the pages include thumbnail images for the area pages and 6+ plus pics on an individual record page

Only the master site would have admin to create, amend, delete records etc

I already run a third party CMS on one of the sites which I will move over to PowerCMS

Any suggestions as to how you would run lets say 6 sites all using the same data

My other thought is not to use CMS at all and to stick to databases

My one thought is to use Navicat to keep all databases up to date but that does not solve keeping the picture upload file
updated and have powerCMS on all sites to ensure uniformity of file and query structure but still would have to overcome
updating problems

Any thoughts on a manageable solution as to how you guys would implement this would be much appreciated

Thank you - Mel

  My other thought is not to use CMS at all and to stick to databases  

A CMS System uses a database.

The whole idea of a CMS system is to store the content in a database.

Set each of you sites up to connect to the same Database, for the pictures use a full URL in the image source so that each site is looking for the images at the same place.

only put the CMS admin on the one main site.

Hello Jason,

What I meant about not using CMS was if I have a site already designed perhaps I would be better off just using DataAssist to build Insert, Update, Delete records rather than using CMS

Your suggestion about using the full url for the images, is something I wanted to avoid from a Google/SEO perspective, which is why I was looking for a way to replicate the master database (which can be done without problem using navicat) and updating the slave databases but my problem is how to get the images over to each of the sites automatically?

I am assuming if all the databases are set with the same table names and the image upload file is called the same then all sites should function independently or is my thinking of course a bit here

you could use either CMS or Use Data bridge to create the admin files manually, either way will work


as for the images, there is not an automated way to upload images from the admin to multiples sites, that was why I suggested using full urls.

If the images wont be changing, then just make sure they are all uploaded to each site and it should work.