Open main menu

OpenVZ Virtuozzo Containers Wiki β

Changes

Talk:Shared webhosting

2,120 bytes added, 10:10, 19 March 2012
MySQL Socket Sharing
== Sharing mysql socket ==
Wouldn't it be easier to just link the directory containing the socket using 'mount --bind'? Don't think that inode will change. [[Special:Contributions/62.195.200.207|62.195.200.207]] 16:39, 15 July 2011 (UTC)
 
== Linking to howto pages ==
I probably did something stupid, but how can I link from the HOWTO's to this page?
--[[User:Hvdkamer|Hvdkamer]] 08:23, 2 August 2006 (EDT)
I probably did something stupid, but how can I link from the HOWTO's to this page?
: If you want to link to the Category:HOWTO, you put it like this
: <code><nowiki>[[:Category:HOWTO HOWTOs (i.e. this is link text)]]</nowiki></code>
== Proxying ==
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 == 2011-11-15 I had this issue using mysql :<pre> Could not connect to database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 111115 22:05:40 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 111115 22:05:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?</pre>changing bind-address in /etc/mysql/my.cnf from bind-address = 127.0.0.1to bind-address = 10.100.100.220fixed it for us. using ubuntu 11.10 :i had the same error message. my mistake was that i had no loopback-interface configured. adding auto lo iface lo inet loopback:to /etc/network/interfaces and restarting networking fixed it for me. (debian)------------ There's a good guide, using "mount --bind" available at http://sudhaker.com/2008/04/isolated-mysql-installation-openvz-cluster/, but I couldn't get it to work.Also the "ln /var/lib/vz/private/101/var/run/mysqld/mysqld.sock ..." mentioned in the article itself does not work for me: the mysqld.sock only appears in /vz/root/123, not /vz/private/123.Additionally, "mysql -u root -p -S /vz/root/123/var/run/mysqld/mysqld.sock" fails with: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/vz/root/1234/var/run/mysqld/mysqld.sock' (111)This is with Ubuntu Hardy (fixed kernel from Git).[[User:Blueyed|Blueyed]] 16:23, 28 April 2008 (EDT) === Decreased security ===Isn't sharing sockets blocking advantages promoted in <blockquote>"As an extra security measure you can use the internal IP-address as well."</blockquote> I'd actually would like to have mysql reject root user logins unless logging in from VE actually housing mysql server. That's impossible on using Unix sockets since it's always using "localhost" then, isn't it?
Anonymous user