Binlog format is a dynamic variable, you can change this variable at
runtime. You can also change the binlog format for a specific session
in case that you need it.
From the doc:
The logging format also can be switched at runtime. To specify the
format globally for all clients, set the global value of the
binlog_format system variable:
mysql> SET GLOBAL binlog_format = 'ROW';
My recommendation is make the change at runtime AND make the change in
the my.cnf file for the next reboot.
Martin Arrieta.
On 3 August 2012 05:42, Götz Reinicke <goetz.reinicke@stripped> wrote:
> Hi,
>
> we run a master/slave mysql 5.1.61 Red Hat EL 6.3 setup - two servers.
>
> Both use the default binlog format.
>
> Today I'm asked to change the bin log format to 'ROW' because a special
> Application needs that format. (Confluence Wiki ...)
>
> My Question:
>
> Is it possible to shutdown servers, 'just' change the option (my.cfg) on
> both, the master and the slave, start servers without expecting known
> problems?
>
> We do have a few databases currently installed (for Websit, Webmail,
> projektmanagement software) which work fine with all the curren (and
> default) mysql server settings.
>
> Thanks for any suggestions or hints! Regards . Götz
> --
> Götz Reinicke
> IT-Koordinator
>
> Tel. +49 7141 969 82 420
> Fax +49 7141 969 55 420
> E-Mail goetz.reinicke@stripped
>
> Filmakademie Baden-Württemberg GmbH
> Akademiehof 10
> 71638 Ludwigsburg
> www.filmakademie.de
>
> Eintragung Amtsgericht Stuttgart HRB 205016
>
> Geschäftsführer:
> Prof. Thomas Schadt
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication
>
