Introduction to Configuring and Using MariaDB MaxScale: Database Proxy Made Simple
summary
MariaDB MaxScale is a proxy that routes SQL traffic, proven in the demo with three backend servers: a single primary and two replicas. Configuration lives in /etc/maxscale.cnf and requires a MaxScale DB user with specific grants; listener default examples use port 4006. Key features shown are read-write splitting (statement routing or read connection router per-port mode), auto failover with automatic promotion and rejoin (stopping the primary promotes a replica and the original rejoins), plus dynamic reloads for cache and SSL.
AI-written summary · about
chapters (8)
- 0:00Intro
- 0:22MaxScale Overview
- 4:07How it works
- 5:00Supported OS and DB
- 7:01Configuration
- 14:51Routers
- 19:40Database HA
- 22:38Demo
related talks
37mScale MySQL beyond limits with ProxySQL
48mMySQL Load Balancers - MaxScale, ProxySQL, HAProxy, MySQL Router & nginx - a close up look
25mThe future of databases: Combining operational and analytical data at massive scale
08mMySQL as a Layered Service: How to use Proxy SQL to Control Traffic and Scale Out
12mMariaDB at Percona
58mIntroducing ScaleDB, the New Clustered, Distributed Storage Engine for MySQL (Part 1)
26mSoar Higher With MariaDB SkySQL - The Ultimate MariaDB Cloud
20mMigrating MariaDB Cluster to ARM