[TYPO3-dev] Fail-safe mechanism for database connectivityproblem

[Michael Stucki]

Hi John,

>> In what way do you need advice?
> 
> Masi, don't you think that it's not professional that user who visits
> Typo3 powered website gets 'Database problem'? We are all using free
> tools, so this things happen, believe it or not.
> 
> I thought we are here to make Typo3 the best CMS available. That is all I
> 'need'.

I wrote that in the bugtracker already, but I'm trying to explain again:

When you get such a database error, there must be a reason for it. Such a
reason could be:
- Database server is overloaded
- Database server is down (?!)
- Database server does not allow more connections

Since you explained that the problem is gone for a while after restarting
the mysql server, I strongly believe that your system does not close
connections correctly(!) In this case this problem should be investigated
first as there is nothing TYPO3 can do about that.

> There are several extensions for exporting to static HTML pages. Obviously
> I am not the only one who needs fail-safe mechanism. See for yourself:
> http://typo3.org/fileadmin/t3n/articles/t3n_static_publish_english.pdf
> http://typo3.org/extensions/repository/view/dr_publisher/0.0.1/
> http://typo3.org/extensions/repository/view/real_publish/0.0.1/
> http://typo3.org/extensions/repository/view/itxg_staticexport/0.0.1/

I'd say these are all not needed if the [FE][pageCacheToExternalFiles]
feature is used correctly.

However, there are many sites which still embed uncached parts which require
database connections. Make a test. If you want the full power of your file
system based cache, there should be no more queries performed. Of course
this will require some tuning, and of course this is not possible as soon
as you are doing fe_user authentication (but that is also not possible with
any other static publishing system).

The good thing about pageCacheToExternalFiles is that it automatically
accesses the database as soon as it is needed (e.g. when calling the search
engine). But as long as the content is static, TYPO3 will send the webpage
from the filesystem cache directly.

- michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/