Riccardo Roasio wrote: > Hi, > anyone has installed BASE using Mysql Cluster? > I tryed but base make an error due to the non local instal... > Thanks,Riccardo
Since MySQL Cluster stores the entire database in memory, you would need an astronomical amount of RAM for this to work. If you have few arrays and experiments you might only need a few tens of gigabytes, but in our case the database is already almost 500 GB. Only storing some of the data (e.g., the 'base' database) in cluster tables wouldn't be very useful, since you need to access the rest of the data from all machines with proper locking. I suppose this could be done via NFS with external-locking enabled in mysqld, but I doubt that it would help much. Unless, possibly, if you split the data for the experiments over several NFS servers and make sure that users access the server where the data they're currently working on is stored. Heck, in that case it might even be possible to add some smart choosing of mysql server to BASE itself, so that the dynamic parts ofdifferent experiments really live on different servers. I wouldn't try such a solution unless all other options were exhausted, though, and I can't imagine how big a BASE installation must be for it to be needed. //Carl -- Carl Troein - [EMAIL PROTECTED] http://www.thep.lu.se/~carl/ ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
