dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Published 20 hours ago • verified publisher icon dolthub

Cluster replication allows a standby server to run `CREATE DATABASE ...` successfully.

Open reltuk opened this issue 1 year ago • 0 comments

The expected behavior of a server in standby role within cluster replication is that it is read-only. However, currently the standby role server allows:

  • CREATE DATABASE ...
  • DROP DATABASE ...
  • CREATE|ALTER|DROP USER|GRANT ...

The later two are necessary for user functionality until we fix #4566 and #4567, but allowing CREATE DATABASE ... is not necessary because we do correctly replicate CREATE DATABASE ... run on a primary.

Eventually we should forbid all three of these interactions, but to start with we should at least forbid CREATE DATABASE ....

reltuk avatar Oct 17 '22 21:10 reltuk