Page 1 of 1
mysql replication
Posted: Mon Jan 10, 2011 9:17 pm
by nobody
Hello guys.
I want to srtup a mysql replication. I have started reading the fine manuals.
Has anyone done so ? Maybe someone can also share some configurations and tips if so ?
Thanks !
Re: mysql replication
Posted: Mon Jan 10, 2011 10:52 pm
by nobody
Seems everything is ok with the master.
But whatever I do the slave wont run and I keep seeing this error :
Slave SQL Thread not running!
Slave IO Thread not running!
Any ideas ?
Re: mysql replication
Posted: Mon Jan 10, 2011 10:57 pm
by mikeshinn
Sounds like you make not have configured the slave correctly. How did you setup replication?
Re: mysql replication
Posted: Mon Jan 10, 2011 11:07 pm
by nobody
mikeshinn wrote:Sounds like you make not have configured the slave correctly. How did you setup replication?
Hi Mike !
In the my.cnf I have
Code: Select all
server-id=2
master-host = hostname
master-user = myuser
master-password = thepass....
master-port = 3306
relay-log = mysql-bin
log-bin=mysql-bin
log-error=mysql-bin.err
report-host=host_vm
I also run a query
Code: Select all
CHANGE MASTER TO
MASTER_HOST='host',
MASTER_USER='user',
MASTER_PASSWORD='pass',
MASTER_PORT=3306,
MASTER_LOG_FILE='master2-bin.001',
MASTER_LOG_POS=4,
MASTER_CONNECT_RETRY=10;