Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MysqlÌæ´ú½â¾ö·½°¸Cassandra

http://incubator.apache.org/cassandra/
http://zh.wikipedia.org/wiki/Cassandra
Apache CassandraÊÇÒ»Ì׿ªÔ´·Ö²¼Ê½Êý¾Ý¿â¹ÜÀíϵͳ¡£Ëü×î³õÓÉFacebook¿ª·¢£¬ÓÃÓÚ´¢´æÌرð´óµÄÊý¾Ý¡£
Ö÷ÒªÌØÐÔ£º
·Ö²¼Ê½
»ùÓÚcolumnµÄ½á¹¹»¯
¸ßÉìÕ¹ÐÔ
CassandraµÄÖ÷ÒªÌØµã¾ÍÊÇËü²»ÊÇÒ»¸öÊý¾Ý¿â£¬¶øÊÇÓÉÒ»¶ÑÊý¾Ý¿â½Úµã¹²Í¬¹¹³ÉµÄÒ»¸ö·Ö²¼Ê½ÍøÂç·þÎñ£¬¶ÔCassandra µÄÒ»¸öд²Ù×÷£¬»á±»¸´ÖƵ½ÆäËû½ÚµãÉÏÈ¥£¬¶ÔCassandraµÄ¶Á²Ù×÷£¬Ò²»á±»Â·Óɵ½Ä³¸ö½ÚµãÉÏÃæÈ¥¶ÁÈ¡¡£¶ÔÓÚÒ»¸öCassandraȺ¼¯À´Ëµ£¬À©Õ¹ÐÔÄÜÊDZȽϼòµ¥µÄÊÂÇ飬ֻ¹ÜÔÚȺ¼¯ÀïÃæÌí¼Ó½Úµã¾Í¿ÉÒÔÁË¡£


Ïà¹ØÎĵµ£º

[ÔÓ¼Ç] ÐÂÄêÎïÓï&¹ØÓÚMysqlÒýÇæÐÔÄܲâÊÔ

æµµÄ2009ÖÕÓÚ¹ýÈ¥£¬Ò²ÖÕÓÚ°ÑÈËÉú´óÊÂæÍêÁË£¬»Øµ½Õý³£µÄ¹¤×÷Éú»îÖÐÀ´¡£2010¶ÔÎÒÀ´ËµÓ¦¸ÃÊdzäÂúÐÂÆÚÍûµÄÒ»Ä꣬ÐÂµÄÆõ»ú¾ÍÔÚÑÛǰ£¬¼ÓÓÍŬÁ¦°É~
ÁíÍâ×¼±¸12¸öÔÂÖ®ºóÔÙÀ´×ܽáһϽñÄêµÄÖØ´óʼǣ¬ºÇºÇ~
˳±ã¿´µ½Ò»¸öMysqlµÄ²âÊÔÎÄÕ£¬¸Ð¾õ»¹ÂúÓвο¼¼ÛÖµµÄ£¬ÓÚÊǼǼÏÂÀ´ÒÔ±ã²Î¿¼¡£
ÒÔÏÂÊÇÒ»¸öMySQLÖÐMyISAMÒýÇæÓëInnoDBÒ ......

Mysql ѧϰ±Ê¼Ç

 ÏÔʾËùÓÐÊý¾Ý¿â show databases;
 ´´½¨Êý¾Ý¿â create dababase stu;
 É¾³ýÊý¾Ý¿âdrop database stu;
 Çл»µ½Êý¾Ý¿âuse stu;
 È¡µÃµ±Ç°µÄÊý¾Ý¿â,´ø£¨£©±íʾº¯Êý:select database();
´´½¨±í£¨ÒªÇл»µ½Êý¾Ý¿âÖУ©
mysql> create table stu_info(
   
-> stu_id int(8) ......

mysql Ð޸ıí½á¹¹

1. mysql Ð޸ıíÃû×Ö
    ALTER TABLE t1 RENAME t2;
2. ÐÞ¸ÄÁеÄÃû×Ö
    >ALTER TABLE stock CHANGE COLUMN stock_id id INT(6);
3. Ôö¼ÓÁÐ
    >ALTER TABLE ab ADD COLUMN id INT(3);
4. ¼õÉÙÁÐ
   >ALTER TABLE ab DROP COLUMN id;
5. ÐÞ¸ÄÁ ......

Tomcat5+MysqlÎÄÖÐÂÒÂëÎÊÌâµÄ½â¾ö·½·¨ (ת)


Tomcat ÏÂ×îÈÝÒ×µ½µÄÎÊÌâ¾ÍÊÇÖÐÎÄÂÒÂëÎÊÌâÁË , ÏÂÃæ¾ÍÀ´Ì¸Ì¸ÎÒÔÚ Windows +Tomcat5 Ïµ÷ÊÔ JSP ³ÌÐòʱ , ËùÅöµ½µÄÎÊÌâÒÔ¼°½â¾ö°ì·¨¡£
       Õâ´Îµ÷ÊÔËùÓöµ½µÄÂÒÂëÎÊÌâÖ÷ÒªÓÐÈýÀࣺ
Ò»¡¢ Ò³Ãæ×Ö·ûÂÒÂë¡£
¼´Õû¸öÒ³Ãæ³öÏÖºº×ÖÂÒ ......

SSH+MySQL¿ª·¢ÖеÄÖÐÎÄÂÒÂëÎÊÌâ

Ò»¡¢±íµ¥Ìá½»ÂÒÂë½â¾ö·½·¨
    ±íµ¥Öк¬ÓÐÖÐÎÄÌá½»ÂÒÂ룬¶ÔÓÚ×ÖĸºÍÊý×ÖÔò²»»áÂÒÂ룬ÎÒÑ¡ÓõÄ×Ö·û¼¯utf-8(ÒÔÏÂͬ)¡£
 1¡¢ÔÚapache-tomcat-6.0.18\webapps\examples\WEB-INF\classes\filtersĿ¼ÏÂÕÒµ½ÎļþSetCharacterEncodingFilter.java ºÍRequestDumperFilter.javaÎļþ£¬²¢½«Æä¸´ÖƵ½ÏîÄ¿src ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ