Talk:Shared webhosting - Revision history

193.175.8.58: /* MySQL Socket Sharing */

2012-03-19T10:10:41Z

‎MySQL Socket Sharing

2011-11-15T19:54:45Z

‎MySQL Socket Sharing

2011-07-15T16:39:29Z

2011-02-16T12:48:36Z

2011-02-16T12:25:26Z

Is sharing mysql unix sockets decreasing security on mysql root user?

2008-04-28T20:23:55Z

‎MySQL Socket Sharing

2007-04-14T21:06:54Z

MySQL Socket Sharing

2006-11-09T13:52:45Z

‎Proxying

2006-11-09T13:52:09Z

‎Proxying

2006-11-09T13:51:53Z

‎Proxying

@@ Line 40: / Line 40: @@
    bind-address            = 10.100.100.220
 fixed it for us.  using ubuntu 11.10
 ------------

← Older revision		Revision as of 19:54, 15 November 2011
Line 28:		Line 28:

	== MySQL Socket Sharing ==		== 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.1
		+	to
		+	bind-address = 10.100.100.220
		+	fixed it for us. using ubuntu 11.10
		+	------------

	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.		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.

← Older revision		Revision as of 16:39, 15 July 2011
Line 1:		Line 1:
		+	== 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 ==		== Linking to howto pages ==
	I probably did something stupid, but how can I link from the HOWTO's to this page?		I probably did something stupid, but how can I link from the HOWTO's to this page?

@@ Line 1: / Line 1: @@
 --[[User:Hvdkamer|Hvdkamer]] 08:23, 2 August 2006 (EDT)
 : 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>

← Older revision		Revision as of 12:25, 16 February 2011
Line 31:		Line 31:
	This is with Ubuntu Hardy (fixed kernel from Git).		This is with Ubuntu Hardy (fixed kernel from Git).
	[[User:Blueyed\|Blueyed]] 16:23, 28 April 2008 (EDT)		[[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?

@@ Line 25: / Line 25: @@
 == 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)
+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.
-<pre>
+Additionally, "mysql -u root -p -S /vz/root/123/var/run/mysqld/mysqld.sock" fails with:
-# 101 is the MySQL Server VEx (debian 4.0)
+ ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/vz/root/1234/var/run/mysqld/mysqld.sock' (111)
-# 102 Another VEx (opensuse 10.0)
+This is with Ubuntu Hardy (fixed kernel from Git).
-ln /var/lib/vz/private/101/var/run/mysqld/mysqld.sock /var/lib/vz/private/102/var/run/mysqld/mysqld.sock
+[[User:Blueyed|Blueyed]] 16:23, 28 April 2008 (EDT)

← Older revision		Revision as of 21:06, 14 April 2007
Line 22:		Line 22:

	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)		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>

← Older revision		Revision as of 13:52, 9 November 2006
Line 21:		Line 21:
	== Proxying ==		== 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)	+	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)

← Older revision		Revision as of 13:51, 9 November 2006
Line 21:		Line 21:
	== Proxying ==		== 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.	+	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)