mysql Êý¾Ý´æ´¢×ܽá
ÓÉÓÚ×î½üÒ»Ö±ÔÚÁ˽âmysql¡£¸÷ÖÖ±íÀàÐ͵ÄÊý¾Ý´æ´¢ÒÔ¼°Ïà¹ØÏÞÖƾÍÊDZØÐëÁ˽âµÄ·½ÃæÁË¡£
×Ô¼ºµÄ·þÎñÆ÷»·¾³£ºOS Cent OS ext3£¬memory 4G£¬ disk 2T block size 4K¡£
¾µ÷²é£¬linuxÏÂÎļþ×î´óÊÇ´æÔÚÏÞÖƵġ£È¥googleÉÏËÑÁËËÑ£¬´ó¼Ò˵·¨²»Ò»£¬×îÖÕ×Ô¼º»¹ÊÇÕÒµ½±È½Ï¹Ù·½µÄ˵¡£Ïê¼ûhttp://en.wikipedia.org/wiki/Ext3 ËùÒÔ×Ô¼ºµÄ·þÎñÆ÷×î´óÎļþÏÞÖÆΪ2T¡£
Õâµã¸ãÇå³þºó£¬ÔÚÊý¾Ý¿â²¿ÊðÉè¼ÆÉϾ͵ÿ¼Âǵ½Õâµã¡£
¼òµ¥ËµÒ»ÏÂ×Ô¼ºµÄÊý¾Ý¿â¼Ü¹¹£¬ÊDzÉÓñȽÏͨÓúͳÉÊìµÄ×ö·¨£¬¼´£º2¸ömaster£¬Ö®¼ä´æÔÚHA£»N¸öslaves£¬¸ºÔØ·Öµ£¶ÁµÄ¸ºÔØ¡£masterºÍslaves²ÉÓÃreplicationÒ첽ͬ²½¡£masterÉϵÄÊý¾Ý¿â±íÀàÐÍΪinnodb£¬¸ÃÀàÐÍÓÐÊÂÎïµÄ¸ÅÄ²¢ÇÒÊʺÏƵ·±¶Áд¡£slavesÊý¾Ý¿â²ÉÓÃmyisam±íÀàÐÍ£¬¿ÉÒÔ¸üºÃµÄ´¦Àí¶ÁÇëÇó¡£ËùÒÔÔÚ´ËÌÖÂÛÕâÁ½ÖÖÀàÐÍÊý¾ÝµÄ´æ´¢ÐÎʽ¡£
innodbĬÈϵÄÊǹ²Ïí±í¿Õ¼äµÄ£¬ÕâµãÔÚmysql¹Ù·½ÍøÕ¾ÎĵµÉÏÓкÜÃ÷È·µÄ˵Ã÷¡£ÎҾͲ»·Ñ»°ÁË¡£Èç¹û²ÉÓù²Ïí±í¿Õ¼ä£¬¿ÉÒÔÅäÖöà¸öÊý¾ÝÎļþµ½²»Í¬µÄ´ÅÅÌ£¬À´½â¾öÊý¾Ý´æ´¢Æ¿¾±¡£µ«ÊÇ×Ô¼ºÊ¼ÖÕ¾õµÃ£¬´óÎļþ²¢²»Ì«ÀûÓÚά»¤£¬ÀïÊý¾ÝÒƶ¯µÈ¡£ËùÒÔ»¹¿ÉÒÔ²ÉÓÃper-table±í¿Õ¼ä£¬µ«ÊÇÎÊÌâÓÖ¾ÍÀ´ÁË£¬Ã¿¸ö±íµÄÊý¾ÝºÃÏñÖ»ÄÜ´æ´¢µ½mysqlÅäÖõÄÊý¾ÝĿ¼ÄÚ¡£Õâµã×Ô¼ºÃ»ÓÐÕÒµ½ºÏÊʵĽâ¾ö·½°¸¡£
myisam±íÀàÐÍ£¬ËüµÄindex±íºÍdata±í¶¼ÊÇ¿ÉÒÔÔÚcreate tableµÄʱºòÖ¸¶¨Â·¾¶µÄ¡£ËùÒÔÎÒÃÇ¿ÉÒÔÖ¸¶¨µ½²»Í¬µÄ´ÅÅÌÉÏ£¬½â¾öδÀ´µÄÊý¾Ý´æ´¢Æ¿¾±¡£ºÜ¼òµ¥ºÜÇ¿´ó¡£
Ïà¹ØÎĵµ£º
<!--#include file="zheboconn.asp"-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>aspºÍmysql·ÖÒ³´úÂë</title>
<style type="text/css">
<!--
.STYLE3 {
fon ......
ÕâÀ½éÉÜÒ»ÏÂCentOSÏÂMySQLÊý¾Ý¿â·þÎñÆ÷µÄ¹¹½¨·½·¨¡£
°²×°MySQL¼°Ïà¹Ø×é¼þ
¡¡¡¡Ê×ÏÈ£¬°²×°MySQL¡£
[root@sample ~]#
yum
-y install mysql-server
¡¡ ← °²×°MySQL
Setting up Install Process
Setting up repositories
dag 100% |=========================| 1.1 kB 00:00
update ......
MySQL Workbench ÊÇ MySQL ×î½üÊͷŵĿÉÊÓÊý¾Ý¿âÉè¼Æ¹¤¾ß¡£Õâ¸ö¹¤¾ßÊÇÉè¼Æ MySQL Êý¾Ý¿âµÄרÓù¤¾ß¡£
ÄãÔÚ MySQL Workbench Öн¨Á¢µÄ±»³Æ֮ΪÎïÀíÊý¾ÝÄ£ÐÍ¡£Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍÊÇÕë¶ÔÒ»¸öÌض¨ RDBMS ²úÆ·µÄÊý¾ÝÄ£ÐÍ£»±¾ÎÄÖеÄÄ£Ðͽ«¾ßÓÐһЩ MySQL µÄ¶ÀÌع淶¡£ÎÒÃÇ¿ÉÒÔʹÓÃËüÉú³É£¨forward-engineer£©Êý¾Ý¿â¶ÔÏ󣬳ýÁË°üº¬± ......
Ê×ÏÈ·ÅÖúÃjdbcÇý¶¯³ÌÐò£¬ÔÚ java\jre6\lib\ext\Ï£¬java\jdk1.6\jre\libµÈµØ·½¶¼·ÅÆðÀ´£¬ÒòΪ²»È·¶¨ÔÚÄÄÀïÓÐÓ÷··
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost/DATABASENAME?user=USERNAME&password=PASSWORD&useUnicode=tru ......