This section is a “How-To
” that describes the basics
for how to plan, install, configure, and run a MySQL Cluster.
Whereas the examples in
Chapter 3, MySQL Cluster Configuration
provide more in-depth
information on a variety of clustering options and configuration,
the result of following the guidelines and procedures outlined here
should be a usable MySQL Cluster which meets the
minimum
requirements for availability and
safeguarding of data.
This section covers hardware and software requirements; networking
issues; installation of MySQL Cluster; configuration issues;
starting, stopping, and restarting the cluster; loading of a sample
database; and performing queries.
Basic assumptions.
This How-To
makes the following
assumptions:
The cluster is to be set up with four nodes, each on a separate
host, and each with a fixed network address on a ty ......
½ñÔçÊÕµ½ÁËMySQLµÄÓʼþ£¬È«ÎÄÈçÏ£º
Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕߣ¬
Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL,ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚhttp://www.helpmysql.org/ru/petitionµÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵϰ£¬ÎÒÃÇÐèÒªÄúµÄ½øÒ»²½°ïÖú£º
£¨1£©ÉÌÎñ²¿·´Â¢¶Ï¾Öhttp://fldj.mofcom.gov.cn/index.shtmlÊDz¢¹º·´Â¢¶ÏÉó²éµÄÖ÷¹Ü»ú¹Ø£¬°üÀ¨±¾´Î¶Ô¼×¹ÇÎÄÊÕ¹ºÌ«Ñô΢µç×ӵķ´Â¢¶ÏÉó²é¡£Èç¹ûÄúÕýÔÚʹÓÃMySQL£¬ÄúµÄÒâ¼û½«¶ÔÓÚÉÌÎñ²¿·´Â¢¶Ï¾ÖµÄÉó²é·Ç³£ÖØÒª¡£ÎÒÃDz»ÄÜÏêϸµÄָʾÄú¸ÃÈçºÎÈçºÎ¶ÔÖ÷¹Ü»ú¹Ø·´Ó³Çé¿ö£¬ÒòΪÕâÊDz»Í×µ±µÄ¡£µ«ÊÇÎÒÃÇÈÏΪ£¬Èç¹ûÄúÄܸæËßÖ÷¹Ü»ú¹ØÄúµÄ¹«Ë¾ÈçºÎʹÓÃMySQL£¨Ê²Ã´ÏîÄ¿£¬Ê²Ã´¹æÄ£¡¢Êý¾ÝÁ÷Á¿ÒÔ¼°Ê¹ÓÃÕßÊýÁ¿µÈ£©ÒÔ¼°ÄúÈÏΪ¼×¹ÇÎÄÊÕ¹ºMySQLÖ®ºó»á²úÉúʲôÑùµÄÓ°Ï죬½«»á·Ç³£ÓÐÓá£Èç¹ûÄúÖªµÀMySQLÊǰº¹óµÄ¼×¹ÇÎÄÊý¾Ý¿âµÄÃâ·ÑÌæ´úÆ·£¬¾ÙÀýÏòÉÌÎñ²¿·´Â¢¶Ï¾Ö˵Ã÷½«»áºÜÓаïÖú¡£ÌرðÊÇ£¬ÄúÖªµÀ»òʹÓÃMySQL×÷Ϊ³ïÂ룬»òÉù³Æ½«Ê¹ÓÃMySQL£¬ÒÔ´ËÒªÇó¼×¹ÇÎÄÊý¾Ý¿â½µµÍ¼Û¸ñµÄÇé¿ö£¬ÇëÒ»¶¨ÏòÉÌÎñ²¿ËµÃ÷¡£ÎÒÃÇÏ£ÍûÄúÄÜÖ±½ÓдПøÉÌÎñ²¿·´Â¢¶Ï¾Ö£¬´«Õæ010-65198998¡£¼øÓÚÊ ......
·þÎñÆ÷ÒµÎñÀàÐÍ¶Ô±È ÐÔÄÜÆ¿¾±
DB I/O´ÅÅÌ
ת·¢·þÎñÆ÷ Íø¿¨PPS
¶¯Ì¬WEBǰ̨ CPU
¾²Ì¬WEBǰ̨ Íø¿¨ £¨Á÷Á¿£©
ACIDÔÔò
MYSQL ÒýÇæ
MYISAM ±íËø µÍ²¢·¢Ê¹Óà ·Ç´ØINDEX
INNODB ÐÐËø ¸ß²¢·¢Ê¹Óà ´ØINDEX
½¨±í£º
MYISAM
°´»ñÈ¡µÄÖµÒ»¸ö¸ö´´½¨£¬²»»á½øÐÐÅÅÐò¡£Èç 1£¬aa;13,aa;11,aa ÊäÈ룬ÔÚÊý¾Ý±íÖÐΪ1£¬aa;13,aa;11,aaÈýÌõ¼Ç¼
INNODB
½øÐÐÅÅÐòºó´´½¨¡£Èç 1£¬aa;13,aa;11,aa ÊäÈ룬ÔÚÊý¾Ý±íÖÐΪ1£¬aa;11,aa£¬13,aaÈýÌõ¼Ç¼
ÔÒòÊÇʲô£¿·Ç´ØINDEX¹ØÏµ
²éѯ
IDÊÇINDEX
MYISAM
select count(*) from xxx; ¿ì
ÒòΪÊÇͳ¼ÆÁ¿Áí´æÒ»¸ö ......
¶ÔËÑË÷ÒýÇæ¡¢ÎļþË÷Òý¡¢Îĵµ×ª»»¡¢Êý¾Ý¼ìË÷¡¢Õ¾µã±¸·Ý»òÇ¨ÒÆµÈÓ¦ÓóÌÐòÀ´Ëµ£¬¾³£Óõ½¶ÔÍøÒ³(¼´HTMLÎļþ)µÄ½âÎö´¦Àí¡£ÊÂʵÉÏ£¬Í¨¹ýPythonÓïÑÔÌṩµÄ¸÷ÖÖÄ£¿é£¬ÎÒÃÇÎÞÐè½èÖúWeb·þÎñÆ÷
»ò
ÕßWebä¯ÀÀÆ÷¾ÍÄܹ»½âÎöºÍ´¦ÀíHTMLÎĵµ¡£±¾ÎĽ«Ïêϸ½éÉÜÈçºÎÀûÓÃPythonץȡºÍ½âÎöÍøÒ³¡£Ê×ÏÈ£¬ÎÒÃǽéÉÜÒ»¸ö¿ÉÒÔ°ïÖú¼ò»¯´ò¿ªÎ»ÓÚ±¾µØºÍWeb
ÉϵÄHTMLÎĵµµÄPythonÄ£¿é£¬È»ºó£¬ÎÒÃÇÂÛÊöÈçºÎʹÓÃPythonÄ£¿éÀ´Ñ¸ËÙ½âÎöÔÚHTMLÎļþÖеÄÊý¾Ý£¬´Ó¶ø´¦ÀíÌØ¶¨µÄÄÚÈÝ£¬ÈçÁ´½Ó¡¢Í¼ÏñºÍ
CookieµÈ¡£×îºó£¬ÎÒÃÇ»á¸ø³öÒ»¸ö¹æÕûHTMLÎļþµÄ¸ñʽ±êÇ©µÄÀý×Ó£¬Í¨¹ýÕâ¸öÀý×ÓÄú»á·¢ÏÖʹÓÃpython´¦ÀíHTMLÎļþµÄÄÚÈÝÊǷdz£¼òµ¥µÄÒ»¼þ
ÊÂÇé¡£
¡¡¡¡Ò»¡¢½âÎöURL
¡¡¡¡Í¨¹ýPythonËù´øµÄurlparseÄ£¿é£¬ÎÒÃÇÄܹ»ÇáËɵذÑURL·Ö½â³ÉÔª¼þ£¬Ö®ºó£¬»¹Äܽ«ÕâЩԪ¼þÖØÐÂ×é×°³ÉÒ»¸öURL¡£µ±ÎÒÃÇ´¦ÀíHTML ÎĵµµÄʱºò£¬ÕâÏÄÜÊǷdz£·½±ãµÄ¡£
¡¡¡¡
import
urlparse
¡¡¡¡parsedTuple
=
urlparse.urlparse(
¡¡¡¡
"
http://www.google.com/search?
¡¡¡¡hl
=
en
&
q
=
urlparse
&
btnG
=
Google
+
Search
"
)
¡¡¡¡unparsedURL
=
urlparse.urlunparse((URLscheme, \
¡¡¡¡URLlocat ......
ADOÖÐsqlserver´æ´¢¹ý³ÌʹÓà ÊÕ²Ø
´ÓADOÖеõ½¶à¸ö¼Ç¼¼¯ÒÔ¼°ÔõôÑùÔÚADOÖÐʹÓÃsql server µÄ´æ´¢¹ý³Ì
DataType Value Length Data Length
BIGINT 996857543543543 15 8
INT 543543 6 4
SMALLINT 32765 5 2
TINYINT 254 3 1
BIT True 1 1
DECIMAL 765.5432321 11 9
NUMERIC 432.6544 8 5
MONEY 543.1234 6 8
SMALLMONEY 543.1234 6 4
FLOAT 5.4E+54 8 8
REAL 2.43E+24 9 4
DATETIME 8/31/2003 11:55:25 PM 19 8
SMALLDATETIME 8/31/2003 11:55:00 PM 19 4
CHAR QWE 3 4
VARCHAR Variable! 9 9
TEXT 307
NCHAR WIDE 4 8
NVARCHAR 0 0
NTEXT 614
GUID {58F94A80-B839-4B35-B73C-7F4B4D336C3C} 36 16
Return Value: 0
CREATE PROCEDURE "dbo"."DataTypeTester"
@myBigInt bigint
, @myInt int
, @mySmallint smallint
, @myTinyint tinyint
, @myBit bit
, @myDecimal decimal(10, 7)
  ......
JavaScript ÊǸù¾Ý "ECMAScript"±ê×¼ÖÆ¶¨µÄÍøÒ³½Å±¾ÓïÑÔ¡£Õâ¸ö±ê×¼ÓÉ ECMA ×éÖ¯·¢Õ¹ºÍά»¤¡£ECMA-262
ÊÇÕýʽµÄ JavaScript ±ê×¼¡£Õâ¸ö±ê×¼»ùÓÚ JavaScript (Netscape) ºÍ JScript
(Microsoft)¡£Netscape (Navigator 2.0) µÄ Brendan Eich ·¢Ã÷ÁËÕâÃÅÓïÑÔ£¬´Ó 1996
Ä꿪ʼ£¬ÒѾ³öÏÖÔÚËùÓÐµÄ Netscape ºÍ Microsoft ä¯ÀÀÆ÷ÖС£ECMA-262 µÄ¿ª·¢Ê¼ÓÚ 1996 Ä꣬ÔÚ 1997 Äê 7
Ô£¬ECMA »áÔ±´ó»á²ÉÄÉÁËËüµÄÊ׸ö°æ±¾¡£
±¾ÏµÁн̳ÌÖ¼ÔÚÏò´ó¼Ò·ÖÏí±¾È˵±ÄêѧϰJavascriptµÄ±Ê¼ÇºÍÐĵᣱ¾ÏµÁн̳ÌÔ¤¼Æ·ÖÎå¸ö²¿·Ö¡£
µÚÒ»²¿·Ö£ºJavascriptÄÚÖöÔÏó¡£
µÚ¶þ²¿·Ö£º¿Í»§¶ËJavaScript¡£
µÚÈý²¿·Ö£ºÎĵµ¶ÔÏóÄ£ÐÍ¡£
µÚËIJ¿·Ö£ºÃæÏò¶ÔÏó·â×°¼°±Õ°üµÄÓ¦Óá£
µÚÎ岿·Ö£ºÏµÁÐרÌâ(ÕýÔò±í´ïʽ£¬¿ò¼Üѧϰ£¬etc...)¡£
JavascriptÆäʵ²»ÊÇÒ»ÖÖÍêÈ«µÄÃæÏò¶ÔÏóµÄÓïÑÔ£¬×¼È·µÄ˵£¬Ó¦¸ÃÊÇÒ»ÖÖ»ùÓÚ¶ÔÏóµÄ±à³ÌÓïÑÔ£¬¾¡¹ÜÎÒÃÇ¿ÉÒÔÄ£ÄâÃæÏò¶ÔÏóµÄÌØÐÔ£¬µ«ÊÇÒ»µ©ÍÑÀë
ËüµÄÈÝÆ÷¼°Ò»Ð©»ù±¾µÄ¶ÔÏó×é¼þ£¬Javascript½«´ç²½ÄÑÐС£Èç¹ûȱÉÙDOM×é¼þµÄÖ§³Ö£¬ÎÒÃǾÍÎÞ·¨Ð´³öÓÅÑŽ»»¥ÐÔÁ¼ºÃµÄÓû§½çÃæ£¬Èç¹ûȱÉÙ
XMLHTTPRequest×é¼þµÄÖ§³Ö£¬ÎÒÃǽ«ÎÞ·¨ÊµÏÖ½»»¥ÐÔÁ¼ºÃµÄAjax¿Í»§¶Ë³ÌÐò¡£ËùÒÔ£¬ÒªÑ§ºÃJa ......