Maxscale

The MySQL High Availability Landscape in 2017 (the Babies)

MySQL High Availability

This post is the third of a series focusing on the MySQL high availability solutions available in 2017.
The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and mature technologies. In this post, we will look […]

Read more

Read-write split routing in MaxScale

Read-write split routing performance in MaxScale

In this blog post, we’ll discuss read-write split routing in MaxScale.
The two previous posts have shown how to setup high availability (HA) with Maxscale using asynchronous replication and how we monitor replication.
Now let’s focus on the routing module performing read-write splits.
This is our current configuration:

Shell

[Splitter Service]
type=service
router=readwritesplit
servers=percona1, percona2
max_slave_replication_lag=30
user=maxscale
passwd=264D375EC77998F13F4D0EC739AABAD4

1234567

[Splitter Service]type=servicerouter=readwritesplitservers=percona1, percona2max_slave_replication_lag=30user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4

This router module is designed to spread […]

Read more

How MaxScale monitors servers

maxscale monitors servers

In this post, we’ll address how MaxScale monitors servers. We saw in the
We saw in the previous post how we could deal with high availability (HA) and read-write split using MaxScale.
If you remember from the previous post, we used this section to monitor replication:

Shell

[Replication Monitor]
type=monitor
module=mysqlmon
servers=percona1, percona2, percona3
user=maxscale
passwd=264D375EC77998F13F4D0EC739AABAD4
monitor_interval=1000
script=/usr/local/bin/failover.sh
events=master_down

123456789

[Replication Monitor]type=monitormodule=mysqlmonservers=percona1, percona2, percona3user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4monitor_interval=1000script=/usr/local/bin/failover.shevents=master_down

But what are […]

Read more

High availability with asynchronous replication… and transparent R/W split

High availability with asynchronous replication

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication.
When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ?
Description:

Three MySQL servers, […]

Read more