RE: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread Sanjeev Sagar
: 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

RE: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread Peter Lovatt
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

Re: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread SGreen
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

Re: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread SGreen
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

Re: Multiple MysQL servers with different IP address on same machine

2004-09-08 Thread leegold
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