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
Ïà¹ØÎĵµ£º
http://inthirties.com:90/thread-918-3-1.html
This article describes the installation of
Oracle 10g release 2 (10.2.0.1) RAC on Linux (Oracle Enterprise Linux
4.5) using NFS to provide the shared storage.
Introduction
Download Software
Operating System Installation
Oracle Installation Prereq ......
· ÄÚ²¿¹¹¼þºÍ¿ÉÒÆÖ²ÐÔ
o ÌṩÁËÊÂÎñÐԺͷÇÊÂÎñÐÔ´æ´¢ÒýÇæ¡£
--ÊÇ·ñÖ¸Èç¹ûÒª²ÉÓÃÊÂÎñ¹ÜÀí£¬±ØÐëÇл»´æ´¢ÒýÇæ£¿£¿£¿
· Óï¾äºÍº¯Êý
DELETE¡¢INSERT¡¢REPLACEºÍUPDATE·µ»Ø¸ü¸Ä£¨Ó°Ï죩µÄÐÐÊý¡£Á¬½Óµ½·þÎñÆ÷ʱ£¬¿Éͨ¹ýÉèÖ ......
query result(14 records)
id
uid
gid
1
11
502
2
107
502
3
100
503
4
110
501
5
112
501
6
104
502
7
100
502
8
100
501
9
102
501
10
104
502
11
100
502
12
100
501
13
102
501
14
110
501
µÚÆßÌõÓëµÚʮһÌõÖØ¸´µÈ
·½·¨Ò»
mysql> create temporary table tmp_wrap ......
mysql version 5.1
ÔÚmysql´´½¨±íµÄʱºò¾³£»áÓöµ½´´½¨ÈÕÆÚ×Ö¶ÎÐèÒªÉèÖõ±Ç°Ê±¼äΪĬÈÏÖµµÄʱºò£¬¾ÍÈçsqlserver2000Ò»Ñù£¬°ÑĬÈÏÖµÉèΪgetdate()¼´¿É£¬ÎÒÔÚÍøÉϲéÁËN¾Ã¶¼Ã»Óв鵽ʹÓÃÓÐЧµÄ·½·¨£¬×îºó×Ô¼ºÑо¿ÁËһЩ·½·¨Óë´ó¼Ò·ÖÏí£º
Êý¾Ý¿â£ºtest_db1
´´½¨±í£ºtest_ta1
Á½¸ö×Ö¶ ......
/ ¸ùĿ¼
/bin ³£ÓõÄÃüÁî binary file µÄÄ¿錄
/boot ´æ·ÅϵͳÆô¶¯Ê±±ØÐë¶ÁÈ¡µÄµµ°¸£¬°üÀ¨ºËÐÄ (kernel) ÔÚÄÚ
/boot/grub/menu.lst GRUB ......