This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Jan 20th, 2013  |  syntax: None  |  size: 2.47 KB  |  views: 40  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. CHANGE MASTER TO MASTER_HOST='192.168.0.5',
  2. MASTER_PORT=3306,
  3. MASTER_USER='root',
  4. MASTER_PASSWORD='password-here',
  5. master_connect_retry=6000;
  6.  
  7. set global sql_log_bin=1;
  8. set global server_id=1;
  9. set auto_increment_increment=2;
  10. set auto_increment_offset=1;
  11.  
  12. start slave;
  13.        
  14. 121029  0:36:01  InnoDB: Waiting for the background threads to start
  15. 121029  0:36:02 Percona XtraDB (http://www.percona.com) 1.1.8-28.1 started; log sequence number 1624076
  16. 121029  0:36:02 [Note] Plugin 'FEEDBACK' is disabled.
  17. 121029  0:36:02 [Note] Event Scheduler: Loaded 0 events
  18. 121029  0:36:02 [Note] C:Program Files (x86)MariaDB 5.5binmysqld.exe: ready for connections. Version: '5.5.27-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
  19. 121029  0:39:05 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=JoshuaNotebook-relay-bin' to avoid this problem.
  20. 121029  0:39:05 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='192.168.0.5', master_port='3306', master_log_file='', master_log_pos='4'.
  21. 121029  0:39:05 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.JoshuaNotebook-relay-bin.000001' position: 4
  22. 121029  0:39:05 [Note] Slave I/O thread: connected to master 'root@192.168.0.5:3306',replication started in log 'FIRST' at position 4
  23. 121029  0:39:05 [ERROR] Error reading packet from server: Binary log is not open ( server_errno=1236)
  24. 121029  0:39:05 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Binary log is not open', Error_code: 1236
  25. 121029  0:39:05 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4
  26.        
  27. 121029  0:36:08  InnoDB: Waiting for the background threads to start
  28. 121029  0:36:09 Percona XtraDB (http://www.percona.com) 1.1.8-28.1 started; log sequence number 1623052
  29. 121029  0:36:09 [Note] Plugin 'FEEDBACK' is disabled.
  30. 121029  0:36:09 [Note] Event Scheduler: Loaded 0 events
  31. 121029  0:36:09 [Note] C:Program FilesMariaDB 5.5binmysqld.exe: ready for connections. Version: '5.5.27-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
  32. 121029  0:39:05 [Warning] IP address '192.168.0.20' could not be resolved: The requested name is valid and was found in the database, but it does not have the correct associated data being resolved for.
clone this paste RAW Paste Data