MySQL Forums
Forum List  »  Replication

i dont know what is wrong ...
Posted by: hector fragoso
Date: July 11, 2005 09:34AM

i have 3 servers mysql 4.0.24 A-B-C, A and C runs in the same pc and B runs in other pc, in other location. their conected by DSL conection 1 mega in both sides. it replicates in this form...
B replicates only a table named CLIENTES in server A. C replicates B complety the dabatbase PLEY. the database is named PLEY in the 3 servers
the problem is that C lost the conection with B if it stay idle for a while.
All the donfiguration for dyndns, firewalls and routers works fine.
server A & C are difernet services and have ports 3306 for A and 3307 for C
so why C lost conection?

here are the ini files....

Server A:
[mysqld]
skip-innodb
server-id=3
log-bin=menudeomaster
relay-log=menmasterelay
basedir=d:/mysql
datadir=d:/data
language=d:/mysql/share/spanish
max_allowed_packet=15m
port=3306
-------------------------------
Server C:
[mysqlbodega]
skip-innodb
server-id=41
log-bin=replicamayoreo
relay-log=replicarelay
basedir=d:/mysql
datadir=d:/databodega
set-variable=key_buffer=32M

log-warnings
delay-key-write=all
log-slave-updates

master-host=mmayoreo.dyndns.org
master-user=replica
master-password=xxxxxx
master-port=3306

slave_compressed_protocol=1
log-slave-updates
report-host=replicaBodega
port=3307
replicate-do-db=pley
------------------------------
Server B:
[mysqld]
skip-innodb
server-id=11
log-bin=bodegabin2
relay-log=bodegarelay2
basedir=z:/mysql4024
datadir=z:/mysql4024/data
set-variable=key_buffer=32M

log-warnings
delay-key-write=all
log-slave-updates

master-host=mmenudeo.dyndns.org
master-user=replica
master-password=xxxxx
master-port=3306

slave_compressed_protocol=1
log-slave-updates
report-host=Bodega2
replicate-wild-do-table=pley.clientes
-------------------------
please help me im getting crazy with phone calls of my customer asking me to "refreseh" the C server. and shoutdown and starting server C to solve the problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
i dont know what is wrong ...
2774
July 11, 2005 09:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.