Tuesday, September 11, 2012

mysql: replication for v5.5 up - unknown command variable master-host

got unknown command variable master-host

apparently, the ff variables (with other master options) for replication in mysql configuration file my.cnf were removed starting form version 5.5

master-host=223.223.223.35
master-user=repl
master-password=replMaster
master-port=3306


instead, you must issue the ff from mysql:

CHANGE MASTER TO MASTER_HOST="223.223.223.35", MASTER_USER="repl", MASTER_PASSWORD="replMaster", MASTER_LOG_FLIE="masterdb-bin.000001", MASTER_LOG_POS=1;


you can get the master log position by issuing SHOW MASTER STATUS in your master

don't forget to start slave
START SLAVE;

No comments:

Post a Comment

SSH : No matching host key type found. Their offer: ssh-rsa,ssh-dss

Got this while connecting to my mikrotik router via ssh   Unable to negotiate with <ip address> port <ssh port>: no matching hos...