: Thu 9/9/2004 9:51 AM
To: [EMAIL PROTECTED]; Sanjeev Sagar
Cc: [EMAIL PROTECTED]; Sanjeev Sagar
Subject: RE: Multiple MysQL servers with different IP address on same machine
Hi
We have a machine with 2 IP addresses and mysql 3.23 on one and 4.10 on the
other. Both using port 3306
One instance
mailto:[EMAIL PROTECTED]
> Sent: 09 September 2004 14:53
> To: Sanjeev Sagar
> Cc: [EMAIL PROTECTED]; Sanjeev Sagar
> Subject: Re: Multiple MysQL servers with different IP address on same
> machine
>
>
> I need to add to my previous post -- You asked about using the SAME
> o
I need to add to my previous post -- You asked about using the SAME
operating system socket as well as using separate addresses with the same
port number (different IP sockets)
My answer to that is NOT ON YOUR LIFE. Think of the chaos. If one client
tried to connect to an OS socket that 3 diffe
An "IP socket" is the unique combination of an IP address and a port
number. I don't see why you couldn't run those separate instances of your
db servers on the same port but each with their own addresses as they
would each have their own unique "IP socket". I don't think you would
create any c
The example below renames a col. But can I rename a col. w/out giving
all that type spec. at the end of the statement below. I just want to
rename everything else stays the same. Thanks.
mysql> ALTER TABLE search CHANGE Description PageDescription
VARCHAR(255) NOT NULL;
--
MySQL General Mailing
Hello All,
MySQL : Standar Binary 4.0.20
O/S : Red Hat Linux release 9 (Shrike)
Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686 i386 GNU/Linux
I already have setup of Three Multiple MySQL servers listening on different ports and
sockets on same machine
Option File:
[mysqld
