Hi I am running MySQL 3.23.49a, installed from the "official" RPMs. The master is on a (Linux) machine with a permanent Internet connection and an routeable IP address. The slave is at another location with a *nearly* permanent Internet connection, behind a masquerading firewall. Due to restrictions on ISP firewalls, I have set the MySQL port on both machines to be a non-standard 119 - this is normally the NNTP port, but I have NNTP commented out in inetd.conf to free the port up.
What I am finding puzzling is that replication is only working some of the time. There are no errors occuring in the error logs at either end. Master and slave stati show the same position. If I make a change on the master, the slave position always changes to match. *However*, the data on the slave does not necessarily change! All the transactions are updates and they have been tested in char and text fields on two different tables. Sufficient to say, this all worked fine when I tried it out in the lab (two machines on same LAN). Has anyone seen anything like this before, or can they give me any pointers as to what might be happening? Cheers M -- Matthew Smith | _ ASCII Ribbon Campaign IT Consultant | ( ) - No HTML/RTF in e-mail Kadina, South Australia | X - No Microsoft docs in e-mail http://www.kbc.net.au | / \ - No vCards Ph: +61 888 212 395 | --------------------------------------------------------------------- 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
