Mysql½ø»¯ÂÛ2
MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇ棿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql£©¡£
¼òµ¥µÄ˵£¬¾ÍÊÇÒ»¸öMysqlÊý¾Ý¿â£¬ÓÐןܶàµÄ´æ´¢·½°¸¡£ÓÉÓÚ²»Í¬µÄ´æ´¢ÒýÇæµÄ´æ´¢·½°¸Óв»Í¬µÄÓÅÊÆÓë²»×㣬ͨ¹ý¶Ô²»Í¬µÄËÑË÷ÒýÇæµÄÖ§³Ö£¬¶ø´ïµ½¸üΪǿ´ó£¬¸üÓе¯ÐÔµÄÊý¾Ý¿â¡£
ÈÃÎÒÃÇÏÈ´ÓÈý¸öÌåϵ½á¹¹¿ªÊ¼£º
A-Mysql·Ö²ãÌåϵ½á¹¹
ÆäÖÐÓ¦ÓòãΪËùÓеÄÓû§ÌṩµÄ½Ó¿Ú£¬Âß¼²ã°üÀ¨ÁËËùÓкËÐŦÄܵÄʵÏÖ£¬ÎïÀí²ãÓÃÀ´¸ºÔð½«Êý¾Ý´æ´¢ÔÚÓ²ÅÌÉÏ¡£Í¼Öп¿ÓÒϲ»¶µÄÂß¼²ãµÄ×é³É£¬²éѯ´¦Àí×Óϵͳ£¬ÊÂÎñ¹ÜÀí×Óϵͳ£¬»Ö¸´¹ÜÀí×ÓϵͳºÍ´æ´¢¹ÜÀí×Óϵͳ¹²Í¬×é³ÉÁËMysqlµÄÂß¼²ã¡£Í¨¹ý´æ´¢¹ÜÀí(Storage Management)À´¹ÜÀíÿ¸ö´æ´¢ÒýÇæ(Storage Engine)¡£
B-ÏêϸÌåϵ½á¹¹
C-MysqlÌåϵ
MysqlÖ§³Ö¶à¸ö´æ´¢ÒýÇæÓÃÀ´¶Ô²»Í¬µÄ±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£Mysql´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎﰲȫ±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎﰲȫ±íµÄÒýÇæ¡£Äã¿ÉÒÔ°´ÕÒϲºÃͨ¹ýÅäÖÃMysqlÀ´ÔÊÐí»ò½ûÖ¹ÈÎÒ»ÒýÇæ¡£*ͨ¹ý¸ü¸ÄSTORAGE_ENGINEÀ´ÅäÖÃĬÈϵĴ洢ÒýÇæ¡£
1.MyISAM¹ÜÀí·ÇÊÂÎï±í¡£ËüÌṩ¸æËß´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡£MyISAMÔÚËùÓÐMysqlÅäÖÃÀï±»Ö§³Ö£¬ÎªMysqlĬÈϵĴ洢ÒýÇæ¡£ËüʵÔÚWeb£¬Êý¾Ý²Ö¿âºÍÆäËûÓ¦Óû·¾³ÏÂ×ʹÓõĴ洢ÒýÇæ¡£
2.MEMORY´æ´¢ÒýÇæÌṩ“ÄÚ´æÖД±í£¬±»È·¶¨ÎªHEAPÒýÇæ.MEMORY½«ËùÓÐÊý¾Ý±£´æÔÚRAMÖУ¬ÔÚÐèÒª¿ìËÙ²éÕÒÒýÓúÍÆäËûÀàËÆÊý¾ÝµÄ»·¾³Ï£¬¿ÉÒÔÌṩ¼«¿ìµÄ·ÃÎÊ¡£
3.MERGE´æ´¢ÒýÇæÔÊÐí¼¯ºÏ½«±»´¦ÀíͬÑùµÄMyISAM±í×÷Ϊһ¸öµ¥¶ÀµÄ±í¡£¾ÍÏñMyISAMÒ»Ñù£¬MEMORYºÍMERGE´æ´¢ÒýÇæ´¦Àí·ÇÊÂÎï±í£¬ÓëMEMORYÒýÇæĬÈÏ°üº¬ÓëMysqlÖС£ÔÊÐíMysql DBA»ò¿ª·¢ÈËÔ±½«Ò»ÏµÁеÈͬµÄMyISAM±íÒÔÂß¼·½Ê½×éºÏÔÚÒ»Æ𣬲¢×÷Ϊ1¸ö¶ÔÏóÒýÓÃËüÃÇ¡£¶ÔÓÚÖîÈçÊý¾Ý²Ö¿âµÈVLDB»·¾³Ê®·ÖÊʺϡ£
4.InnoDBºÍBDB´æ´¢ÒýÇæÌṩÊÂÎﰲȫ±í¡£BDB±»°üº¬ÔÚΪ֧³ÖËüµÄ²Ù×÷ϵͳ·¢²¼µÄMysql-max¶þ½øÖÆ·Ö·¢°æÖС£InnoDBҲĬÈÏ°üÀ¨ÔÚÆäÖС£InnoDB¶àÓÃÓÚÊÂÎï´¦ÀíÓ¦ÓóÌÐò£¬¾ßÓÐÖÚ¶àÌØÐÔ£¬°üÀ¨ACIDÊÂÎïÖ§³Ö¡£¶øBDB¿ÉÒÔÌæ´úInnoDBµÄÊÂÎïÒýÇ棬֧³ÖCOMMIT,ROLLBACKºÍÆäËûµÄÊÂÎïÌØÐÔ¡£
5.ECAMPLE´æ´¢ÒýÇæÊÇÒ»¸ö"´æ¸ù"ÒýÇ档ͨ¹ý´ËÒýÇæ´´½¨±í£¬µ«Ã»ÓÐÊý¾Ý±»´æ´¢ÓÚÆäÖлò´ÓÖмìË÷¡£Õâ¸öÒýÇæµÄÄ¿µÄÊÇ
Ïà¹ØÎĵµ£º
$sudo nano /etc/apparmor.d/usr.sbin.mysqld
ÔÚgeditÖÐÕÒµ½/var/lib/mysql/ÕâÁ½ÐУ¬×¢Ê͵ôÕâÁ½ÐУ¬ÔÚÕâÁ½ÐÐÇ°·Ö±ðÌí¼ÓÒ»¸ö·ûºÅ“#”¼´¿É×¢ÊÍ£¬ÔÚÕâÁ½ÐÐ֮ǰ»ò
Ö®ºó¼ÓÉÏÏÂÃæÄÚÈÝ£º
/home/mysql/ r,
/home/mysql/** rwk,
±£´æºóÍ˳ö£¬Ö´ÐÐÃüÁ
$sudo /etc/init.d/apparmor reload
·µ»ØReloading AppArmo ......
write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂ붼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......
CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42 Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68 ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMaster·þÎñÆ÷
¡¡¡¡1¡¢±à¼MasterÉϵÄ/etc/my.cnfÎļþ
¡¡¡¡¡¡ ......
ÓÅ»¯MySQL·þÎñÆ÷µÄÅäÖòÎÊý£¬¿ÉÒÔÌá¸ßMySQLÊý¾Ý¿âµÄÐÔÄÜ£¬µ«ÊǶÔÓÚÅäÖýϵ͵ķþÎñÆ÷À´Ëµ£¬ÄãÎÞÂÛÔõôÓÅ»¯ÅäÖ㬶¼²»»áµÃµ½ÀíÏëµÄЧ¹û£¬ÄǾÍÖ»ÄÜÌá¸ßÄãÓ²¼þÅäÖã¬À´³¹µ×ÓÐЧµØ¸ÄÉÆ·þÎñÆ÷µÄÐÔÄÜ¡£
¾ßÌåµÄ·½·¨ÈçÏ£º
Ò»¡¢ÔÚÉèÖÃMySQL ʱ£¬Ó¦¸ÃÅäÖÃÆäʹÓþ²Ì¬¿â¶ø²»Êǹ²Ïí¿â¡£Ê¹Óù²Ïí¿âµÄ¶¯Ì¬¶þ½øÖÆϵͳ¿É½ÚÊ¡´ÅÅ̿ռ䣬µ«¾² ......
1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔÒò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......