MySQL社区

 找回密码
 注册

QQ登录

只需一步,快速开始

扫一扫,访问微社区

搜索
查看: 3036|回复: 0

[负载] MySQL Router

[复制链接]
发表于 2015-12-25 14:36:57 | 显示全部楼层 |阅读模式
mysql_router.png

MySQLRouter is lightweight middleware that provides transparent routing between yourapplication and any backend MySQL Servers. It can be used for a wide variety ofuse cases, such as providing high availability and scalability by effectivelyrouting database traffic to appropriate backend MySQL Servers. The pluggablearchitecture also enables developers to extend MySQL Router for custom usecases.

Failover
Typically,a highly available MySQL setup consists of a single master and multiple slavesand it is up to the application to handle failover, in case the MySQL masterbecomes unavailable. Using MySQL Router, application connections will betransparently routed based on load balancing policy, without implementingcustom application code.

Load Balancing
MySQLRouter provides additional scalability and performance by distributing databaseconnections across a pool of servers. For example, if you have a replicated setof MySQL Servers, MySQL Router can distribute application connections to themin a round-robin fashion.

Pluggable Architecture
MySQLRouter's pluggable architecture allows MySQL developers to easily extend theproduct with additional features, as well as providing MySQL users with theability to create their own custom plugins providing endless possibilities.MySQL Router currently ships with a number of core plugins, including:
  • Connection     Routing plugin which does connection-based routing, meaning that it     forwards the MySQL packets to the backend server without inspecting or     modifying them, thus providing maximum throughput.
  • The Fabric Cache plugin     which provides transparent MySQL Fabric support to your applications for     additional High Availability, and data Sharding.


您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|申请友链|小黑屋|Archiver|手机版|MySQL社区 ( 京ICP备07012489号   
联系人:周先生; 联系电话:17896003451

GMT+8, 2017-5-29 17:39 , Processed in 0.247709 second(s), 30 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表