Hi there,
I wish to setup replication between a pair of mysql servers. However since my slave only has an ADSL connection to the master I want to compress the data between them. A small wrapper around zlib does this for me. My slave mysql must therefore connect to a port on the local machine that will connect onto the real master. However... if you put master-host=localhost into my.cnf then mysql tries to use the /tmp/mysql.sock. Fair enough. Putting master-host=<ip address of local server>, master-port=12345 however also tries to use the /tmp/mysql.sock. This should clearly not happen unless BOTH master-host and master-port match the server that has the socket. Given that a client presumably can't tell whether the socket is for the same mysqld process as some host,port combo I would suggest that automatic switching to the socket should only be used for localhost (127...) ip addresses. I've not looked into the sources yet to see whether theres some other obscure option to do what I'm trying to achieve but will do later (unless someone tells me about it first!). I'll probably produce a patch (and post it here) for the above behavior. Regards, Chris -- Chris Wilson <[EMAIL PROTECTED]> http://www.wapmx.com --------------------------------------------------------------------- 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
