| Bug #57780 | Server Replication | ||
|---|---|---|---|
| Submitted: | 27 Oct 2010 18:51 | Modified: | 28 Oct 2010 3:31 |
| Reporter: | Basavaraju K T | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | Tests: Replication | Severity: | S4 (Feature request) |
| Version: | 1 | OS: | Any (all) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | slave startup error | ||
[27 Oct 2010 18:55]
Basavaraju K T
and I am using version 5.1.49 x86
[27 Oct 2010 19:12]
Basavaraju K T
small mistake in submitted data :
user name in the CHANGE MASTER TO output is : 'userx'
and output of SHOW SLAVE STATUS\G is : 'repl_user'
but it is my mistake actually that is : 'repl_user'
sorry for this
[28 Oct 2010 3:31]
Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL.
Description: I have configured my.cnf files at master and slave I am using Ubuntu 10.1 server and ubuntu desktop 10.1 as a virtual machines with master id =1 and slave id =2 I googled for solution but I did not get any thing that solve this please help me with solution thanks ... How to repeat: At master Machine: master> show master status; +-------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +-------------------+----------+--------------+------------------+ | master-bin.000002 | 106 | | | +-------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) At Slave machine: slave>CHANGE MASTER TO MASTER_HOST = '192.168.153.129', MASTER_PORT = 3306, MASTER_USER = 'userx', MASTER_PASSWORD = 'xxxx',MASTER_LOG_FILE='master-bin.000002',Master_Log_Pos=106; slave>show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 192.168.153.129 Master_User: repl_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: master-bin.000002 Read_Master_Log_Pos: 106 Relay_Log_File: ubuntu-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: master-bin.000002 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 106 Relay_Log_Space: 106 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.10 sec) slave>slave start ; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO Suggested fix: I don not know