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

Linux 下MySQL NDB配置

A) Shutdown management node and data node
devmysql3# ndb_mgm -e shutdown
devmysql4# ndb_mgm -e shutdown
B) Shutdown MySQL proccess
devmysql3# mysqladmin shutdown
devmysql4# mysqladmin shutdown
devmysql3 ip: 10.130.30.217
devmysql4 ip: 10.130.30.218
rpm -ivh MySQL-Cluster-gpl-storage-6.3.20-0.rhel5.x86_64.rpm
rpm -ivh MySQL-Cluster-gpl-tools-6.3.20-0.rhel5.x86_64.rpm
rpm -ivh MySQL-Cluster-gpl-shared-6.3.20-0.rhel5.x86_64.rpm
rpm -ivh MySQL-Cluster-gpl-devel-6.3.20-0.rhel5.x86_64.rpm
rpm -ivh MySQL-Cluster-gpl-server-6.3.20-0.rhel5.x86_64.rpm
rpm -ivh MySQL-Cluster-gpl-client-6.3.20-0.rhel5.x86_64.rpm
rpm -ivh MySQL-Cluster-gpl-management-6.3.20-0.rhel5.x86_64.rpm
rpm -ivh MySQL-Cluster-gpl-extra-6.3.20-0.rhel5.x86_64.rpm
2.Configure MySQL Cluster
mkdir /var/lib/mysql-cluster
cd /var/lib/mysql-cluster
vi config.ini
[ndbd default]
NoOfReplicas = 2
MaxNoOfConcurrentOperations = 2000000
DataMemory = 3000M
IndexMemory = 500M
TimeBetweenWatchDogCheck = 30000
DataDir = /var/lib/mysql-cluster
MaxNoOfOrderedIndexes = 512
StartPartialTimeout = 205
StartPartitionedTimeout = 205
ArbitrationTimeout = 5000
TransactionDeadlockDetectionTimeout = 15000
HeartbeatIntervalDbDb = 5000
StopOnError = 0
TimeBetweenLocalCheckpoints = 15
NoOfFragmentLogFiles = 300

[ndb_mgmd default]
DataDir = /var/lib/mysql-cluster

[ndb_mgmd]
Id = 1
HostName = 10.130.30.217

[ndb_mgmd]
Id = 2
HostName = 10.130.30.218

[ndbd]
Id = 3
HostName = 10.130.30.217

[ndbd]
Id = 4
HostName = 10.130.30.218

[mysqld]
HostName = 10.130.30.217

ArbitrationRank = 2

[mysqld]
HostName = 10.130.30.218
ArbitrationRank = 2

[tcp default]
PortNumber = 63132

vi /etc/my.cnf
[mysqld]
max_connections = 500
default-character-set = utf8
default-storage-engine = ndbcluster
ndbcluster
ndb-connectstring = 10.130.30.217,10.130.30.218

[client]
default-character-set = utf8

[ndbd]
connect-s


相关文档:

转载 写得蛮好的linux学习笔记

linux目录架构
/   根目录
/bin    常用的命令 binary file 的目錄
/boot   存放系统启动时必须读取的档案,包括核心 (kernel) 在内
     /boot/grub/menu.lst   GRUB设置
     /boot/vmlinuz   内核
   ......

Linux常用挂载点和目录

/bin                      存放最常用的命令,所有用户都有执行权限
/boot                    系统引导目 ......

linux学习

星际译王的安装


                “星际译王”是用Gtk2开发的跨平台的国际化的词典软件。它具有“通配符匹配”、“选中区取词”、“模糊查询”等强大功能。本文主要解说一下主程序和词库的安装;
一、什么 ......

linux权限与文件系统安全

权限与文件系统安全
1,“ls -l”命令输出结果中各字段含义:
(1),文件类型,第1位(“-”普通文件、“d”目录文件、“l”符号链接文件、“b”快设备文件、“c”字符设备文件、“p”管道文件、“s”socket文件)
(2),权限,第2至10位( ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号