Read-Write splitting with MaxScale

In this video, Alejandro Duarte demonstrates how to configure MariaDB MaxScale, an intelligent database proxy that powers SkySQL, to perform transparent read-write splitting for applications.

Links:

0:00 Intro
0:35 What is a database proxy?
1:54 Replication setup
2:31 Installing MaxScale
2:49 Preparing the MariaDB servers for MaxScale
3:49 Configuring MaxScale for read-write splitting
5:46 Starting MaxScale
6:06 MaxScale GUI
7:45 Testing read-write splitting
9:15 Connecting to MaxScale from SQL clients or apps

#MariaDB #Database #Data #Replication #Scaling

MariaDB is making a big impact on the world. Whether you’re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan, or ordering takeout–MariaDB is the backbone of applications used every day. Companies small and large, including 75% of the Fortune 500 run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments, and public clouds, MariaDB is uniquely positioned as the leading database for modern application development.

[cyclomiha]

If your DB load is high - I mean +50k/sec selects + 10k/sec inserts/updates/deletes - put your MaxScale on your "Web service" node(s). That saves extra network hop and increases performance approx 30%. Use also unix socket instead of TCP port for MaxScale listening port - that prevents exposing the listening port to network.