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
Ïà¹ØÎĵµ£º
Õ»Ö÷ÒªÓÃÀ´´æ·Å¾Ö²¿±äÁ¿, ´«µÝ²ÎÊý, ´æ·Åº¯ÊýµÄ·µ»ØµØÖ·.esp ʼÖÕÖ¸ÏòÕ»¶¥, Õ»ÖеÄÊý¾ÝÔ½¶à, espµÄֵԽС.
¶ÑÓÃÓÚ´æ·Å¶¯Ì¬·ÖÅäµÄ¶ÔÏó, µ±ÄãʹÓà malloc , new µÈ½øÐзÖÅäʱ,ËùµÃµ½µÄ¿Õ¼ä¾ÍÔÚ¶ÑÖÐ. ¶¯Ì¬·ÖÅäµÃµ½µÄÄڴ渽´øÓзÖÅäÐÅÏ¢, ËùÒÔÄãÄܹ» realloc ºÍ freeµ÷ËüÃÇ.
È«¾Ö£¬¾²Ì¬ºÍ³£Á¿ÊÇ·ÖÅäÔÚÊý¾ÝÇøÖеġ£Êý¾ÝÇø°üÀ¨b ......
linuxĿ¼¼Ü¹¹
/ ¸ùĿ¼
/bin ³£ÓõÄÃüÁî binary file µÄÄ¿錄
/boot ´æ·ÅϵͳÆô¶¯Ê±±ØÐë¶ÁÈ¡µÄµµ°¸£¬°üÀ¨ºËÐÄ (kernel) ÔÚÄÚ
/boot/grub/menu.lst GRUBÉèÖÃ
/boot/vmlinuz ÄÚºË
......
Linux
ÄÚ´æ¹ÜÀí
ÕªÒª
£º±¾ÕÂÊ×ÏÈÒÔÓ¦ÓóÌÐò¿ª·¢ÕߵĽǶÈÉóÊÓ
Linux
µÄ½ø³ÌÄÚ´æ¹ÜÀí£¬ÔÚ´Ë»ù´¡ÉÏÖð²½ÉîÈëµ½ÄÚºËÖÐÌÖÂÛϵͳÎïÀíÄÚ´æ¹ÜÀíºÍÄÚºËÄÚ´æµÄʹÓ÷½·¨¡£Á¦Çó´ÓÍâµ½ÄÚ¡¢Ë®µ½Çþ³ÉµØÒýµ¼ÍøÓÑ·ÖÎö
Linux
µÄÄÚ´æ¹ÜÀíÓëʹÓá£ÔÚ±¾ÕÂ×îºó£¬ÎÒÃǸø³öÒ»¸öÄÚ´æÓ³ÉäµÄʵÀý£¬°ïÖúÍøÓÑÃÇÀí½â
ÄÚºËÄÚ´æ¹ÜÀíÓëÓû§ÄÚ´æ¹ÜÀíÖ ......
/ ¸ùĿ¼
/bin ³£ÓõÄÃüÁî binary file µÄÄ¿錄
/boot ´æ·ÅϵͳÆô¶¯Ê±±ØÐë¶ÁÈ¡µÄµµ°¸£¬°üÀ¨ºËÐÄ (kernel) ÔÚÄÚ
/boot/grub/menu.lst GRUB ......