Have you actually tried this? Do you have sample scripts? Is there any
one who has tried MySQL Proxy and made it work?
Samuel Vogel wrote:
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: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
