MySQL Cluster 安装(五)

[root@mysql3 apps]# /Data/apps/mysql-5.5.12/bin/ndbd
2013-02-26 10:44:57 [ndbd] INFO — Angel connected to ’172.1.2.10:1186′
2013-02-26 10:44:57 [ndbd] INFO — Angel allocated nodeid: 3
[root@mysql3 apps]#

启动SQL节点：

[root@mysql4 /]# /Data/apps/mysql-5.5.12/bin/mysqld_safe &
[1] 28179
[root@mysql4 /]# 130226 10:45:53 mysqld_safe Logging to ‘/Data/apps/mysql-5.5.12/data/mysql4.qyer.com.err’.
130226 10:45:53 mysqld_safe Starting mysqld daemon with databases from /Data/apps/mysql-5.5.12/data

[root@mysql4 /]# ps -ef |grep mysql
root 28179 3274 0 10:45 pts/0 00:00:00 /bin/sh /Data/apps/mysql-5.5.12/bin/mysqld_safe
mysql 28271 28179 2 10:45 pts/0 00:00:00 /Data/apps/mysql-5.5.12/bin/mysqld –basedir=/Data/apps/mysql-5.5.12 –datadir=/Data/apps/mysql-5.5.12/data –plugin-dir=/Data/apps/mysql-5.5.12/lib/plugin –user=mysql –log-error=/Data/apps/mysql-5.5.12/data/mysql4.qyer.com.err –pid-file=/Data/apps/mysql-5.5.12/data/mysql4.qyer.com.pid
root 28284 3274 0 10:46 pts/0 00:00:00 grep mysql
[root@mysql4 /]#

[root@mysql4 support-files]# cat /etc/my.cnf
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M – 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "–help" option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
ndbcluster
ndb-connectstring=172.1.2.10
[mysql_cluster]
ndb-connectstring=172.1.2.10
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
skip-grant-tables
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# Don’t listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format – mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 – 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) –
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=,
# MASTER_USER=, MASTER_PASSWORD= ;
#
# where you replace , , by quoted strings and
# by the master’s port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST=’125.5