Maxscale实践心得.pdf

MAXSCALE 朴昌俊 CONTENTS ▸ What’s MaxScale？ ▸ MaxScale’s Internals ▸ MaxScale Failover ▸ Data archiving with Mqfilter and Tee filters ▸ MaxScale Binlog Server ▸ MaxScale HA ▸ MaxScale Limits MAXSCALE WHAT’S MAXSCALE MAXSCALE’S INTERNALS AUTHENTICATION MAXSCALE’S INTERNALS PROTOCOL MAXSCALE’S INTERNALS MAXSCALE’S INTERNALS MONITOR MAXSCALE’S INTERNALS ROUTER MAXSCALE’S INTERNALS FILTERS FILTERS FILTER -QLA （MODULE ） MAXSCALE’S INTERNALS FILTER （MODULE ） ▸Query Log All (QLA) Filter ▸Regular Expression Filter ▸Tee Filter ▸Top Filter ▸Database Firewall Filter ▸Query Redirection Filter ▸RabbitMQ Filter FILTER -QLA/TOPN （MODULE ） ▸ MaxScale failover —Master/slave Failover Script MAXSCALE HA — FAILOVER DATA ARCHIVING WITH MQFILTER AND TEE FILTERS MAXSCALE BINLOG SERVER MAXSCALE HA ▸MaxScale-HA-with-lsyncd ▸MaxScale-HA-with-Corosync-Pacemaker MAXSCALE LIMITS 1.权限认证 2.在线无法支持所有reload config 3.连接数问题，不能连接复用 4.组件太多，导致维护成本高 5.官网自己提的限制： /kb/en/mariadb- enterprise/mariadb-maxscale/limitations-and-known- issues-within-maxscale/ MAXSCALE Q/A MAXSCALE LIMITS Thank You