9
edits
Changes
MySQL Socket Sharing
I would suggest using [http://www.apsis.ch/pound/ Pound] as the Proxy Server running on your Frontend VE. Its a pretty lightweight and _fast_ Proxy. Besides proxying it does also support load balancing, failover and SSL. I've been using it for various projects over the past few years, its proven to be pretty stable and reliable. --[[User:Torsten|Torsten]] 14:51, 9th Nov 2006 (CST)
== MySQL Socket Sharing ==
I found it was a good idea sharing the MySQL Socket instead of using TCP/IP. (which is also <b>ALOT</b> faster)
<pre>
# 101 is the MySQL Server VEx (debian 4.0)
# 102 Another VEx (opensuse 10.0)
ln /var/lib/vz/private/101/var/run/mysqld/mysqld.sock /var/lib/vz/private/102/var/run/mysqld/mysqld.sock
</pre>
The result
<pre>
opensuse:/ # mysql -u root -p -S /var/run/mysqld/mysqld.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.32-Debian_7etch1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
</pre>
