0

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

  [mysqld]

    binlog_format=ROW

default-storage-engine=innodb

innodb_autoinc_lock_mode=2

bind-address=0.0.0.0

*# Galera Provider Configuration

wsrep_on=ON

wsrep_provider=/usr/lib/galera/libgalera_smm.so

*# Galera Cluster Configuration

wsrep_cluster_name="test_cluster"

wsrep_cluster_address="gcomm://192.168.10.147,192.168.10.148,192.168.10.149"

*# Galera Synchronization Configuration

wsrep_sst_method=rsync

*# Galera Node Configuration

wsrep_node_address="192.168.10.147"

wsrep_node_name="node"
0

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.

  • 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.