MySQL Forums
Forum List  »  Replication

Re: Replication activation
Posted by: Aftab Khan
Date: July 19, 2012 08:07AM

>So i have change configuration in my.cnf to add replication config, but how can i activate it without restart ?

If you have changed MySQL config that is required to setup replication then you would need to restart MySQL server.

Can we see output of the following commands to see if you need to restart MySQL?

SHOW GLOBAL VARIABLES 
WHERE variable_name LIKE 'log_bin' 
OR 
variable_name LIKE 'server_id' ;

And following from shell prompt
my_print_defaults -c /etc/my.cnf mysqld | egrep "^\-\-log-bin=|\-\-server-id"


Options: ReplyQuote


Subject
Views
Written By
Posted
1660
July 18, 2012 10:58AM
968
July 18, 2012 04:21PM
Re: Replication activation
1160
July 19, 2012 08:07AM
744
July 29, 2012 08:41AM


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.