I want to make my MySql slave read only, i've been looking and found the read_only option, but its says that users with super privalges can still write (if i understand the text correctly), here is the grants for my app:
GRANT RELOAD, PROCESS ON *.* TO 'my_app'@'%' IDENTIFIED BY PASSWORD '*' GRANT ALL PRIVILEGES ON `my_app`.* TO 'my_app'@'%'
will the app be able to write to the slave?