Hi, You can edit /etc/hosts and redirect localhost to the new DB IP and create a hostname for your client1 like client1db to IP and ask them to migrate.. from localhost to clientdb.. Hth, -----Original Message----- From: Marc Perkel [mailto:marc@xxxxxxxxxx] Sent: Wednesday, October 17, 2007 1:37 PM To: users@xxxxxxxxxxxxxxxx Subject: [SPAM] - MySQL Related problem - Email found in subject Hi Everyone, I'm hosting a lot of domains for a lot of people who have a lot of MySQL applications that they installed and almost all are configured to talk to MySQL on "localhost". In order to spread the load I'm trying to move the MySQL server to another machine. Since everything is configured for localhost I figured all I had to do was move the database to the new server, shut down the existing MySQL server, and set up an SSH tunnel so that all the MyDQL call on the original server would pipe to the new server. But that doesn't work. The problem is that PHP/MySQL apps configured for localhost insiste on talking to the socket located at /var/lib/mysql/mysql.sock instead of 127.0.0.1. In the MySQL world, localhost != 127.0.0.1. I tried using the pipe and socat on the socket but socat wasn't reliable and quit working for reasons I don't understand. So I'm wondering how to make it work. Has anyone managed to get this to work? I'm also thinking about this. Could I mount the new MySQL server using NFS so that /var/lib/mysql/mysql.sock is on the new MySQL server and calls to that socket would go to the new server. Will that work? Thanks in advance. --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx -------------------------------------------------------------------------------------------------------- This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|