I have a database that is running on AWS RDS (MySQl 5.7.22).
Currently, I have one master and 2 replicas running. My binlog format is MIXED. I have plans to change it to ROW based.
I want to change it during runtime (live environment) since it's our main database.
Questions
- What things do I have to consider before I change it?
- What is the safest way to do it?
- I am just wondering if there will be growth of the binlog size when I change it?
Best Answer
you can use at the runtime.
or for the session
see the manual for more information.