Bizarre love triangle !
On Wed, Oct 28, 2009 at 11:26 PM, Richard McCluskey <rmccluskey@stripped>wrote:
> Thanks Andrew, I'll try that next ...
>
> Sent from my iPhone
>
>
> On Oct 28, 2009, at 6:12 PM, "Andrew Morgan" <Andrew.Morgan@stripped>
> wrote:
>
> Hi Richard,
>>
>> It may not be the root cause of your current problem but you should
>> replace
>> "ndbcluster=true" with just "ndbcluster" as there is a change in the MySQL
>> Server code that would prevent your mysqld from starting from at least
>> 7.0.8a.
>>
>> Regards, Andrew.
>>
>> -----Original Message-----
>>> From: Richard McCluskey [mailto:rmccluskey@stripped]
>>> Sent: 28 October 2009 18:34
>>> To: Andrew Morgan
>>> Cc: 'cluster'
>>> Subject: RE: Bizzare unlogged behaviour
>>>
>>> On Wed, 2009-10-28 at 17:57 +0000, Andrew Morgan wrote:
>>>
>>>> Hi Richard,
>>>>
>>>> What does your my.cnf look like?
>>>>
>>>> Hi Andrew,
>>>
>>> my.cnf as follows :
>>>
>>> [root@test-vsql1 mysql]# cat /etc/my.cnf
>>> # Options for mysqld process:
>>> [mysqld]
>>> ndbcluster=true
>>> ndb-connectstring="nodeid=4,10.6.1.70" # location of management server
>>> datadir=/var/lib/mysql
>>> socket=/var/lib/mysql/mysql.sock
>>> user=mysql
>>> ndb-use-exact-count=0
>>> ndb-index-stat-enable=0
>>> ndb-force-send=1
>>> engine-condition-pushdown=1
>>> server-id=4
>>>
>>>
>>> Richard
>>>
>>> Andrew.
>>>>
>>>> -----Original Message-----
>>>>> From: Richard McCluskey [mailto:rmccluskey@stripped]
>>>>> Sent: 28 October 2009 17:52
>>>>> To: cluster
>>>>> Subject: Bizzare unlogged behaviour
>>>>>
>>>>> Hi,
>>>>>
>>>>> When starting mycluster, my two data nodes start up great, syn and
>>>>> become available. This is good.
>>>>> However, when I start the first SQL/API node, it seems to be
>>>>>
>>>> switching
>>>
>>>> itself on and off and on and off.
>>>>> For example, when running ndb_mgm -e'show' I will see this :
>>>>>
>>>>> ndb_mgm> show
>>>>> Cluster Configuration
>>>>> ---------------------
>>>>> [ndbd(NDB)] 2 node(s)
>>>>> id=2 @10.6.1.72 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0, Master)
>>>>> id=3 @10.6.1.73 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0)
>>>>>
>>>>> [ndb_mgmd(MGM)] 1 node(s)
>>>>> id=1 @10.6.1.70 (mysql-5.1.35 ndb-7.0.7)
>>>>>
>>>>> [mysqld(API)] 4 node(s)
>>>>> id=4 @10.6.1.74 (mysql-5.1.35 ndb-7.0.7)
>>>>> id=5 (not connected, accepting connect from 10.6.1.75)
>>>>>
>>>>> If I then do it again immediately, I will see this :
>>>>> ndb_mgm> show
>>>>> Cluster Configuration
>>>>> ---------------------
>>>>> [ndbd(NDB)] 2 node(s)
>>>>> id=2 @10.6.1.72 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0, Master)
>>>>> id=3 @10.6.1.73 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0)
>>>>>
>>>>> [ndb_mgmd(MGM)] 1 node(s)
>>>>> id=1 @10.6.1.70 (mysql-5.1.35 ndb-7.0.7)
>>>>>
>>>>> [mysqld(API)] 4 node(s)
>>>>> id=4 (not connected, accepting connect from 10.6.1.74)
>>>>> id=5 (not connected, accepting connect from 10.6.1.75)
>>>>>
>>>>> .. adn for each 'show' it will shopw connected, then not connected,
>>>>> then
>>>>> connected etc ...
>>>>>
>>>>> any ideas why ?
>>>>>
>>>>> thanks again :)
>>>>>
>>>>> Richard'
>>>>>
>>>>>
>>>>>
>>>>> Richard McCluskey
>>>>> Senior Engineer,
>>>>> go2 Media Inc.
>>>>> rmccluskey@stripped
>>>>> (617) 457-7870 ext 108
>>>>>
>>>>> http://go2.com - The best entertainment guide on mobile.
>>>>>
>>>>> --
>>>>> MySQL Cluster Mailing List
>>>>> For list archives: http://lists.mysql.com/cluster
>>>>> To unsubscribe:
>>>>> http://lists.mysql.com/cluster?unsub=1
>>>>>
>>>>
>>>>
>>>>
>>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
>
>
