List:Cluster« Previous MessageNext Message »
From:Subodh Nair Date:March 31 2010 12:35pm
Subject:RE: MySQL cluster- migrating from WIndows to Linux
View as plain text  
Hello Andrew,


Thanks for the link. Yes, I was able to download the mysql-5.1.34 cluster
7.0.6 64 bit version for Linux and install it. This time I replaced a
windows data node with this version of Linux data node and found that it was
able to join the cluster and synchronization between the data nodes was
complete. I was able to access data, insert data into the cluster. After
that I installed a second Linux data node and after shutting down the second
windows data node try to introduce the 2nd Linux data node into the cluster.
This time however, even though it was able to connect to the management
node, the synchronization between the two data nodes did not occur. The show
command showed the second Linux data node status as starting.
Is it possible that it was not able to communicate with the first Linux data
node?

The ndb_cluster_log (Truncated)I n the management node looked like this:
(node3 is the Linux data node that had successfully joined the cluster. Node
id 2 is the second linux data node that I am trying to introduce into the
cluster)
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:::::::::::::::::::::::::::::

2010-03-31 08:52:34 [MgmSrvr] INFO     -- Node 2: Local checkpoint 8767
started. Keep GCI = 199045 oldest restorable GCI = 199060
2010-03-31 08:53:25 [MgmSrvr] INFO     -- Node 2: Local checkpoint 8768
started. Keep GCI = 199062 oldest restorable GCI = 199078
2010-03-31 08:54:17 [MgmSrvr] INFO     -- Node 2: Local checkpoint 8769
started. Keep GCI = 199079 oldest restorable GCI = 199091
2010-03-31 08:55:09 [MgmSrvr] INFO     -- Node 2: Local checkpoint 8770
started. Keep GCI = 199096 oldest restorable GCI = 199111
2010-03-31 08:56:01 [MgmSrvr] INFO     -- Node 2: Local checkpoint 8771
started. Keep GCI = 199113 oldest restorable GCI = 199119
2010-03-31 08:56:53 [MgmSrvr] INFO     -- Node 2: Local checkpoint 8772
started. Keep GCI = 199130 oldest restorable GCI = 199138
2010-03-31 08:56:53 [MgmSrvr] ALERT    -- Node 3: Node 2 Disconnected
2010-03-31 08:56:53 [MgmSrvr] INFO     -- Node 3: Communication to Node 2
closed
2010-03-31 08:56:53 [MgmSrvr] ALERT    -- Node 3: Network partitioning -
arbitration required
2010-03-31 08:56:53 [MgmSrvr] INFO     -- Node 3: President restarts
arbitration thread [state=7]
2010-03-31 08:56:53 [MgmSrvr] ALERT    -- Node 1: Node 2 Disconnected
2010-03-31 08:56:53 [MgmSrvr] ALERT    -- Node 3: Arbitration won - positive
reply from node 1
2010-03-31 08:56:53 [MgmSrvr] INFO     -- Node 3: GCP Take over started
2010-03-31 08:56:53 [MgmSrvr] INFO     -- Node 3: Node 3 taking over as DICT
master
2010-03-31 08:56:53 [MgmSrvr] INFO     -- Node 3: GCP Take over completed
2010-03-31 08:56:53 [MgmSrvr] INFO     -- Node 3: kk: 199148/5 0 0
2010-03-31 08:56:53 [MgmSrvr] ALERT    -- Node 1: Node 2 Disconnected
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: LCP Take over started
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: ParticipatingDIH =
0000000000000008
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: ParticipatingLQH =
0000000000000008
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3:
m_LCP_COMPLETE_REP_Counter_DIH = [SignalCounter: m_count=0 0000000000000000]
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3:
m_LCP_COMPLETE_REP_Counter_LQH = [SignalCounter: m_count=1 0000000000000008]
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: m_LAST_LCP_FRAG_ORD =
[SignalCounter: m_count=1 0000000000000008]
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3:
m_LCP_COMPLETE_REP_From_Master_Received = 0
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: LCP Take over completed
(state = 5)
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: ParticipatingDIH =
0000000000000008
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: ParticipatingLQH =
0000000000000008
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3:
m_LCP_COMPLETE_REP_Counter_DIH = [SignalCounter: m_count=1 0000000000000008]
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3:
m_LCP_COMPLETE_REP_Counter_LQH = [SignalCounter: m_count=1 0000000000000008]
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: m_LAST_LCP_FRAG_ORD =
[SignalCounter: m_count=1 0000000000000008]
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3:
m_LCP_COMPLETE_REP_From_Master_Received = 0
2010-03-31 08:56:54 [MgmSrvr] INFO     -- Node 3: Started arbitrator node 1
[ticket=306e00060a8a5381]
2010-03-31 08:56:57 [MgmSrvr] INFO     -- Node 3: Communication to Node 2
opened
2010-03-31 08:57:24 [MgmSrvr] INFO     -- Node 3: Data usage is 5(8857 32K
pages of total 163840)
2010-03-31 08:57:24 [MgmSrvr] INFO     -- Node 3: Index usage is 4(2975 8K
pages of total 65568)
2010-03-31 08:57:24 [MgmSrvr] INFO     -- Node 3: Resource 0 min: 155111
max: 164607 curr: 8857
2010-03-31 08:57:24 [MgmSrvr] INFO     -- Node 3: Resource 3 min: 163840
max: 163840 curr: 8857
2010-03-31 08:57:24 [MgmSrvr] INFO     -- Node 3: Resource 5 min: 128 max:
128 curr: 0
2010-03-31 08:57:43 [MgmSrvr] INFO     -- Node 3: Local checkpoint 8773
started. Keep GCI = 199147 oldest restorable GCI = 199159
2010-03-31 08:58:31 [MgmSrvr] INFO     -- Node 3: Local checkpoint 8774
started. Keep GCI = 199164 oldest restorable GCI = 199179
2010-03-31 08:59:20 [MgmSrvr] INFO     -- Node 3: Local checkpoint 8775
started. Keep GCI = 199180 oldest restorable GCI = 199190
2010-03-31 09:34:29 [MgmSrvr] INFO     -- Node 3: Local checkpoint 8818
started. Keep GCI = 199870 oldest restorable GCI = 199885
2010-03-31 13:05:32 [MgmSrvr] INFO     -- Node 3: Local checkpoint 9076
started. Keep GCI = 204012 oldest restorable GCI = 204027
2010-03-31 13:06:20 [MgmSrvr] INFO     -- Node 3: Local checkpoint 9077
started. Keep GCI = 204028 oldest restorable GCI = 204038
2010-03-31 13:06:38 [MgmSrvr] INFO     -- Got initial configuration from
'C:\MySQL\config.ini', will try to set it when all ndb_mgmd(s) started
2010-03-31 13:06:38 [MgmSrvr] INFO     -- Mgmt server state: nodeid 1
reserved for ip 10.90.90.35, m_reserved_nodes
0000000000000000000000000000000000000000000000000000000000000002.
2010-03-31 13:06:38 [MgmSrvr] INFO     -- Node 1: Node 1 Connected
2010-03-31 13:06:38 [MgmSrvr] INFO     -- Id: 1, Command port: *:1186
2010-03-31 13:06:38 [MgmSrvr] INFO     -- Starting initial configuration
change
2010-03-31 13:06:38 [MgmSrvr] INFO     -- Configuration 1 commited
2010-03-31 13:06:38 [MgmSrvr] INFO     -- Config change completed! New
generation: 1
2010-03-31 13:06:41 [MgmSrvr] INFO     -- Node 1: Node 3 Connected
2010-03-31 13:06:42 [MgmSrvr] INFO     -- Node 3: Started arbitrator node 1
[ticket=306e00080b6eedd7]
2010-03-31 13:07:09 [MgmSrvr] INFO     -- Node 3: Local checkpoint 9078
started. Keep GCI = 204044 oldest restorable GCI = 204058
2010-03-31 13:07:58 [MgmSrvr] INFO     -- Node 3: Local checkpoint 9079
started. Keep GCI = 204060 oldest restorable GCI = 204066
2010-03-31 13:08:34 [MgmSrvr] INFO     -- Mgmt server state: nodeid 2
reserved for ip 10.90.90.28, m_reserved_nodes
0000000000000000000000000000000000000000000000000000000000000006.
2010-03-31 13:08:36 [MgmSrvr] INFO     -- Node 1: Node 2 Connected
2010-03-31 13:08:37 [MgmSrvr] INFO     -- Mgmt server state: nodeid 2 freed,
m_reserved_nodes
0000000000000000000000000000000000000000000000000000000000000002.
2010-03-31 13:08:43 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:08:46 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:08:47 [MgmSrvr] INFO     -- Node 3: Local checkpoint 9080
started. Keep GCI = 204076 oldest restorable GCI = 204085
2010-03-31 13:13:07 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:13:46 [MgmSrvr] INFO     -- Node 2: Initial start, 
2010-03-31 13:17:28 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:17:31 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:30:25 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:30:28 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:30:31 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:30:34 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]
2010-03-31 13:37:25 [MgmSrvr] INFO     -- Node 3: Local checkpoint 9115
started. Keep GCI = 204638 oldest restorable GCI = 204653
2010-03-31 13:37:26 [MgmSrvr] INFO     -- Node 2: Initial start, waiting for
0000000000000008 to connect,  nodes [ all: 000000000000000c connected:
0000000000000004 no-wait: 0000000000000000 ]

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:::::::::::::::::::::::::::::::::::::::::
The ndb_2_out.log on data node 2


::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:::::::::::::::::::::::::::::::::::::::::::
2010-03-31 13:28:59 [ndbd] INFO     -- Angel pid: 6489 ndb pid: 6490

NDBMT: non-mt

2010-03-31 13:28:59 [ndbd] INFO     -- NDB Cluster -- DB node 2

2010-03-31 13:28:59 [ndbd] INFO     -- mysql-5.1.34 ndb-7.0.6 --

2010-03-31 13:28:59 [ndbd] INFO     -- Ndbd_mem_manager::init(1) min: 5124Mb

initial: 5144Mb
Adding 5144Mb to ZONE_LO (1,164607)

2010-03-31 13:29:00 [ndbd] INFO     -- Start initiated (mysql-5.1.34
ndb-7.0.6)

WOPool::init(61, 9)

RWPool::init(22, 13)

RWPool::init(42, 18)

RWPool::init(62, 13)

Using 1 fragments per node

RWPool::init(c2, 18)

RWPool::init(e2, 16)

WOPool::init(41, 8)
RWPool::init(82, 12)
RWPool::init(a2, 52)

WOPool::init(21, 10)

2010-03-31 13:42:09 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in:
Polling for Receive elapsed=99

2010-03-31 13:42:09 [ndbd] INFO     -- Watchdog: User time: 1152  System
time: 3197

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
::::::::::::::::::::::::::::::::::::::::::::

Best Regards,

Subodh









-----Original Message-----
From: Andrew Morgan [mailto:andrew.morgan@stripped] 
Sent: Monday, March 29, 2010 3:46 PM
To: Subodh Nair; Stewart Smith; Matt.Montgomery@stripped;
cluster@stripped
Subject: RE: MySQL cluster- migrating from WIndows to Linux

Hi Subodh,

 Have you tried here....
http://downloads.mysql.com/archives.php?p=mysql-cluster-gpl-7.0&v=7.0.6 ?

Regards, Andrew.

> -----Original Message-----
> From: Subodh Nair [mailto:subodhnair@stripped]
> Sent: 29 March 2010 11:05
> To: Stewart Smith; Matt.Montgomery@stripped; cluster@stripped
> Subject: RE: MySQL cluster- migrating from WIndows to Linux
> 
> Yes unfortunately I only have that version of the Linux RPM packages.
> Where
> can I find mysql-5.1.34 cluster 7.0.6 64 bit of Linux rpm packages?
> I checked the mysql download site but could not find them
> 
> Best Regards,
> 
> Subodh
> 
> -----Original Message-----
> From: Stewart Smith [mailto:stewart@stripped]
> Sent: Monday, March 29, 2010 3:28 PM
> To: Subodh Nair; Matt.Montgomery@stripped; cluster@stripped
> Cc: 'Subodh Nair'
> Subject: RE: MySQL cluster- migrating from WIndows to Linux
> 
> On Mon, 29 Mar 2010 14:39:23 +0530, "Subodh Nair"
> <subodhnair@stripped> wrote:
> 
> > 2010-03-29 07:59:53 [MgmSrvr] INFO     -- Node 2: Node 3: API mysql-
> 5.1.32
> > ndb-7.0.5
> > 2010-03-29 07:59:53 [MgmSrvr] INFO     -- Node 3: CM_REGCONF
> president =
> 2,
> > own Node = 3, our dynamic id = 3
> > 2010-03-29 07:59:53 [MgmSrvr] INFO     -- Node 3: Node 2: API mysql-
> 5.1.34
> > ndb-7.0.6
> 
> This shows two different versions.. this is probably not what you want
> and is much more likely to cause problems.
> 
> --
> Stewart Smith
> 
> 
> 
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
> 

Thread
[Fwd: RE: MySQL cluster- migrating from WIndows to Linux]Matthew Montgomery25 Mar
  • RE: MySQL cluster- migrating from WIndows to LinuxMatthew Montgomery25 Mar
    • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
      • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
        • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
          • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
            • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
              • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
                • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair24 Jun
                  • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen24 Jun
                    • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair25 Jun
  • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair29 Mar
    • RE: MySQL cluster- migrating from WIndows to LinuxStewart Smith29 Mar
      • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair29 Mar
        • RE: MySQL cluster- migrating from WIndows to LinuxAndrew Morgan29 Mar
          • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair31 Mar
            • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen31 Mar
              • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair31 Mar