List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 19 2012 11:20am
Subject:Re: One inst has 39 columns- the other 40
View as plain text  
----- Original Message -----
> From: "Charles Brown" <CBrown@stripped>
> 
> I have two mysql instances in my mysql cluster. I noticed that their
> MysSQL.user tables do not have the same number of columns. Their
> USER table attributes are not the same. One instance has 39 columns
> while the other has 42 columns. Can someone please help me here.
> Could it be because I'm running mysql cluster? Can someone help me.

I take it you are indeed talking about NDB cluster ?

The MySQL instances in your NDB cluster are really just SQL-to-NDB translator, so running
NDB has nothing to do with the layout of your mysql.* table structure.

The most likely cause is simply different versions of MySQL on the nodes, followed by not
having run the mysql_upgrade script after you upgraded the software.

It's not a /major/ problem, really, but it is good to have the correct layout so you can
assing all the available privileges. See "man mysql_upgrade" for more information.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
date comparison querySimon Wilkinson16 Mar
  • Re: date comparison queryBaron Schwartz16 Mar
  • Re: date comparison queryhsv17 Mar
    • One inst has 39 columns- the other 40Charles Brown18 Mar
      • Re: One inst has 39 columns- the other 40Johan De Meersman19 Mar
  • One inst has 39 columns- the other 40Charles Brown19 Mar
  • RE: One inst has 39 columns- the other 40Charles Brown21 Mar
    • Re: One inst has 39 columns- the other 40Johan De Meersman21 Mar
      • Re: One inst has 39 columns- the other 40Rik Wasmus21 Mar
        • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Nuno Tavares22 Mar
            • Re: One inst has 39 columns- the other 40Michael Dykman22 Mar
          • Re: One inst has 39 columns- the other 40Reindl Harald22 Mar
            • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Mark Goodge22 Mar
    • Re: One inst has 39 columns- the other 40Reindl Harald21 Mar
      • tables do not have the same number of columns. Charles Brown22 Mar
        • Re: tables do not have the same number of columns.Johan De Meersman22 Mar