[TYPO3-dev] Can some page ID point to another database?

[Martin Kutschker]

John Angel schrieb:
> Hi Masi,
> 
>> No. I was saying that I can understand why you want to distribute some
>> tables onto different servers, but I see no point in distributing ALL
>> tables.
> 
> I mentioned in some previous post what tables exactly I was thinking of
> distributing, not all of them: be_*, fe_*, static_*, tx_templavoila_*, 
> sys_* except sys_log and sys_stat.

I have to admit that I did not follow the whole thread.

  > Actually, we are talking about two approaches for huge traffic:
> 
> 1) Using single database and distributing large tables using DBAL to other
> servers. If that is not enough, can DBAL work with mysql cluster (e.g.
> clustered tt_content)?

A cluster is transparent so you shouldn't need DBAl for it. But is the 
disk based Mysql cluster ready for production? Earlier clusters are 
memory based and require the whole clustered db to fit into the RAM of 
the machines.

> 2) Using separate server (and different database) per sub-domain, fetching
> main tables (be_*, fe_*, static_*, tx_templavoila_*, sys_*) from main
> database server + synchronizing files from fileadmin directory (TV, CSS,
> images and general HTML templates).

Sounds reasonable and much easier to deploy.

> What is the best solution?

I'd try solution 2.

Masi