UbuntuÏÂÅäÖÃÍøÂ磬°²×°mysql£¬jdk
sudo apt-get install mysql-server mysql-client
sudo apt-get install sun-java6-jdk(°²×°³öÒâÍ⣬sudo dpkg -P sun-java6-bin£¬È»ºóÖØÐ°²×°)
sudo vi /etc/network/interfaces ÅäÖÃÍøÂç
auto eth0
iface eth0 inet dhcp(static)
address 192.168.8.108
netmask 255.255.255.0
gateway 192.168.8.1
£ºx±£´æ
sudo ifconfig eth0 down (up)¹Ø±ÕºÍÆô¶¯
sudo /etc/init.d/networking restart
-----------------------------------
Ô¶³ÌÊÚȨ·ÃÎÊmsyql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.8.108' IDENTIFIED BY '' WITH GRANT OPTION ;
etc/mysql/my.cnf×¢Ê͵ô bind 127.0.0.1
ÖØÐÂÆô¶¯mysql :sudo /etc/init.d/mysql restart
---------------------------------------------
Ïà¹ØÎĵµ£º
ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£
ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡
´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ² ......
±íÉè¼Æ·½Ã棺
1¡¢×Ö¶ÎÃû¾¡Á¿¼ò»¯£¬²»Òª³¬¹ý18¸ö×Ö·û
2¡¢Ê¹Óþ¡Á¿Ð¡µÄÊý¾ÝÀàÐÍ£¬ÀýÈ磺MEDIUMINT±ÈINTÉÙÕ¼ÓÃ25%¿Õ¼ä
3¡¢×Ö¶ÎÀàÐÍÓ¦¾¡Á¿±ÜÃâÉèÖóɿɱ䳤¶È£¬È磺VARCHAR¡¢BLOB¡¢TEXT
4¡¢ÓÃÓڱȽϵIJ»Í¬×ֶΣ¬Ó¦ÉèÖÃÏàͬµÄÀàÐͼ°³¤¶È
5¡¢¾¡¿ÉÄܽ«×Ö¶ÎÉùÃ÷ΪNOT NULL£¬²¢Ö¸¶¨DEFAULT
6¡¢Ö÷Ë÷Òý¾¡¿ÉÄܶÌ
7¡¢½ö´´½¨ÕæÕý ......
[ת mysql°²È«ÉèÖÃ]
ʹÓÃMySQL£¬°²È«ÎÊÌâ²»Äܲ»×¢Òâ¡£ÒÔÏÂÊÇMySQLÌáʾµÄ23¸ö×¢ÒâÊÂÏ
1.Èç¹û¿Í»§¶ËºÍ·þÎñÆ÷¶ËµÄÁ¬½ÓÐèÒª¿çÔ½²¢Í¨¹ý²»¿ÉÐÅÈεÄÍøÂ磬ÄÇô¾ÍÐèҪʹÓÃSSHËíµÀÀ´¼ÓÃܸÃÁ¬½ÓµÄͨÐÅ¡£
2.ÓÃset passwordÓï¾äÀ´ÐÞ¸ÄÓû§µÄÃÜÂ룬Èý¸ö²½Ö裬ÏÈ“mysql -u root”µÇ½Êý¾Ý¿âϵͳ£¬È»ºó“my ......
Òª備·Ý MySQL 資ÁÏ庫Ö÷Òª·Ö為兩個·½·¨£¬Ò»ÊÇ將資ÁÏ庫Ä¿錄ÍêÕû備·Ý£º¶þÊÇʹÓà MySQL 內½¨µÄ mysqldump ³Ìʽ¡£
備·Ý資ÁÏ庫Ä¿錄
MySQL 預設µÄ儲´æÄ¿錄ÔÚ /var/lib/mysql 內ÈÝ£¬µ×ÏÂ會 ......
MySQL Cluster
is a technology that enables
clustering of in-memory databases in a shared-nothing system. The
shared-nothing architecture allows the system to work with very
inexpensive hardware, and with a minimum of specific requirements
for hardware or software.
......