Read-only access to the database

omeganet

Vote:

For a project we plan to do the following set-up in production:

2 front servers that can be accessed from the Internet. /episerver/ is forbidden.
1 cms server that is only acessible internally and used by editors to update the content.

As all the 3 servers share the same database, I want to do some restrictions, so that the front servers are accessing it i na read-only mode, i.e. the user is not db_owner. I plan to set enableModelSyncCommit to false for the front servers in order to disable the model sync - it should happen only from the cms server. My question is, is it possible to give read-only permissions to the frotn servers? Is EPiServer doing some write operations that cannot be disabled? :-)

#143227

Jan 16, 2016 14:04

Steve Celius

Vote:

Unfortunately, no.

The front-end servers are also writing to the database, and even though there isn't a lot of writing happening, it is not a supported option to run them in read-only mode.

/Steve

#143232

Jan 17, 2016 21:46