MySQL Forums
Forum List  »  Replication

Master Server ID problem
Posted by: kenny w
Date: June 12, 2013 09:30PM

hi,
i would like to setup the replication for master and slave. i am using mysql 5.6 windows version. under the master , i set the my.ini file with following information :
server-id=5
binlog-format = mixed
port = 3307
log-bin = "C:/Program Files/MySQL/MySQL Server 5.6/mysql-bin.log"
datadir="C:/Program Files/MySQL/MySQL Server 5.6/data/"
basedir = "C:/Program Files/MySQL/MySQL Server 5.6/"
innodb_flush_log_at_trx_commit=1
sync_binlog=1

i restarted the mysql services. the problem when i check with the sql command SHOW VARIABLES LIKE 'server_id'; the server_id always show 1 even i set it to differ number.

please help what should i do ? thank a lot

Options: ReplyQuote


Subject
Views
Written By
Posted
Master Server ID problem
1775
June 12, 2013 09:30PM
922
June 16, 2013 09:23AM
971
June 18, 2013 12:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.