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
À´×Ô:¿ªÔ´ÖйúÉçÇø