易截截图软件、单文件、免安装、纯绿色、仅160KB

Initial Startup of MySQL Cluster


Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issue the following command from the system shell to start the management node process:
shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini
Note
ndb_mgmd
 
must be told where to find its configuration file, using the 
-f
 
or 
--config-file
 
option. (See 
Section 4.4, “ndb_mgmd
— The MySQL Cluster Management Server Daemon”
, for details.)
For additional options which can be used with 
ndb_mgmd
, seeSection 4.23, “Options Common to MySQL Cluster Programs”
.
On each of the data node hosts, run this command to start the 
ndbd
 
process:
shell> ndbd
If you used RPM files to install MySQL on the cluster host where the SQL node is to reside, you can (and should) use the supplied startup script to start the MySQL server process on the SQL node.
If all has gone well, and the cluster has been set up correctly, the cluster should now be operational. You can test this by invoking the 
ndb_mgm
 
management node client. The output should look like that shown here, although you might see some slight differences in the output depending upon the exact version of MySQL that you are using:
shell> ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.30 (Version: 5.1.41-ndb-6.3.31, Nodegroup: 0, Master)
id=3 @192.168.0.40 (Version: 5.1.41-ndb-6.3.31, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.10 (Version: 5.1.41-ndb-6.3.31)
[mysqld(API)] 1 node(s)
id=4 @192.168.0.20 (Version:


相关文档:

让memcached和mysql更好的工作

 这次是Fotolog
的经验,传说中比Flickr更大的网站
,Fotolog在21台服务
器上部署了51个memcached实例,总计有254G缓存空间
可用,缓存了多达175G的内容,这个数量比很多网站的数据库都要大的多,原文是A Bunch of Great Strategies for Using Memcached and MySQL Better Together
,我这里还是选择性的翻译以及按照 ......

Mysql 错误 1067

启动Mysql 错误 1067 进程意外终止的一种解决方法
mysqld-nt --defaults-file=my.ini --standalone --console
查看信息内容
发现MYSQL INNODB初始化错误。
错误如下:
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100115 10:14:04  InnoDB: Setti ......

vsftp配置验证方式mysql和文件虑拟用户

以下内容在ubuntu 9.04 server系统上测试通过
用apt-get install vsftp安装的时候相关的文件位置:
主配置文件:/etc/vsftpd.conf
验证配置文件/etc/pam.d/vsftpd
重启:/etc/init.d/vsftpd restart
vsftp Mysql验证方式:
MYSQL已经安装在/usr/local/mysql
直接安装vsftp
sudo apt-get install vsftp
安装pam_mys ......

转 MYSQL中的my.ini或my.cnf配置说明

mysqld程序--目录和文件
basedir = path 使用给定目录作为根目录(安装目录)。
character-sets-dir = path 给出存放着字符集的目录。
datadir = path 从给定目录读取数据库文件。
pid-file = filename 为mysqld程序指定一个存放进程ID的文件(仅适用于UNIX/Linux系统); Init-V脚本需要使用这个文件里的进程ID结束mysqld进 ......

MySQL Cluster Multi Computer Configuration


For our four-node, four-host MySQL Cluster, it is necessary to
write four configuration files, one per node host.

Each data node or SQL node requires a
my.cnf
file that provides two pieces of
information: a connectstring
that tells
......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号