0

i want to run a mysql command START SLAVE; is it possible to do that?

friends
  • 589
  • 5
  • 10
  • 16
  • don't know what your meanings – friends Nov 12 '10 at 07:52
  • before enable replication u must setup a master - http://dev.mysql.com/doc/refman/5.0/en/replication.html PS:always replied with @username, otherwise, answerer will not get notified easily – ajreal Nov 12 '10 at 08:41
  • already success, but when the server restart, i have to type START SLAVE to make the replication take effect – friends Nov 12 '10 at 09:55

1 Answers1

0

As long as the master is properly configured it's ok to restart the slaves. They will automatically reissue the "START SLAVE" on restart.

I think if there are replication errors, you may have to fix them or reset replication before restarting the slaves.

http://dev.mysql.com/doc/refman/5.0/en/start-slave.html

Jay Prall
  • 5,295
  • 5
  • 49
  • 79