List:Cluster« Previous MessageNext Message »
From:Dan Frincu Date:July 26 2010 4:38pm
Subject:Re: Converting MyISAM with 300GB to NDB.
View as plain text  
Try ndb_size.pl script on the 300GB database (it will take some time) to 
get the settings necessary for NDB, however based on the amount of data 
and the limited amount of RAM, unless you seriously upgrade your RAM and 
add several servers in the equation, I don't see how this would be 
achievable with this H/W configuration.

You might want to check out this link 
http://www.fromdual.com/mysql-cluster-memory-sizing

Regards,
Dan.

Ricardo Soares Guimarães wrote:
> Hello,
>
> I have one database with 300Gb of data, and want to try NDB.
>
> That´s possible?
>
> I tried several configurations, and keys, but seems that can´t import 
> such data
>
> My server has (now) 16Gb of RAM, but soon will have 32.
>
> Anyone tried such configuration?
>
> I am using mysql-cluster 7.1.x with 64bits linux server.
>
> Thanks
>

-- 
Dan FRINCU
Systems Engineer
CCNA, RHCE
Streamwide Romania


Thread
Converting MyISAM with 300GB to NDB.Ricardo Soares Guimarães26 Jul
  • Re: Converting MyISAM with 300GB to NDB.Dan Frincu26 Jul
    • Performance and Scalability and clusterJeff - ES Schweiger23 Sep
  • Re: Converting MyISAM with 300GB to NDB.Dan Frincu26 Jul
  • Re: Converting MyISAM with 300GB to NDB.Stewart Smith26 Jul
    • Re: Converting MyISAM with 300GB to NDB.Ricardo Soares Guimarães26 Jul
      • Re: Converting MyISAM with 300GB to NDB.Jason Brooke26 Jul
  • Re: Converting MyISAM with 300GB to NDB.David Ennis26 Jul
    • Re: Converting MyISAM with 300GB to NDB.Ricardo Soares Guimarães27 Jul
  • Re: Performance and Scalability and clusterYves Trudeau23 Sep
    • RE: Performance and Scalability and clusterJeff - ES Schweiger23 Sep
      • Re: Performance and Scalability and clusterAdam Dixon23 Sep
        • RE: Performance and Scalability and clusterAndrew Morgan24 Sep
          • High availability implementationramarovelo28 Sep
            • RE: High availability implementationAndrew Morgan28 Sep
              • Re: High availability implementationMat Keep28 Sep
              • Re: High availability implementationramarovelo28 Sep
      • Re: Performance and Scalability and clusterMikael Ronstrošm24 Sep