On 4/10/2006 8:50 PM, Yves Goergen wrote:
On 10.04.2006 18:32 (+0100), Jorrit Kronjee wrote:
I'm not entirely sure what you mean. Are `mysql4.mydomain' and
`mysql5.mydomain' hostnames?
Yes, as I have explained earlier in this thread.
Hostnames resolve into IP adresses, which are used to
On 11.04.2006 09:35 (+0100), Jorrit Kronjee wrote:
Hostnames resolve into IP adresses, which are used to connect to the
MySQL server. MySQL doesn't care if you connect via a hostname or via an
IP address. It's not virtual hosting like Apache does.
I know that. But to access different MySQL
On 09.04.2006 23:40 (+0100), Jorrit Kronjee wrote:
You seem to be best off with a setup where you've got the MySQL5 UNIX
socket disabled, MySQL5 bound to one specific IP address, MySQL4
listening on 127.0.0.1 and a simple port forwarding rule to MySQL4.
I'm missing the part to connect to
Yves Goergen wrote:
On 09.04.2006 23:40 (+0100), Jorrit Kronjee wrote:
You seem to be best off with a setup where you've got the MySQL5 UNIX
socket disabled, MySQL5 bound to one specific IP address, MySQL4
listening on 127.0.0.1 and a simple port forwarding rule to MySQL4.
I'm missing the
On 10.04.2006 18:32 (+0100), Jorrit Kronjee wrote:
I'm not entirely sure what you mean. Are `mysql4.mydomain' and
`mysql5.mydomain' hostnames?
Yes, as I have explained earlier in this thread.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
This message represents the official view of the
On 09.04.2006 01:03 (+0100), Eric Braswell wrote:
Does that make sense? Did I misunderstand?
That's exactly what I'm doing right now. In my test network:
MySQL 4.0 - 192.168.0.32 (mysql4.myhost)
MySQL 5.0 - 192.168.0.33 (mysql5.myhost)
But what I wanted to do is:
MySQL 4.0 -
But what I wanted to do is:
MySQL 4.0 - 192.168.0.32 and 127.0.0.1
MySQL 5.0 - 192.168.0.33
I'm going to assume you are using some kind of Unix-like platform. When
you connect to localhost, you are actually connecting by default through
a Unix socket file, not TCP/IP, because it is
On 09.04.2006 20:02 (+0100), Eric Braswell wrote:
I'm going to assume you are using some kind of Unix-like platform.
Correct, it's a Debian Linux x86.
When
you connect to localhost, you are actually connecting by default through
a Unix socket file, not TCP/IP, because it is much faster.
Yves Goergen wrote:
On 09.04.2006 01:03 (+0100), Eric Braswell wrote:
Does that make sense? Did I misunderstand?
That's exactly what I'm doing right now. In my test network:
MySQL 4.0 - 192.168.0.32 (mysql4.myhost)
MySQL 5.0 - 192.168.0.33 (mysql5.myhost)
But what I wanted to do is:
Jorrit Kronjee wrote:
You seem to be best off with a setup where you've got the MySQL5 UNIX
socket disabled, MySQL5 bound to one specific IP address, MySQL4
listening on 127.0.0.1 and a simple port forwarding rule to MySQL4.
Then your clients won't have to change anything and they can migrate
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
my.cnf:
bind-address = ip
Will probably do the trick.
How can I enter multiple IP addresses there? This isn't documented
online. I need to bind it to one specific external address and
additionally to localhost (127.0.0.1). The other server
I would be tempted to say
bind-address = Comma seperated list of IP's
or
Just a list of such statements one per line
bind-address = IP1
bind-address = IP2
.
.
But since you said this is not properly documented, I would encourage you to
give this a shot and find it out for
On 08.04.2006 18:31 (+0100), Kishore Jalleda wrote:
bind-address = Comma seperated list of IP's
Doesn't work. MySQL binds to address 255.255.255.255 instead. Also a
colon-separated list does this.
bind-address = IP1
bind-address = IP2
This always takes the last option, so if I add 127.0.0.1
Yves Goergen wrote:
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
my.cnf:
bind-address = ip
Will probably do the trick.
How can I enter multiple IP addresses there? This isn't documented
online. I need to bind it to one specific external address and
additionally to localhost
On 08.04.2006 23:14 (+0100), Eric Braswell wrote:
Yves Goergen wrote:
How can I enter multiple IP addresses there? This isn't documented
online. I need to bind it to one specific external address and
additionally to localhost (127.0.0.1). The other server is only bound to
another external
You can't specify multiple IPs for bind-address.
Let's back up. You want to run both 4.0 and 5.0, and you want to be able
to set it up so it's 'easy' to connect to each separate instance, i.e.
without having to specify different ports. This is pretty easy to do. In
this case you use separate
Hi,
I have a machine with multiple IP addresses on my network interface and
I have setup multiple MySQL servers on the machine, version 4.0 and 5.0.
Currently, they're all listening on all IP addresses on different ports
(3306 and 3307) but I'd like to make use of the second IP to make it
easier
my.cnf:
bind-address = ip
Will probably do the trick.
--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA
Yves Goergen wrote:
Hi,
I have a machine with multiple IP addresses on my network interface and
I have setup multiple MySQL servers on the machine, version 4.0 and 5.0.
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
my.cnf:
bind-address = ip
Will probably do the trick.
Thank you, that's what I was looking for.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Does the movement of the trees make the wind blow?
http://newsboard.unclassified.de -
19 matches
Mail list logo
