虚拟机Ubuntu 9.04下MySQL集群的配置方法(二)

2014-11-24 17:39:06 · 作者: · 浏览: 1
process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI “tinyca”.
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem


ndbcluster
ndb-connectstring=192.168.245.13


[mysqldump]
quick
quote-names
max_allowed_packet = 16M


[mysql]
#no-auto-rehash # faster start of mysql but no tab completition


[isamchk]
key_buffer = 16M


#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
[MYSQL_CLUSTER]


ndb-connectstring=192.168.245.13


#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with ‘.cnf’, otherwise they’ll be ignored.
#
!includedir /etc/mysql/conf.d/


ubuntu@ubuntu:~$
———————————my.cnf结束———————————————————


主要在:[mysqld]下添加:


ndbcluster
ndb-connectstring=192.168.245.13
和添加
[MYSQL_CLUSTER]


ndb-connectstring=192.168.245.13


上面三台服务器都要一样