MySQL¼¯Èº
1£¬½«6.0°æ±¾µÄmysql¼¯ÈºÈí¼þÉÏ´«µ½Linux»òÊÇSolarisÉÏ£¬½âѹ
1>£¬ÎªÁË·½±ãµ÷Óý«Æä¸ÄÃûΪmysql£¬²¢ÇÒ·ÅÓÚ/usr/local/ÏÂ
2>£¬´´½¨Á¬½ÓÎļþ£¬½øÈë/usr/local/ÏÂ
ln -s ..../mysql mysql
2£¬´´½¨×飬Ìí¼ÓÓû§
groupadd mysql
useradd -g mysql mysql
3£¬È¨ÏÞµÄÐÞ¸Ä
cd /usr/local/mysql
chown -Rhf mysql .
chgrp -Rhf mysql .
Ö´Ðнű¾£¬´´½¨Êý¾Ý¿â
scritps/mysql_install_db --user=mysql &
chown -Rhf root .
chown -Rhf mysql .
chown -R mysql data
chgrp -R mysql .
cp support-file/mysql.server /etc/rc.d/ini.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
<chkconfig - add mysqld>
ÑéÖ¤Æô¶¯Êý¾Ý¿â
Æô¶¯Ê§°Ü¿ÉÒÔ³¢ÊÔ£º
/etc/rc.d/init.d/mysqld stop/start
service mysqld restart
Èç¹û»¹ÊÇʧ°Ü
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
bin/mysqld_safe --user=mysql &
ÑéÖ¤³É¹¦ºó£¬Í£Ö¹mysql£¬Í£Ö¹½ø³Ì
ps -ef | grep mysql<ndb>
kill -9 ½ø³Ì±êºÅ
4£¬´´½¨ÅäÖÃÎļþ
vi my.cnf
[mysqld]
default-storage-engine=ndbcluster
ndbcluster
ndb-connectstring=10.85.0.90,10.85.0.80
[ndbd]
connect-string=10.85.0.90,10.85.0.80
[ndb_mgm]
connect-string=10.85.0.90,10.85.0.80
[ndb_mgmd]
config-file=/usr/local/mysql/config.ini
[mysql_cluster]
ndb-connectstring=10.85.0.90,10.85.0.80
5£¬´´½¨Æô¶¯Îļþ
vi config.ini
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512
StartPartialTimeout=100
StartPartitionedTimeout=100
ArbitrationTimeout=5000
TransactionDeadlockDetectionTimeout=5000
HeartbeatIntervalDbDb=5000
StopOnError=0
[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster
[ndb_mgmd]
Id=1
HostName= 10.85.0.90
[ndb_mgmd]
Id=2
Ho
Ïà¹ØÎĵµ£º
1.²é¿´µµ°¸
mysql> show binary logs;
+----------------+-----------+
| Log_name | File_size |
+----------------+-----------+
| ablelee.000001 | 150462942 |
| ablelee.000002 | 125 |
| ablelee.000003 | 106 |
+----------------+-----------+
2.ɾ³ýbin-log(ɾ³ýablelee.000003֮ǰµÄ¶øÃ»Óаüº¬ablel ......
1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
¡¡¡¡MySQL¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬ÉõÖÁÊ ......
ĿǰLAMP (Linux + Apache + MySQL + PHPspan style="font-family: Verdana;">) ½ü¼¸ÄêÀ´·¢Õ¹Ñ¸ËÙ£¬ÒѾ³ÉΪWeb ·þÎñÆ÷µÄÊÂʵ±ê×¼¡£LAMPÕâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Mag
azine”£¬Michael KunzeÔÚ1990Äê×îÏȰÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆÎªÒ»Æðʹ ......
±ÈÈ磺
insert into User values(x1,x2,x3,x4),(x1,x2,x3,x4),(x1,x2,x3,x4)
ÕâÖÖд·¨£¬ÁÐÊýÁ¿±ØÐëºÍ±íÖÐËùÓÐÁб£³ÖÒ»Ö£¬Ò²¾ÍÊÇ˵Áж¼ÒªÁгöÀ´¡£
Õâ¸öuser±íÀïÃæµÄÒ»¸ö×Ö¶Îx1ÊǸö×ÔÔö³¤×ֶΣ¬ÔòÓ¦¸ÃÌînullռλ
insert into User values(null,x2,x3,x4),(null,x2,x3,x4),(null,x2,x3,x4)
·ñÔò»á±¨´í¡£ ......