Thousands of sites on one database

Question

Database

There is a main site, and there are partner sites. Partner sites use data from the main site as part of the information published on them. You need to be able to create sites on pre-prepared templates and according to a predetermined site structure, which is called "by click". It is desirable that the empty sections of partner sites are filled with the help of some CMS and there is an opportunity to create new sections.

So, you need:

- The speed of the sites (we are talking about thousands of sites)
- Ease of adding new templates
- Ease of creating a new partner site without additional. financial costs (the data and the template are already there, see above)
- Ease of editing empty sections on sites and the ability to add new sections

1. What is the best way to organize this bouquet - write from scratch or based on CMS? What should be taken into account?
2. Who would be interested in developing such a solution? In the sense that it must be a programmer who is very good. well cuts in the database or the web (or other)? Well, I will not refuse contacts, if any.

Answer 1

It is not necessary on the same base, make packages of a customized CMS for a partner in advance and when creating a site, write bash (gem, perl, python, ruby, awk script whatever you like), which will create:
1. your base, fill in the default dump
2. virtual host
3. folder and unpack the prepared system package and save the settings

Answer 2

As one of the CMS drupal options, there are already almost ready-made solutions for it. As an example , an OpenScholar build with similar functionality to the required one. This assembly is in scholar.harvard.edu/
as an alternative, the following modules should be suitable:
drupal.org/project/sites
drupal.org/project/virtual_site

Answer 3

Well, without a thorough study of any CMS, I won’t say which is better (from scratch or not), but if from scratch, then everything is simple. For example, there are posts. They are all on the main site. Some of them should be on some partner sites. Total:
posts(id, content)
partners(id, url)
partners_posts(partner_id, post_id)
all. Filling for a new partner - just check the boxes.

Answer 4

We do it easier: We
allow users to choose their own hosting/cms for their projects.
For example, some of our clients use their CMS, but many still "sit" on the free "people.ru", someone on the "google site", someone on "ho-ua", someone then on "far-ru", and, one even on yukoz. What they want is what they publish on their resources (it doesn’t matter how they do it, via CMS or FTP).
The robot of our service periodically bypasses and collects the “harvest”, compares what was and what has become, generates diffs, and sends it for express moderation.
If the content on their site has changed a lot (including the design), then for such exceptional cases (rarely, but still happens), a new processing template is created.
Well, then - to the base ...
Even schoolchildren make websites on peoples and yukozes, so special training is not required.
Although for us, of course, it would be preferable to fill everything in the form of xml.

Answer 5

The easiest way to do this is on Modx Revo cms (modx). Modix has a system of contexts, and each context can be assigned to a separate domain. contexts unlimited number. Templates are pretty easy to add. Sections can be copied and linked (when information changes in the source, it will change everywhere). We can take on development

Answer 6

I offer a custom solution, write in a personal, we will develop it)