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 collisions or contentions beyond that of pure network congestion.
My tentative answer is: "It should work fine but I have not tried it yet so I don't know from personal experience" Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote on 09/08/2004 05:04:38 PM: > > 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: > > [mysqld1] > server-id =1 > port=3306 > socket=/tmp/mysql.sock > datadir=data1 > > [mysqld2] > server-id=2 > port=3307 > socket=/tmp/mysql.sock2 > datadir=data2 > > [mysqld3] > server-id=3 > port=3308 > socket=/tmp/mysql.sock3 > datadir=data3 > > All three servers started with no problem. Question is if I don't > want to use different ports or scokets, can I use the different I.P. > Addresses on same machine for three servers with same default port or socket. > > /etc/hosts file > =============== > > 127.0.0.100 s1 > 127.0.0.101 s2 > 127.0.0.102 s3 > > > Can I start three servers on same port (3306), same socket > (/tmp/mysql.sock) on same machine by using above IP addresses? If > yes then HOW? > > Can I use the replication in b/w them? keeping datadir and log-bin > directory differtent is not a problem. > > Appreciate it. >