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 s
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
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
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 par
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 M
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
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
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.
> 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
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 -> 19
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 c
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 exte
Yves Goergen wrote:
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
my.cnf:
bind-address =
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). T
On 08.04.2006 18:31 (+0100), Kishore Jalleda wrote:
> bind-address =
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 after the other
IP, it wil
I would be tempted to say
bind-address =
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 yourself on a Spare/Test Mysql Bo
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
> my.cnf:
>
> bind-address =
>
> 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 serve
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
> my.cnf:
>
> bind-address =
>
> 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 - Un
my.cnf:
bind-address =
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.
Currently, t
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 t
19 matches
Mail list logo
