Sorry but you could have limited access to the slave to prevent writes... there ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		taf2 on May 31, 2017 \| parent \| context \| favorite \| on: MySQL 8.0: Retiring Support for the Query Cache Sorry but you could have limited access to the slave to prevent writes... there are legit replication strategies that allow you to write to multiple nodes, master-master, etc...

morgo on May 31, 2017 | [–]

There is an option called [super_]read_only designed for this use-case:

https://dev.mysql.com/doc/refman/5.7/en/server-system-variab...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact