ch huang wrote:
> *i see the following text in manual, but can not get any result using this
> command "*
>
> *SHOW VARIABLES LIKE 'binlog_format' " ,and my mysql version is 5.0*
Please use MySQL Cluster NDB-6.3 or NDB-7.0.
We do not recommend MySQL 5.0 for new Cluster deployments, and we
encourage anyone using MySQL 5.0 for Cluster to upgrade as soon as possible.
BTW, binlog_format does not exist before MySQL 5.1 (and current Cluster
versions are based on MySQL 5.1).
>
> *
> 16.3.4.10: ** How do I tell whether a master server is using statement-based
> or row-based binary logging format? *
>
> Check the value of the
>
> binlog_format<http://dev.mysql.com/doc/refman/5.1/en/replication-options-binary-log.html#sysvar_binlog_format>system
> variable:
>
> mysql> *SHOW VARIABLES LIKE 'binlog_format';*
>
>
> mysql> show variables like 'binlog_format';
> Empty set (0.00 sec)
>
--
Jon Stephens - jon.stephens@stripped
Technical Writer
MySQL Documentation Team
Sun Microsystems AB
MySQL and Software Infrastructure Group
Liljeholmen (Stockholm), Sweden
Summer: UTC +02.00 / Winter: UTC +01.00
Mobile: +46 (0) 736 773 993
Skype: plastic-fish
MySQL: www.mysql.com
Sun: www.sun.com