Bonjour j’essai de mettre en place un mysql-cluster sur debian bon j’utilise 3 vm pour le petit projet
1 manager et les deux autres seront utilisé comme noeud de stockage et noeud sql
je vous montre
configuration
Pour le manager
config.ini
# Options affecting ndbd processes on all data nodes:
[ndbd default]
NoOfReplicas=2 # Number of replicas (This must match the number of data nodes!!!)
DataMemory=256M # How much memory to allocate for data storage
IndexMemory=64M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[tcp default]
#portnumber=2202 # This the default; however, you can use any port that is free
# for all the hosts in the cluster
# Note: It is recommended that you do not specify the port
# number at all and allow the default value to be used instead
# Management process options
[ndb_mgmd]
hostname=192.168.0.10 # Hostname or IP address of management node
datadir=/var/lib/mysql-cluster # Directory for management node log files
# First Data Node (ID=2 because the management node autmatically obtains ID=1)
[ndbd]
Id=2
hostname=192.168.0.11
datadir=/usr/local/mysql/data
# Second Data Node
[ndbd]
Id=3
hostname=192.168.0.12
datadir=/usr/local/mysql/data
# MySQLD Processing Nodes (workhorses) - Defining 4 will allow 4 to join the cluster
[mysqld]
[mysqld]
[mysqld]
[mysqld]configuration des noeuds mysql le fcihier /etc/my.cnf
[mysqld]
ndbcluster
ndb-connectstring='host=192.168.0.10' # IP address of the management server
[mysql_cluster]
ndb-connectstring='host=192.168.0.10' # IP address of the management serverLe manager
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.11 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
id=3 @192.168.0.12 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.10 (mysql-5.1.39 ndb-7.0.9)
[mysqld(API)] 4 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)Mais aucun noeuds sql n’est demarrer si quelqu’un a une idée car là sa fait un bon moment que je cherche mais je trouve pas j’ai vu sur ce site qu’il avait utilisé la commande suivante pour demarrer les noeuds sql
j’ai utilisé la commande suivante
mysqld ou mysqld_safe
Il me sort le message suivant
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
100315 5:03:48 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
100315 5:03:48 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
100315 5:03:50 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
100315 5:03:50 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100315 5:03:50 [ERROR] Aborting
100315 5:03:50 [Note] mysqld: Shutdown complete
Si quelqu’un a une idée merci