Comments on How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

je n'ai jamais réussi a faire fonctionner le cluster avec ce tutorial :

 debian1:/usr/src/mysql-5.1.35# /usr/src/mysql-5.1.35/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/
Installing MySQL system tables...
090721 13:30:36 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-bdb'
090721 13:30:36 [ERROR] Aborting

090721 13:30:36 [Warning] Forcing shutdown of 1 plugins
090721 13:30:36 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

 

les options de mysql ont du changer. Avec la 5.1.35 ca ne marche plus !

Tutoriel intéressant tout de même. Merci

 

Cordialement.

The problem with ndbd not found is due to not setting the PATH enviroment (which is a step in this tutorial). Since PATH may be a problem I have updated the howto with the full path to:

/usr/local/mysql/libexec/ndbd --initial

The error with --skip-bdb is easy to fix just edit /etc/mysql/my.cnf or your my.cnf file in other localisation and put a # before skip-bdb like this:

#skip-bdb. Restart MySQL and it should start without any problems.

Hey,

 So I have folled this through and am stuck with the following block.

mkdir /usr/local/mysql/var/mysql-cluster
mkdir /usr/local/mysql/var/mysql-cluster/backup
cd /var/lib/mysql-cluster
ndbd --initial
/etc/init.d/mysql.server start 

 

The folder /var/lib/mysql-cluster does not exists and the command ndbd is not present in the build.  I am using version 5.1.39.

Is there something different between the two versions?  

I would apprechiate it if someone would come backt o me with an answer on how to complete the build.

 

Regards,

Michael

Michael,

 I am having the exact same problem, I am using version 5.1.50.  Did you every find the solution?  Can anyone please help?

I have no directory called:  /var/lib/mysql-cluster

 Thanks.