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.
> 

Reply via email to