Below parameters need to change in the MySQL slave or read-only replica.
SET GLOBAL read_only = ON;
SET GLOBAL super_read_only = ON;
SHOW VARIABLES WHERE Variable_Name LIKE "%read_only";
To make it persistent, Add below variables in my.cnf/my.ini
read_only = 1
super_read_only = 1
