Situation:
Error when clustering MySQL on AWS EC2 Ubuntu instances.
Error message:
ERROR -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid=<nodeid> on command line
2. Main Reason
It was because of mismatch between Elastic IP of AWS instances and IP in config.ini file.
3. Solution
1) Install MySQL
sudo apt-get install mysql-server
ref: https://help.ubuntu.com/12.04/serverguide/mysql.html2) Write internal IP of each EC2 instances.
You need to check eth0 IP address of the AWS instances and write it on config.ini file. (Using ifconfig)
Then you can use this commend
ndb_mgmd -f /usr/local/mysql/mysql-cluster/config.ini --configdir=/usr/local/mysql/mysql-cluster
댓글 없음:
댓글 쓰기