Switch MySQL slave to master - BINLOG_FORMAT

Question

800 views Asked by Milos Cuculovic At 28 June 2015 at 14:24

I had a mySQL slave db that turned into master once some server migration done. Now, when I do a mySQL restart, the db turnos on with the

BINLOG_FORMAT = STATEMENT

So I am not able to write in the DB.

How can I move my mySQL db to be a full master db?

Thank you.

There are 1 answers

**Aman Aggarwal** · Accepted Answer · 2015-07-03 16:41:38

Aman Aggarwal On 03 July 2015 at 16:41 BEST ANSWER

you need to enable binary log on this server by:

log_bin=1
BINLOG_FORMAT = STATEMENT  / MIXED / ROWS