[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