Hey all,
I have setup replication in the past on 4.0.x servers so I figured I
knew what I was doing...silly me. I reread all of the docs and best I
can tell I followed them sufficiently.
When I start my slave, the SQL Thread starts, but the I/O thread never
starts, and thus the Master Thread never starts. There are no error
messages in any logs, or the show slave status screen. Below are my
relevant configurations. I am very sorry if I have left anything
significant out.
Thank you for any help,
Frank
MASTER CONFIG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[EMAIL PROTECTED] cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server-id=100
log-bin
binlog-do-db=internal
binlog-ignore-db=mysql
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
mysql> show master status\G
*************************** 1. row ***************************
File: server2-bin.000004
Position: 874
Binlog_Do_DB: internal
Binlog_Ignore_DB: mysql
1 row in set (0.00 sec)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SLAVE CONFIG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[EMAIL PROTECTED] cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server-id=200
replicate-do-db=internal
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[EMAIL PROTECTED] cat /var/lib/mysql/master.info
14
server2-bin.000003
79
cms.internal.org
slave
slavepass
3306
60
0
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: cms.internal.org
Master_User: slave
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: server2-bin.000003
Read_Master_Log_Pos: 79
Relay_Log_File: server1-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: server2-bin.000003
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB: internal
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 79
Relay_Log_Space: 4
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
