View Single Post
Old 17th May 2013, 15:57
mphayesuk mphayesuk is offline
Senior Member
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default New System SQL Replication Failing

Hi guys, its been a long time but I am finally installing a brand new production system and I have run into a few issues.

I am following the Debian step by step guide for a cluster setup and cant get the SQL replication to work.

So I have granted the user rights on server 1 then I have changed the my.cnf file on bother servers and stopped the sql server after making the changes.

So Mysql is not running on bother servers.
Then I copy the files accross (mysql and debian.cnf) to server 2

Then I start mysql on server 1, note the position and file name and then run through the stop slave > change to master.... > start slave > show slave status

Here I have an io error 2013 error connecting to master on server2

I have tried to telnet on the 3306 port and because the guide does not say start the server2 mysql I cant connect. If I try and start mysql on server2 it doesnt start anyway. I cant see any error logs on server2 even though I have turned on logging in the my.cnf "General_log_file"

So can someone point me in the right direction... please
Reply With Quote
Sponsored Links