[Typo3-dev] Is anybody working on a project to store files inside the typo3 database?
Kevin Fredrick
fredrikr at ipfw.edu
Thu Oct 9 21:41:57 CEST 2003
Is anybody working on a project to store files inside the typo3
database? We are in real need of this feature.
Yes, I know about the problems of storing files inside a database. But
we already have an electronic document management system (PHP, MySQL)
with 15,000+ users and 4,000+ TXT, HTML, XML, PDF, Word, Sound, and
Video files.
The problem with the current file problem is replication. We have a
database cluster and a Web server farm. When a user needs to access a
file (delete, upload, edit, …) they need to do that work from a master
server in the Web server farm. Then the server farm replicates the files
to its servers. Yes you can us NFS (…ok…), rsync/ssh (…better…), or
scp/ssh (…ok…) with some type of cron/batch system.
We tend to add Word, PDF, or media files to a Web site on a daily basis
and the bottleneck is that master server. Our database cluster handles
replication and load balancing very well. Moving files or changing
content into the database would allow for more timely updates. Caching
could help with the need to retrieve the files from a database and
server them up to the user (similar to the way typo3 pages/content is
cached).
More information about the TYPO3-dev
mailing list