I'm trying to create MariaDB cluster but when i try to register the node and then checked if is it worked or not by:

mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size'"

I get this error

mysql: unknow variable 'binlog_format=ROW'

I already configured it






*# Galera Provider Configuration



*# Galera Cluster Configuration



*# Galera Synchronization Configuration


*# Galera Node Configuration



Somewhere in the [client] or [mysql] sections of your cnf files you also have binlog_format=ROW. You need to remove it (only from those sections, not from [mysqld]!).

To get an idea where the client might be searching for cnf files, run

mysql --no-defaults --help | grep cnf

In general, mysql --no-defaults <other parameters> is a workaround, but not a convenient one, so it's better to find the wrong configuration and fix it.

| improve this answer | |
  • could be there another reason? because i found nothing !! – Yaser Jawi Nov 29 '16 at 14:30
  • If mysql --no-defaults works, there is no other reason, somewhere there is a file with this problem. If mysql --no-defaults does not work, then there must be another reason. So, does it work? – elenst Nov 29 '16 at 14:32
  • now i got this message :: " Usage: /etc/init.d/mysql start |stop |restart |reload |force-reload |status |bootstrap" – Yaser Jawi Nov 30 '16 at 7:52
  • Run which mysql. You either have /etc/init.d on PATH, or you have the current dir at the beginning of PATH, and you are trying to run mysql while you're in /etc/init.d. In any case, it's not mysql client, it's just the script. – elenst Nov 30 '16 at 10:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.