mysql> show slave status
-> ;
+-------------+-------------+-------------+---------------+----------+-----+
---------------+-----------------+---------------------+------------+-------
-----+--------------+
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos |
Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno |
Last_error | Skip_counter |
+-------------+-------------+-------------+---------------+----------+-----+
---------------+-----------------+---------------------+------------+-------
-----+--------------+
| | test | 3306 | 60 | | 4
| Yes | | | 0 |
| 0 |
+-------------+-------------+-------------+---------------+----------+-----+
---------------+-----------------+---------------------+------------+-------
-----+--------------+
1 row in set (0.00 sec)
this is telling me it has NOT read from the
my.cnf Slave
[MYSQLD]
master-host=20.0.0.54
master-user=echo
master-password=<password>
master-port=3306
server-id=2
these are default values I think
if the below is the current log file from the slave, then the above slave
status is not up to date (can you provide a current 'show slave status\G'?)
the log 'FIRST' is NOT how mysql creates log files, I see no indication in
your .cnf files to say this would be different
the correct format for the log files should be (as far as the documentation
goes)<HOSTNAME>-bin.### by default
Look in your master mysql root directory for a file that matches this
format, that will be your log file
(i personally don't like the way your slave is changing the possition of the
log file either)
When you start slaving from a master, the slave MUST contain the exact same
data as the master at the very moment you started the binary logs on the
master
(apparently this wont be true in upcoming 4.x, you will be able to start a
slave at anytime)
I am not sure replication will create databases for you ( not tested, and
not even looked at ), not sure if that is binary logged
I do not know if changes to the 'mysql' database will get logged ( i do not
recall reference to that in the documentation ), so I am not sure if that
will change your slave data
-----Original Message-----
From: Raymond Brighenti [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 9:24 AM
To: 'Luc Foisy'; '[EMAIL PROTECTED]'
Subject: RE: Replication Problem
Hi,
I tried using a FreeBSD box with MySQL as the Master and W2K as the slave
and it works fine. I then swapped it so the W2K was master and I get the
following from the Unix box.
020510 14:14:22 mysqld started
/usr/local/libexec/mysqld: ready for connections
020510 14:14:22 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'FIRST' at position 4
020510 14:14:22 Slave: received 0 length packet from server, apparent
master shutdown: (0)
020510 14:14:22 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 31
020510 14:14:22 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31
020510 14:14:22 Slave: received 0 length packet from server, apparent
master shutdown: (0)
020510 14:15:23 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 31
020510 14:15:23 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31
020510 14:15:23 Slave: received 0 length packet from server, apparent
master shutdown: (0)
020510 14:16:23 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 31
020510 14:16:23 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31
020510 14:16:23 Slave: received 0 length packet from server, apparent
master shutdown: (0)
020510 14:17:23 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 31
020510 14:17:23 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31
020510 14:17:23 Slave: received 0 length packet from server, apparent
master shutdown: (0)
020510 14:18:23 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 31
020510 14:18:23 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31
020510 14:18:23 Slave: received 0 length packet from server, apparent
master shutdown: (0)
020510 14:19:23 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 31
020510 14:19:23 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31
020510 14:19:23 Slave: received 0 length packet from server, apparent
master shutdown: (0)
020510 14:20:23 Slave: Failed reading log event, reconnecting to retry, log
'FIRST' position 31
020510 14:20:23 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 31
020510 14:20:23 Slave: received 0 length packet from server, apparent
master shutdown: (0)
So it's reading the my.cnf file because I wouldn't be able to use it as a
slave otherwise.
Very strange, any other things to try?
Ray
-----Original Message-----
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: 10 May 2002 2:24
To: 'Raymond Brighenti'; MYSQL-List (E-mail)
Subject: RE: Replication Problem
actually you may want to change [MYSQLD] to [mysqld] and restart your slave
server
I don't think it has read your my.cnf file correctly ( that means the other
settings will not have taken affect either, like password and server ID)
-----Original Message-----
From: Raymond Brighenti [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 5:24 AM
To:
Subject: Replication Problem
Hi,
Trying to get replication going between to W2K machines and getting the
following errors in the Slave log file.
MySql: ready for connections
020509 18:58:52 Slave thread: error connecting to master:Can't connect to
MySQL server on '' (10049)(0), retry in 60 sec
020509 18:59:54 Slave thread: error connecting to master:Can't connect to
MySQL server on '' (10049)(0), retry in 60 sec
020509 19:00:57 Slave thread: error connecting to master:Can't connect to
MySQL server on '' (10049)(0), retry in 60 sec
Below are the two my.cnf files which as far as I can see should be ok.
my.cnf Master
[mysqld]
log-bin
server-id=1
my.cnf Slave
[MYSQLD]
master-host=20.0.0.54
master-user=echo
master-password=<password>
master-port=3306
server-id=2
Below are the output from some other checks, it's got the "connecting to
master" in the colum.
Looking at the log file it's getting the "MySQL server on ''" which seems to
indicate that it doesn't have a host or IP address to connect to!
Any ideas?
Thanks
Ray
So from Master...
mysql> show master status;
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+-------------------+----------+--------------+------------------+
| dnatest03-bin.002 | 73 | | |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
And from Slave...
mysql> show slave status
-> ;
+-------------+-------------+-------------+---------------+----------+-----+
---------------+-----------------+---------------------+------------+-------
-----+--------------+
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos |
Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno |
Last_error | Skip_counter |
+-------------+-------------+-------------+---------------+----------+-----+
---------------+-----------------+---------------------+------------+-------
-----+--------------+
| | test | 3306 | 60 | | 4
| Yes | | | 0 |
| 0 |
+-------------+-------------+-------------+---------------+----------+-----+
---------------+-----------------+---------------------+------------+-------
-----+--------------+
1 row in set (0.00 sec)
mysql> show processlist
+----+---------------+-----------+------+---------+------+------------------
----+------------------+
| Id | User | Host | db | Command | Time | State| Info
|
+----+---------------+-----------+------+---------+------+------------------
----+------------------+
| 1 | system user | none | NULL | Connect | 985 | connecting to
master| NULL |
| 2 | administrator | localhost | NULL | Sleep | 5 || NULL
|
| 3 | ODBC | localhost | NULL | Query | 0 | NULL| show
processlist |
+----+---------------+-----------+------+---------+------+------------------
----+------------------+
3 rows in set (0.02 sec)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
