httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Samuel Vogel <samy-de...@gmx.de>
Subject Re: [users@httpd] MySQL Related problem
Date Wed, 17 Oct 2007 17:54:08 GMT
You should probably take a look at MySQL Proxy:
http://dev.mysql.com/tech-resources/articles/proxy-gettingstarted.html

It can do exactly what you want and much more ;)

Regards,
Samy

Marc Perkel schrieb:
> 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@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org

---------------------------------------------------------------------
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@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message