469,266 Members | 2,028 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,266 developers. It's quick & easy.

"show slave status" returns nothing

I seem to have replication set up correctly to only replicate one
database named vmail.*

Except when I try to update a table in vmail.* the changes do not
replicate to the slave. Authentication works fine. Binary logging
(log-bin) is enabled on both.

I have a feeling about one thing that might be wrong - "Binlog_do_db"
on the master server is empty when it should be "vmail".

Also "show slave status" on the master returns no results. There are
no error messages on either of the servers. Any ideas? Thanks a
bunch,
John

Various troubleshooting information follows:

Here are some settings for the Master Server:

my.cf (obvious settings left out):
log-bin
server-id = 1
replicate-do-db = vmail.*

mysql> show master status; # (run on master)
+--------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+--------------+----------+--------------+------------------+
| webx-bin.001 | 7835 | | |
+--------------+----------+--------------+------------------+

mysql> show slave status; # (run on master) this is empty

mysql> show processlist;
| 201 | repl | slave.local:42628 | NULL | Binlog Dump | 300 |
Slave: waiting for binlog update | NULL |
Here are some settings on the Slave Server:

my.cf (obvious settings left out):
log-bin
server-id = 10
replicate-do-db = vmail.*
mysql> show slave status\G
*************************** 1. row ***************************
Master_Host: webx
Master_User: repl
Master_Port: 3306
Connect_retry: 60
Master_Log_File: webx-bin.001
Read_Master_Log_Pos: 7835
Relay_Log_File: mx0-relay-bin.001
Relay_Log_Pos: 1934
Relay_Master_Log_File: webx-bin.001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db: vmail.*
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 7835
Relay_log_space: 1934
Jul 19 '05 #1
0 3681

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Christian Eriksson | last post: by
reply views Thread by John Yasaitis | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.