Mysql Cluster编译安装(5.1.34).doc

Mysql Cluster 的配置 1 :环境 M ysql-( 编译安装)L inux: 管理节点( 1个): SQL 节点( 2个): 数据节点( 2个): datadir=/db/mysql datadir=/db/mysql 2 :初始化安装 L inux 安装选:开发工具包等 M ysql 安装#groupadd mysql #useradd -g mysql mysql #tar zxvf mysql- #cd mysql- #./configure --prefix=/usr/local/mysql --localstatedir=/db/mysql --sysconfdir=/etc --without-debug --enable-assembler --enable-thread-safe-client --enable-profiling --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=utf8,gbk --with-pthread – with -plugins=ndbcluster --with-mysqld-user=mysql --without-embedded-server --with-unix-socket-path=/usr/local/mysql/sock/ # make && make install # cp support-files/my-f /etc/f //f 高性能模板#vi /etc/f 添加如下值 datadir = /db/mysql skip-name-resolv table-cache = 4096 #mkdir -p /db/mysql #chown /db/mysql -R #./scripts/mysql_install_db --user=mysql #cp ./support-files/ /etc//mysqld #chmod +x /etc//mysqld #chkconfig --level 235 mysqld on #chown -R /usr/local/mysql // 设置环境变量在/etc/profile 添加一行就,在运行 mysql 的时候就不用输入很长的路经了 export PATH=$PATH:/usr/local/mysql/bin #service mysqld start #mysqladmin -u root password YourPASSWD 3: Mysql Cluster 的配置前提: mysql 在编译安装的时候一定要加参数– with -plug