Move "set read-only" operation from pre-demote to demote
Pacemaker will call "pre-demote" when its transition start.
At this time, some MySQL clients don't stop nomary.
They might try to update their status during stop operation, but MySQL is already "read-only" mode.
It's better to do "set read-only" at, not "pre-demote" but "demote".