| Bug #76805 | Unable to configure the Slave host for the Database Replication | ||
|---|---|---|---|
| Submitted: | 23 Apr 2015 11:05 | Modified: | 23 Apr 2015 11:30 |
| Reporter: | DHANANJAYA CHOWDAPPA | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 5.6.24 | OS: | Linux (CentOS 6.2) |
| Assigned to: | CPU Architecture: | Any | |
[23 Apr 2015 11:30]
MySQL Verification Team
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: Hi, I am new to the mysql, I am trying to configure the mysql replication on cent os with master and single slave. I am unable to configure the slave. Changing the master host and setting username and passwords leads to the following error in the mysql shell. Error is "ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log." I was unable to start the mysql service, I appplied the workaround not to use the /etc/my.cnf Manually set the server_id is fine, still above error is throwing. If i try to run the commands slave start or slave stop, The below error is seen. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER_LOG_POS=539' at line 1 Workaround/solution mentioned in the forums did'nt solved the issue. Any help is highly appreciated. Thanks, Dhananjaya How to repeat: 1.Configure Master 2.Export the database to slave host 3.update the /etc/my.cnf as per requirement 4.Run the any of the commands in slave mysql shell mysql> CHANGE MASTER TO MASTER_HOST='X.X.X.X', -> MASTER_USER='user', -> MASTER_PASSWORD='password', -> MASTER_log_FILE='mysql-bin.000001', -> MASTER_LOG_POS=539;