Start slave fails
I setup replication afresh recently. Here is what I did:
1. Run show master status to get log file and position.
2. Backup the master database and copy to slave host
3. Start the database on slave and configure master
4. Start slave
However, now the replication fails immediately. I have tried using sql_slave_skip_counter but it never seems to work. The skip counter shows 0 in slave status.
The version is 3.23.58-log and the OS on both hosts is RHEL AS release 3.
Are the steps above correct? If yes, please advise how I can repair / setup replication. The replication user has access and can login successfully to the master. It also has the right grants.
Thank you.
Subject
Views
Written By
Posted
Start slave fails
3541
March 23, 2010 06:51PM
1509
March 24, 2010 09:10AM
1685
March 24, 2010 05:40PM
1370
March 26, 2010 11:26PM
1478
March 27, 2010 05:19AM
1367
March 27, 2010 10:04AM
1610
March 27, 2010 05:00PM
1443
March 27, 2010 09:35PM
1347
March 28, 2010 05:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.