Advertisement
Guest User

Untitled

a guest
Jan 20th, 2013
593
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.47 KB | None | 0 0
  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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement