mysql replication

[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 !

[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 ?

[mikeshinn]

Sounds like you make not have configured the slave correctly. How did you setup replication?

[nobody]

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;