Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

mysql source µ¼Èëµ¼³öÊý¾ÝΪÂÒÂë

Ò»¡¢µ¼ÈëÊý¾Ý
1¡¢È·¶¨
Êý¾Ý¿âĬÈϱàÂ룬±ÈÈç±àÂë
Ϊgbk,½«¶ÁÈë;¾¶±àÂëͬÑùÉèΪgbk£¬ÃüÁîΪ£º
           set names gbk;
2¡¢source
d:/20080613.sql µ¼ÈëÊý¾Ý¡£ÑéÖ¤
Êý¾Ý¿â
ÖеÄÊý¾ÝÊÇ·ñ´æÔÚÂÒÂë¡£
3¡¢Èç¹ûÈÔÈ»´æÔÚÂÒÂëÎÊÌ⣬Õâʱºò¾ÍÒª¿¼ÂǸı䵼ÈëÎļþµÄ±à ......

mysqlÖÐÈ¥³ýÖØ¸´Ï±£ÁôÒ»Ìì

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 ´´½¨±íʱ ÈÕÆÚ×Ö¶ÎĬÈÏֵΪµ±Ç°Ê±¼ä

    mysql version 5.1
    ÔÚmysql´´½¨±íµÄʱºò¾­³£»áÓöµ½´´½¨ÈÕÆÚ×Ö¶ÎÐèÒªÉèÖõ±Ç°Ê±¼äΪĬÈÏÖµµÄʱºò£¬¾ÍÈçsqlserver2000Ò»Ñù£¬°ÑĬÈÏÖµÉèΪgetdate()¼´¿É£¬ÎÒÔÚÍøÉϲéÁËN¾Ã¶¼Ã»Óв鵽ʹÓÃÓÐЧµÄ·½·¨£¬×îºó×Ô¼ºÑо¿ÁËһЩ·½·¨Óë´ó¼Ò·ÖÏí£º
Êý¾Ý¿â£ºtest_db1
´´½¨±í£ºtest_ta1
Á½¸ö×Ö¶ ......

ARM Linux Boot Sequence

contact me go -> xuqiang.docs@hotmail.com
ARM Linux Boot Sequence
The following traces the Linux boot sequence for ARM-based systems in the 2.6.18 kernel. It looks at just the earliest stages of the boot process, until the generic non-processor-specific start_kernel function is called. The line ......

Àí½âlinux trÃüÁî

1. tr ÃüÁîµÄ¹¦ÄÜ
trÃüÃûÊǼò»¯Á˵ÄsedÃüÁî¡£ÆäÖ÷ÒªµÄ¹¦ÄܰüÀ¨£º
a. ÓÃÒ»¸ö×Ö·ûÀ´Ìæ»»ÁíÍâÒ»¸ö×Ö·û¡£
b. ɾ³ý×Ö·û´®ÖеÄÖ¸¶¨×Ó´®¡£
c. ºÏ²¢×Ö·û´®ÖÐÖØ¸´´®¡£
2. ³£¼ûµÄÃüÁî¸ñʽ£º
tr -c -d -s ["string1_to_translate_from"] ["string2_to_translate_to"] < input-file
-c ÓÃ×Ö·û´®1ÖÐ×Ö·û¼¯µÄ²¹¼¯Ìæ»»´Ë×Ö·û¼¯£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ