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

[John Angel]

Hi Elmar,

> Why not using
> established methods of load balancing first? Caching headers, squid, table
> indices, proper caching plugins, ...

1) Typo3 cache is enabled,
2) pageCacheToExternalFiles is enabled,
3) Mysql has its own cache.

Everything is working properly.

What else did you have in mind? I don't see much options, it has something
to do with Typo3 structure I suppose. E.g.
1) HMENU is doing dozens of SQL queries,
2) All pages are in 1 table (pages),
3) All content is in 1 table (tt_content).

> As a workaround for your model you could think of unidirectional mirroring
> of a central DB.

I think it is pretty fragile doing that with mysql on production servers all
the time. What if something fails, or is done partially?

I was thinkg about exporting all TypoScript to external files and
synchronizing that files, but what about other database stuff  (BE/FE users,
TV DS/TO, etc).

I've been checking around existing installation of Typo3 and it seems to me
that Typo3<->mysql single database solution cannot handle large traffic?

Regards,
John