Cluster replication allows a standby server to run `CREATE DATABASE ...` successfully.
Open
enhancement
replication
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 108
Description
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 ...`.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.