Hello Experts,
Our environment is this:
Linux (centos 5) machine running MySQL 5.0.45
Windows (2003 server) machine running MySQL 5.0.45
The situation:
Replication has been setup on both machines, the linux machine being the master, and all logs and status' point it to be effective. However, the data simply does not replicate.
The following is the Master config, status and processlist and then the Slave config, status and processlist.
I've explored this being a firewall issue somewhere as the machines are not on the same network, or even on a VPN, I've opened a large range of ports, but to no avail. I'm at a loss.
MASTER CONFIG:
##########################
##########
##
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysq
l.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log-slow-queries=/var/log/
mysql/log-
slow-queri
es.log
key_buffer_size=1M
tmp_table_size=32M
max_heap_table_size=32M
thread_cache_size=6
table_cache=4
query-cache-type=1
query-cache-size=20M
query_cache_limit=1M
max_connections=500
interactive_timeout=160
wait_timeout=160
connect_timeout=100
log-bin=mysql-bin
server-id=1
binlog-do-db=HafcoLive
binlog-do-db=MxLive
binlog-do-db=NZLive
binlog-do-db=TFI
[mysqld_safe]
log-error=/var/log/mysqld.
log
pid-file=/var/run/mysqld/m
ysqld.pid
##########################
##########
##
mysql> SHOW MASTER STATUS\G
**************************
* 1. row **************************
*
File: mysql-bin.000011
Position: 499478
Binlog_Do_DB: HafcoLive,MxLive,NZLive,TF
I,HafcoLiv
e,MxLive,N
ZLive,TFI
Binlog_Ignore_DB:
1 row in set (0.00 sec)
##########################
##########
##
mysql> SHOW PROCESSLIST\G
**************************
* 1. row **************************
*
Id: 3721
User: ******
Host: ************:28952
db: NULL
Command: Binlog Dump
Time: 4500
State: Has sent all binlog to slave; waiting for binlog to be updated
Info: NULL
##########################
##########
##
SLAVE CONFIG:
##########################
##########
##
[client]
port=3307
[wampmysqld]
port=3307
basedir=C:/Website/WAMP/bi
n/mysql/my
sql5.0.45
log-error=C:/Website/WAMP/
logs/mysql
.log
datadir=C:/Website/WAMP/bi
n/mysql/my
sql5.0.45/
data
default-character-set=lati
n1
default-storage-engine=INN
ODB
max_connections=500
query_cache_size=20M
table_cache=4
tmp_table_size=32M
thread_cache_size=6
#*** MyISAM Specific options
myisam_max_sort_file_size=
100G
myisam_max_extra_sort_file
_size=100G
myisam_sort_buffer_size=8M
key_buffer_size=9M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=203K
#*** INNODB Specific options ***
innodb_additional_mem_pool
_size=2M
innodb_flush_log_at_trx_co
mmit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=15
M
innodb_log_file_size=10M
innodb_thread_concurrency=
8
[mysqld]
port=3307
server-id=2
replicate-do-db=HafcoLive
replicate-do-db=MxLive
replicate-do-db=NZLive
replicate-do-db=TFI
binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=phpmyadmi
n
binlog-ignore-db=informati
on_schema
##########################
##########
##
mysql> SHOW SLAVE STATUS\G
**************************
* 1. row **************************
*
Slave_IO_State: Waiting for master to send event
Master_Host: ****
Master_User: *****
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000011
Read_Master_Log_Pos: 499478
Relay_Log_File: hfwamp-relay-bin.000012
Relay_Log_Pos: 470547
Relay_Master_Log_File: mysql-bin.000011
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: HafcoLive,MxLive,NZLive,TF
I
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Tabl
e:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 499478
Relay_Log_Space: 470547
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: 0
1 row in set (0.00 sec)
##########################
##########
##
mysql> show processlist\G
**************************
* 1. row **************************
*
Id: 1
User: system user
Host:
db: NULL
Command: Connect
Time: 4465
State: Waiting for master to send event
Info: NULL
**************************
* 2. row **************************
*
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 7
State: Has read all relay log; waiting for the slave I/O thread to update it
Info: NULL
##########################
##########
##
I hope this information helps, because its awful wall of text if it doesn't.
Any help is greatly appreciated.