Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. SHOW SLAVE STATUS G;
  2.  
  3. port=3306
  4. log-bin
  5. server-id=1
  6. master-host=10.0.0.2
  7. master-user=server_1_repl
  8. master-password=server_1_passwd
  9. master-port=3306*
  10.  
  11. cd /var/lib/mysql
  12. service mysql stop
  13. rm -f master.info relay-*`
  14. service mysql start
  15.  
  16. select * from information_schema.events where status = 'SLAVESIDE_DISABLED';
  17.  
  18. alter event <event_name> enable;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement