ºìÁªLinuxÃÅ»§
Linux°ïÖú

MariaDB MaxScale 2.1 GA·¢²¼£¬Êý¾Ý¿âÖÇÄÜ´úÀí

·¢²¼Ê±¼ä:2017-05-25 09:16:48À´Ô´:ºìÁª×÷Õß:baihuo
MariaDB MaxScale 2.1 GA °æ±¾·¢²¼£¬MaxScale ÊÇ MariaDB µÄÏÂÒ»´úÊý¾Ý¿â´úÀí¡£

¸Ã°æ±¾ÒýÈëÁËÒÔÏÂÐÂÌØÐÔ£º

1¡¢¶¯Ì¬ÅäÖÃ

MaxScale 2.1 Ö§³Ö¶¯Ì¬ÅäÖà Server¡¢ monitor ºÍ listeners £¬¿ÉÔÚÔËÐÐʱÌí¼Ó¡¢Ð޸Ļòɾ³ý¡£ Ò»×éеÄÃüÁî±»Ìí¼Óµ½ maxadmin¡£

Êý¾Ý¿â·À»ðǽ¹ýÂËÆ÷£ºÏÖÔÚ¿ÉÒÔʹÓñ¾°æ±¾ÖÐÒýÈëµÄÐÂÄ£¿éÃüÁîÔÚÔËÐÐʱÐ޸ĹæÔò¡£

³Ö¾ÃÅäÖøü¸Ä£ºÔËÐÐʱÅäÖøü¸Ä½«Á¢¼´Ó¦ÓÃÓÚÔËÐÐµÄ MaxScale ²¢Ê¹ÓÃеķֲãÅäÖüܹ¹³Ö¾Ã»¯¡£

2¡¢°²È«

Ñ¡ÔñÐÔÊý¾ÝÆÁ±Î£ºÍ¨¹ýʹÓÃеÄÆÁ±Î¹ýÂËÆ÷¶ÔÃô¸ÐÊý¾Ý½øÐÐÄ£ºý´¦Àí£¬Âú×ãÄãµÄ HIPAA ºÍ PCI ¼æÈÝÐÔÐèÇó¡£

½á¹û¼¯ÏÞÖÆ£ºÍ¨¹ýʹÓà maxrows ¹ýÂËÆ÷×èֹʹÓõ¥¸ö²éѯ·ÃÎÊ´óÁ¿Êý¾Ý¼¯ - È·±£Êý¾Ý¿â·þÎñÆ÷ÃâÊܶñÒâ»òÒâÍâµÄ DoS ¹¥»÷¡£

°²È«µ¥µãµÇ¼£ºMariaDB MaxScale ÏÖÔÚÖ§³Ö LDAP / GSSAPI ÈÏÖ¤Ö§³Ö¡£

Êý¾Ý¿â·À»ðǽµÄ Prepared statement ¹ýÂË£ºÊý¾Ý¿â·À»ðǽ¹ýÂËÆ÷ÏÖÔÚÒ²½«¹ýÂ˹æÔòÓ¦ÓÃÓÚ Prepared statement¡£

Êý¾Ý¿â·À»ðǽµÄ¹¦ÄܹýÂË£ºÏÖÔÚ£¬Êý¾Ý¿â·À»ðǽ¹ýÂËÆ÷»á¸ù¾Ý´æÔڵŦÄÜÌí¼ÓÒ»¸ö¹æÔòÀ´¶Ô²éѯ½øÐа×Ãûµ¥»òºÚÃûµ¥¡£

Secure binlog server£ºMaxScale É쵀 binlog »º´æÎļþÏÖÔÚ¿ÉÒÔ¼ÓÃÜ¡£ MaxScale binlog server »¹Ê¹Óà SSL ÓëÖ÷Õ¾ºÍ´ÓÕ¾½øÐÐͨÐÅ¡£

²éѯÐÔÄÜ

²éѯ»º´æ¹ýÂËÆ÷£ºMariaDB MaxScale 2.1 ÏÖÔÚÔÊÐíÔÚ MaxScale Öлº´æ²éѯ½á¹ûÒÔʵÏÖ¿ÉÅäÖõij¬Ê±¡£Èç¹ûÒ»¸ö²éѯÔÚ»º´æÖУ¬MaxScale ½«·µ»Ø»º´æÖеĽá¹û£¬È»ºóÔÙתµ½·þÎñÆ÷ÒÔ»ñÈ¡²éѯ½á¹û¡£¾­¿ª·¢ÍŶÓÄÚ²¿²âÊÔ£¬Ê¹ÓøßËÙ»º´æ¹ýÂËÆ÷¿É½«ÐÔÄÜÌáÉýµ½ 2.0-2.1.3 ±¶¡£

Streaming insert ²å¼þ: MariaDB MaxScale 2.1 ÖеÄÒ»¸öвå¼þ½«°ÑÔÚÏÔʽÊÂÎñÖÐÍê³ÉµÄËùÓÐ INSERT Óï¾äת»»Îª LOAD DATA LOCAL INFILE ¡£

¿ÉÀ©Õ¹ÐÔ

Aurora Ⱥ¼¯Ö§³Ö£ºMariaDB MaxScale ÏÖÔÚ¿ÉÒÔÓÃ×÷ Amazon Aurora Ⱥ¼¯µÄ´úÀí¡£ÐÂÌí¼ÓµÄ monitors ¿ÉÒÔ¼ì²â Aurora Ⱥ¼¯ÖеĶÁÈ¡¸±±¾ºÍдÈë½Úµã£¬²¢Ö§³ÖÀàËÆÆäËû monitors µÄʼþ¿ÉÆô¶¯½Å±¾¡£

MySQL monitor µÄ Multi-master: ÏÖÔÚ£¬MariaDB MaxScale ¿ÉÒÔ¼ì²â MariaDB ºÍ MySQL »·¾³Öи´Ô multi-master ÍØÆË¡£

MySQL monitor ¹ÊÕÏÇл»Ä£Ê½: ¶ÔÓÚË«½ÚµãÖ÷´Ó¼¯Èº£¬MariaDB MaxScale ÏÖÔÚÔÊÐí´ÓÕ¾×÷ΪÖ÷Õ¾£¬ÒÔ·ÀԭʼÖ÷վʧ°Ü¡£

ʹÓà master pinning ½øÐжÁд²ð·Ö£ºMariaDB MaxScale 2.1 ÒýÈëÁËÒ»¸öеġ°Ò»ÖÂÐԹؼü¶ÁÈ¡¹ýÂËÆ÷¡±¡£

MaxScale ÊÇ MariaDB ¿ª·¢µÄÒ»¸öÊý¾Ý¿âÖÇÄÜ´úÀí·þÎñ£¬ÔÊÐí¸ù¾ÝÊý¾Ý¿â SQL Óï¾ä½«ÇëÇóתÏòÄ¿±êÒ»¸öµ½¶à¸ö·þÎñÆ÷£¬¿ÉÉ趨¸÷ÖÖ¸´Ôӳ̶ȵÄתÏò¹æÔò¡£

MaxScale Éè¼ÆÓÃÓÚ͸Ã÷µÄÌṩÊý¾Ý¿âµÄ¸ºÔؾùºâºÍ¸ß¿ÉÓÃÐÔ£¬Í¬Ê±Ìṩ¸ß¶È¿ÉÉìËõºÍÁé»îµÄ¼Ü¹¹£¬Ö§³Ö²»Í¬µÄЭÒéºÍ·Óɾö²ß¡£MaxScale ʹÓà C ÓïÑÔ¿ª·¢£¬ÀûÓà Linux ϵÄÒì²½ I/O ¹¦ÄÜ¡£Ê¹Óà epoll ×÷ΪʼþÇý¶¯¿ò¼Ü¡£

Èí¼þÏêÇ飺https://mariadb.com/resources/blog/whats-new-mariadb-maxscale-21

ÏÂÔصØÖ·£ºhttps://github.com/mariadb-corporation/MaxScale/tree/maxscale-2.1.3

À´×Ô:¿ªÔ´ÖйúÉçÇø
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ