4 messages in com.mysql.lists.clusterRe: Questions on TCP Configuration
FromSent OnAttachments
Burnett, Stewart09 Sep 2005 03:42 
Mikael Ronström09 Sep 2005 03:52 
Frank Cases09 Sep 2005 13:24 
Mikael Ronström12 Sep 2005 00:19 
Subject:Re: Questions on TCP Configuration
From:Mikael Ronström (mik@mysql.com)
Date:09/09/2005 03:52:14 AM
List:com.mysql.lists.cluster

Hi Stewart,

There is no support for resiliency of TCP connections provided by MySQL Cluster. There is however lots of solutions on the market that brings resilient solutions of TCP connections using bonding drivers and so forth. This is more or less standard stuff in a not to simple Ethernet driver. As an example I remember that DL 380 had this a standard feature in their Ethernet drivers supplied.

Rgrds Mikael

2005-09-09 kl. 12.42 skrev Burnett, Stewart:

Hi,

Just setting up a simple two node cluster. We have successfully done this before using cross-over cables between the two storage nodes. Can we achieve resilience using two cross-over cables and [TCP] settings like these?

[TCP] NodeId1=3 NodeId2=4 HostName1=1.1.0.1 HostName2=1.1.0.2

[TCP] NodeId1=3 NodeId2=4 HostName1=1.1.0.3 HostName2=1.1.0.4

Also, if each server runs more than one storage node do we need a combination for every possibility. E.g.

Storage Nodes 3,5 on Server1 & 4,6 on Server 2

[TCP] NodeId1=3 NodeId2=4 HostName1=1.1.0.1 HostName2=1.1.0.2

[TCP] NodeId1=3 NodeId2=6 HostName1=1.1.0.1 HostName2=1.1.0.2

[TCP] NodeId1=5 NodeId2=4 HostName1=1.1.0.1 HostName2=1.1.0.2

[TCP] NodeId1=5 NodeId2=6 HostName1=1.1.0.1 HostName2=1.1.0.2

Or can we get away with

[TCP] NodeId1=3 NodeId2=4 HostName1=1.1.0.1 HostName2=1.1.0.2

[TCP] NodeId1=5 NodeId2=6 HostName1=1.1.0.1 HostName2=1.1.0.2

Stewart Burnett

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.

Mikael Ronstrom, Senior Software Architect MySQL AB, www.mysql.com

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html