[TYPO3-english] Read-only MySQL user?
yanagik317 at netscape.net
yanagik317 at netscape.net
Fri Jan 6 03:35:24 CET 2012
Dear Typo3sters,
Has anyone tried creating a MySQL user that can only select from tables
in an attempt for read-only Typo3 site? The question may sound a bit
whack, but my initial attempts are encouraging, meaning pages seem to
get served fine. You can't use BE, but that's fine by me. Pages that
use extensions that may insert stuff to tables (Powermail, maybe?) will
not function, but let's say I'm fine with that too. Maybe I haven't
hit pages that would invoke insert or whatever to cache_ tables, but if
anybody tried something like this, I'd like to hear from you.
This is because I'm trying to see what could be done to minimize
downtime while upgrading. We're planning on duplicating the production
database and then running upgrade on it, which will then be the new
production. While doing all this, it would be nice if the entire site
didn't have to go down entirely.
Thanks,
--Koji
More information about the TYPO3-english
mailing list