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