I tried to configure slave server to work as read only. But it seems ISPConfig cannot update settings when you make changes in ISPConfig interface. Under /etc/mysql/mariadb.conf.d/50-server.cnf I set it to: read-only = 1 Is there a way for ISPConfig to work with read-only?
No. It does not make much sense anyway, as the replication between nodes is done by ISPConfig and not MySQL, so a read-only node would be empty and stays empty.
I was able to make it by granting permission to ispconfig as super. This will still allow ISPConfig to do it's normal operation like adding of websites, email, shell users, etc.