MySQL Forums
Forum List  »  NDB clusters

Re: IP address changes in a cluster ?
Posted by: Jörg Nowak
Date: April 12, 2005 03:20AM

Again me.

To restate my point: Whether cluster mgm node can accept a change in IP address or not (after changing the config.ini) ?

Before changing the IP addresses:

[COMPUTER DEFAULT]

[DB DEFAULT]
NoOfReplicas: 2
DataMemory: 1G
IndexMemory: 500M
Diskless: 0
#0 means Data is written to the disk. 1 means that data is handled in memory itself.
StopOnError: 0
MaxNoOfConcurrentOperations: 260000
TransactionBufferMemory: 5000

[API DEFAULT]

[MGM DEFAULT]
ArbitrationRank: 2

[TCP DEFAULT]
PortNumber: 38004
SendBufferMemory: 16384
ReceiveBufferMemory: 10240000

#[TCP]
#NodeId1: 2
#NodeId2: 4
#PortNumber: 28002
#SendBufferMemory: 256000
#ReceiveBufferMemory: 256000

[COMPUTER]
Id: 1
HostName: 10.1.2.26

[COMPUTER]
Id: 2
HostName: 10.1.2.25

[COMPUTER]
Id: 3
HostName: 10.1.2.62

[MGM]
Id: 1
ExecuteOnComputer: 3
PortNumber: 1801

[DB]
Id: 2
ExecuteOnComputer: 1
FileSystemPath: /var/lib/mysql-cluster/node2/
#LockPagesInMainMemory: 1

[DB]
Id: 3
ExecuteOnComputer: 2
FileSystemPath: /var/lib/mysql-cluster/node3/
#LockPagesInMainMemory: 1

[DB]
Id: 4
ExecuteOnComputer: 1
FileSystemPath: /var/lib/mysql-cluster/node4/
#LockPagesInMainMemory: 1

[DB]
Id: 5
ExecuteOnComputer: 2
FileSystemPath: /var/lib/mysql-cluster/node5/
#LockPagesInMainMemory: 1

[API]
Id: 6
ExecuteOnComputer: 1

[API]
Id: 7
ExecuteOnComputer: 2

---------------------------------------------------------------------------------

After changing the IP addresses:

[COMPUTER DEFAULT]

[DB DEFAULT]
NoOfReplicas: 2
DataMemory: 1G
IndexMemory: 500M
Diskless: 0
#0 means Data is written to the disk. 1 means that data is handled in memory itself.
StopOnError: 0
MaxNoOfConcurrentOperations: 260000
TransactionBufferMemory: 5000

[API DEFAULT]

[MGM DEFAULT]
ArbitrationRank: 2

[TCP DEFAULT]
PortNumber: 38004
SendBufferMemory: 16384
ReceiveBufferMemory: 10240000

#[TCP]
#NodeId1: 2
#NodeId2: 4
#PortNumber: 28002
#SendBufferMemory: 256000
#ReceiveBufferMemory: 256000

[COMPUTER]
Id: 1
HostName: 10.1.2.29

[COMPUTER]
Id: 2
HostName: 10.1.2.24

[COMPUTER]
Id: 3
HostName: 10.1.2.62

[MGM]
Id: 1
ExecuteOnComputer: 3
PortNumber: 1801

[DB]
Id: 2
ExecuteOnComputer: 1
FileSystemPath: /var/lib/mysql-cluster/node2/
#LockPagesInMainMemory: 1

[DB]
Id: 3
ExecuteOnComputer: 2
FileSystemPath: /var/lib/mysql-cluster/node3/
#LockPagesInMainMemory: 1

[DB]
Id: 4
ExecuteOnComputer: 1
FileSystemPath: /var/lib/mysql-cluster/node4/
#LockPagesInMainMemory: 1

[DB]
Id: 5
ExecuteOnComputer: 2
FileSystemPath: /var/lib/mysql-cluster/node5/
#LockPagesInMainMemory: 1

[API]
Id: 6
ExecuteOnComputer: 1

[API]
Id: 7
ExecuteOnComputer: 2

Joerg Nowak

Options: ReplyQuote


Subject
Views
Written By
Posted
3066
April 07, 2005 06:02AM
Re: IP address changes in a cluster ?
3031
April 12, 2005 03:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.